The Ahmedabad User Group Meeting on January 17, 2009 has three back to back talks: query optimization, index usage with ORDER BY, and the MERGE statement.
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.
Always Encrypted in Plain Words
Explain Always Encrypted in plain words, including client-held keys, deterministic and randomized encryption, query limits, and operations.