What TDS is becomes practical when a SQL Server connection fails: it carries login and query traffic, packet settings, and encryption negotiation.
Index Usage Snapshots: Reject Invalid Counter Deltas
Index usage snapshots require a valid counter window. Keep missing rows and lifecycle gaps visible. The guarded example rejects invalid pairs before calculating any activity delta.
SQL SERVER – Remove Duplicate Entry from Comma Delimited String – UDF
A simple UDF from reader Ashish Jain that removes duplicate entries from a comma delimited string by turning it into a table and using DISTINCT.
SQL SERVER – Find Number of Rows and Disk Space Reserved – Using sp_spaceused Interesting Observation
sp_spaceused shows the row count of a table and the disk space reserved. Here is why its numbers looked wrong on AdventureWorks and how @updateusage fixed them.
SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL
A quick script using sys.dm_db_partition_stats that lists the row count of every table and shows the largest table in database right at the top.
How to Ask a SQL Question That Actually Gets Answered
Want a fast answer? Here’s how to ask a SQL question with a small script, the exact error and the expected result, so helpers can answer.
SQL SERVER – Top Five Articles of Year 2008
My Top 5 Articles of year 2008 from SQLAuthority.com and pinaldave.com, led by the most visited page: the SQL Server 2008 interview questions and answers list.