Time for another 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:
How To Get High Quality Information About Query Performance
Elisabeth Redei shows us how you can use the profiler, dynamic management views and SQLNexus to get high quality information about your query performance
The PSS SQL Server Engineers have a post about how the Performance Counter Collection Components work
Sparse File Errors: 1450 or 665 due to file fragmentation: Fixes and Workarounds
The PSS SQL Server Engineers have a blogpost showing you what they fixed in regards to Sparse File Errors: 1450 or 665 due to file fragmentation
SQL Server And NULL Values, Revisited
Do you love or do you hate NULLs, Are you scared of NULLs? Aaron Alton has a nice post about NULLs….and don’t be scared of NULLs
Steps to Troubleshoot Connections to your SQL ServerDenny Cherry outlines some thoubleshooting steps that people should take in order to find out what the problem is with connecting to SQL Server.
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.
