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
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
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?
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.
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
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
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.
