Here we are with another mesmerizing episode of the SQL Friday, The Best SQL Server Links Of The Past Week show.
Here is what I found interesting this past week in SQL Land:
Gail Shaw tells us about the uniquefier which makes indexes unique
Linchi Shea’s two part post explores two questions
Is a large number of VLFs in a transaction log still a significant performance factor in SQL Server 2008?
Does a large number of VLFs have an adversely impact on application-related operations such as INSERT, UPDATE, and DELETE?
Jonathan Kehayias writes: This started out as a pet project in August 2008 when I decided that if I was ever going to get good use out of Extended Events in SQL Server 2008, I needed to be able to see the layout of the metadata graphically. What started out as a simple TreeView that displayed the MetaData in a sensible (at least to me) manner slowly began to transform into a complete application that could build and manage Extended Event Sessions as well.
Aaron Alton shows us some reasons why bits rock, and I agree with him
Michelle Ufford shows us some code which we can use to estimate rows per page
The PSS SQL Server Engineers show how File Stream Compression compression works with Backup/Restor
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