Here we are with another fascinating episode of the SQL Friday, The Best SQL Server Links Of The Past Week show. I can’t believe it is week 10 already, if I continue like this I will be retired soon…..or just tired without the re prefix.
Here is what I found interesting this past week in SQL Land:
Mike explains some concepts about shrinking and the transaction log
String comparison: binary vs. dictionary
Linchi Shea writes: t is well known that you get better performance if you compare two strings in a binary collation than in a dictionary collation. But is the performance difference significant enough to warrant the use of an explicit COLLATE clause in the string comparison expression?
Get a Quick Review of SQL Server Information
Allen White shows us how you can use PowerShell and SMO to get some information about your SQL Servers
Much ado about logins and SIDs
Greg Low explains what you have to do to SQL Server logins that need to be moved between servers
Back To Basics: Clustered vs NonClustered Indexes; what’s the difference?
Denny Cherry highlights some differences between Clustered and NonClustered Indexes
What the heck is a SQL Server HOBT, anyway?
Aaron Alton explains what a HOBT aka Heap Or B-Tree is, so we are not talking about hobbits
Having written about this myself a while back here: http://sqlblog.com/blogs/denis_gobo/archive/2007/05/29/test.aspx
It was nice to see that Michelle Ufford did a nice job of explaining Bitwise Operations in T-SQL
Some Simple Code To Show The Difference Between Newid And Newsequentialid
Someone who thinks he is me 🙂 wrote a post showing why NEWID() is Evil
Index columns, selectivity and inequality predicates
Gail Shaw shows us how how selectivity and index column order affect inequality predicates.
That is it for this week, I will tag the weekly posts with SQL Friday in case you want to see the whole archive in the future
*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
