23,672 reputation
872143
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 4 years
seen 15 mins ago

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?
Dec
30
answered Can rebuilding indexes cause worse performance after the rebuild is finished?
Dec
30
answered How to measure or find cost of creating a query plan?
Dec
26
answered Converting a Unicode value to a non-Unicode value (SQL Server)
Dec
26
answered Aggregation Operations on View Ignores Index
Dec
25
answered Keeping iterator in consistent state
Dec
24
answered T-SQL brain teaser: find non-overlapping sets
Dec
21
answered New Index on table cause table to be locked really often
Dec
21
answered Outer Apply vs Left Join Performance
Dec
21
answered Simple DELETE, but complicated execution plan
Dec
18
answered In SQL Server, can I guarantee an order without an explicit ORDER BY clause when an index seek is forced on a table with only a clustered index?
Dec
18
answered How do I create a partition using a bit field in SQL Server 2014
Dec
17
asked Retrieving n rows per group
Dec
17
asked Excessive sort memory grant
Dec
17
answered Excessive sort memory grant
Dec
17
answered Conversion of a varchar data type to a datetime data type resulted in an out-of-range value