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

1d
answered Query Plan Different When Using Compiled Values
Jul
29
answered Side effects of using updlock lock hint?
Jul
24
answered Is support for Parallel Scalar UDF a reasonable feature request?
Jul
24
answered foreign key constraint violation issue
Jul
24
answered Implementing application locks within SQL Server (Distributed Locking Pattern)
Jul
22
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