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

*** If you have a SQL related question try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum