19,083 reputation
456107
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 5 months
seen 1 hour ago

Nov
1
answered Large difference in disk space used by partitions
Oct
31
answered Index not making execution faster, and in some cases is slowing down the query. Why is it so?
Oct
30
answered DBCC show_statistics: density doesn't match what I calculate
Oct
30
answered Syntax of INNER JOIN nested inside OUTER JOIN vs. query results
Oct
29
answered GROUP BY with MAX versus just MAX
Oct
29
answered join syntax / style performance consideration
Oct
28
answered Index on Persisted Computed column needs key lookup to get columns in the computed expression
Oct
3
answered How to remove diacritics in computed persisted columns? COLLATE is non-deterministic and cannot be used
Oct
2
answered Why is there a difference between these transaction DMVs in SQL Server 2008 R2?
Sep
23
answered Database Tuning Advisor Index Recommendations
Sep
17
answered Does a simple select query acquire locks?
Sep
17
answered Improve speed of index rebuild on SQL server
Sep
9
answered Read committed snapshot:Finding lock on table
Sep
9
answered Locking in “Read Committed Snapshot”
Aug
23
answered Trace flag and which need to be turned off and Why
Aug
23
answered Dividing DBCC CHECKDB over multiple days
Aug
22
answered Optimizing complex join predicates
Aug
21
answered Msg 1833, File 'ABC.ndf' cannot be reused until after the next BACKUP LOG operation
Aug
21
answered Does the order of columns in a PK index matter?
Aug
17
answered Equivalents to `ora_rowscn` in other databases?