Identifying unique indexes that aren’t defined as unique
A SQL Server script to find non-unique indexes where the underlying data is currently distinct, identifying candidates for unique index conversion.
Read more →Posts
SQL Breakfast
How a team Tech Breakfast watching Kimberly Tripp's Indexing Internals session turned into a great way to learn and spark discussion.
Read more →
Our SQL Server “Denali” experiences – Part 2
Load testing SQL Server Denali at Trade Me with impressive results, handling 50% of search traffic and solving full-text performance issues from SQL 2008.
Read more →
Snapshot isolation and tempdb growth
How an orphaned session under READ_COMMITTED_SNAPSHOT caused tempdb to balloon to 15GB by preventing the version store from flushing.
Read more →
Our SQL Server “Denali” experiences – Part 1
Installing SQL Server Denali on a production read-only server at Trade Me, covering replication setup and full-text index configuration.
Read more →
Where am I?
A tip for verifying which SQL Server instance you're connected to in SSMS, after encountering a bug where the displayed server name was wrong.
Read more →
Public speaking jitters
Lessons from a first-time joint presentation at the Wellington SQL Server User Group, with practical tips for new speakers.
Read more →