18,142 reputation
453102
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 4 months
seen 1 hour ago

14h
answered Why are U locks required when using Read Committed Snapshot Isolation
Jul
18
answered Single row to multiple rows with column combination
Jul
18
answered Btree index and Bit Map Index
Jul
17
answered Why Does UNPIVOT Work on Compatibility Level 80 DB?
Jun
27
answered Why does an UPDATE against a table with an INSTEAD OF UPDATE trigger appear to do a clustered index insert, as well as a clustered index update?
Jun
26
answered “Cannot create a row of size 8074 which is greater than the allowable maximum row size of 8060” while altering the table
Jun
16
answered Rejoining range seek on nullable composite index?
Jun
7
answered SQL Server - Varbinary Column - Extremely Slow Statistics Update
Jun
6
answered Joining on same table without duplicating data in a field or using c#
Jun
6
answered sql server instance using only a few 100mb. Well below the minimum server memory setting
Jun
5
answered TRANSACTION ISOLATION LEVEL SNAPSHOT vs. TRUNCATE?
Jun
3
answered Search, filter and group across all columns in a tall and wide dataset quickly
Jun
2
answered What frequency of hash/sort spills into tempdb is concerning?
May
29
answered Splitting a deck of cards, and returning the results as if they were shuffled once
May
28
answered Deadlock on Delete Statement
May
22
answered What causes 'Unknown token received from SQL Server'?
May
21
answered Why is the speed of executing statements dependent on the network connection?
May
15
answered Giving server-role to login breaks stored procedures
May
15
answered How to find duration in a dataset
May
12
answered Using OPENQUERY to execute a script