18,456 reputation
453103
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 4 months
seen 10 mins ago

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?
Aug
14
answered Distributed transaction and Read Committed Snapshot
Aug
3
answered How to improve TempDb on RAMDisk showing performance on par with physical hard drive
Aug
3
answered How to optimise T-SQL query using Execution Plan
Jul
31
answered DBCC CHECKDB unfixable corruption: Indexed view contains rows that were not produced by the view definition
Jul
31
answered How to merge data sets without including redundant rows?
Jul
31
answered How to select from a table without including repeated column values?
Jul
30
answered How does SQL Server know predicates are correlated?