Good indexes and a tuned query still ran slow because auto update of statistics was off. Enable Automatic Statistic creation and update, then update all stats.
SQLAuthority News – First Editorial – T-SQL Challenges Beginners
Welcome to the first editorial for T-SQL Challenges for Beginners, puzzles that make you use your brain cells instead of just reading articles online.
SQL SERVER – Comic Slow Query – SQL Joke
After Community TechDays in Ahmedabad, many asked for the Comic Slow Query strips I showed in my index session. Here are both, one from before and one after.
SQL SERVER – Query Optimization – Remove Bookmark Lookup – Remove RID Lookup – Remove Key Lookup – Part 3
Part 3 of how to Remove Bookmark Lookup, RID Lookup and Key Lookup. A covering index holds every column the query uses in SELECT, JOIN and WHERE.
Connecting PHP to SQL Server
Connecting PHP to SQL Server means choosing SQLSRV or PDO_SQLSRV, binding parameters, validating TLS, and keeping web queries efficient.
The Implicit Conversion That Quietly Kills Your Index
Find an implicit conversion in your SQL Server plan, understand which value changes type, and match application parameters to indexed columns.
SQL SERVER – Queries Waiting for Memory Allocation to Execute
Find queries waiting for memory allocation with sys.dm_exec_query_memory_grants, plus wait_order and the query plan, when you suspect memory is short.