19,054 reputation
456107
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 5 months
seen 8 mins ago

Aug
15
answered Why is SQL Server's online indexing causing blocking?
Aug
13
answered Sch-M WAIT blocks Sch-S in SQL Server 2014 but not SQL Server 2008 R2?
Aug
8
answered Filtered index not chosen, and rejected with hint
Aug
7
answered Why aggregate operator used after unique index scan
Aug
5
answered Update on view over partitioned tables updating all indexes
Aug
3
answered SQL Profiler Shows Update (EventClass) with No Errors, But Data in Table is Not Changed
Jul
31
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#