22,701 reputation
766137
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 10 months
seen 19 mins ago

Jan
26
answered Same query sometimes uses a Table Spool
Jan
22
answered How do I update and insert specific set of rows to an existing table using Merge in SQL Server 2008 R2?
Jan
16
answered Deadlock due to concurrent updates (with SIU lock)
Jan
15
answered Would it be better for query plans to be split by statement for re-usability?
Jan
14
answered MERGE a UNION query results down to one row per KEY value
Jan
14
answered Error when using views on a linked server
Jan
13
answered Is there a (non-binary) MySQL collation that doesn't treat different mathematical symbols as the same character?
Jan
10
answered Why Model database in SQL Server is in FULL recovery mode
Jan
10
answered How to repair database consistency errors
Jan
10
answered Identity value jumps when restarting SQL Server
Jan
8
answered How can I make this query sargable?
Jan
8
answered SQL Server Index Update Deadlock
Jan
6
answered How to get average according to last update time?
Jan
2
answered Are “out of the row” fields read when a clustered index is used?
Jan
2
answered Understanding statistics, execution plans, and 'ascending key problem'
Jan
2
answered Join on dm_db_index_physical_stats very slow
Jan
2
answered Why not rebuild indexes with page count <1000?
Jan
2
answered How to remove identity specification for multiple tables
Dec
31
answered Paging performance with customizable sorting over many millions of rows
Dec
31
answered What is the most efficient method of performing the FIZZBUZZ test in SQL Server?