Reputation
24,052
Next tag badge:
174/100 score
19/20 answers
Badges
8 74 144
Newest
 Necromancer
Impact
~393k people reached

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?
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