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:
All indexes are unique
Gail Shaw tells us about the uniquefier which makes indexes unique
Performance impact: a large number of virtual log files – Part I
Performance impact: a large number of virtual log files – Part II
Linchi Shea’s two part post explores two questions
1. Is a large number of VLFs in a transaction log still a significant performance factor in SQL Server 2008?
2. Does a large number of VLFs have an adversely impact on application-related operations such as INSERT, UPDATE, and DELETE?
Released: SQL Server 2008 Extended Events Manager
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.
Bit vs. Char(1) in SQL Server
Aaron Alton shows us some reasons why bits rock, and I agree with him
Estimating Rows per Page
Michelle Ufford shows us some code which we can use to estimate rows per page
How It Works: File Stream Compression with Backup/Restore
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