21,746 reputation
660123
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 9 months
seen 2 hours ago

Sep
25
answered Are RANK() and DENSE_RANK() deterministic or non-deterministic?
Sep
25
answered How can “HierarchyID” type work when “CLR” is disabled?
Sep
19
answered Foreign key without referenced columns specification
Sep
17
answered What is the logic behind ISNUMERIC for certain special characters?
Sep
16
answered Can you use COUNT DISTINCT with an OVER clause?
Sep
15
answered Switching Data In Fails with “allows values that are not allowed by check constraints or partition function on target table”
Sep
15
answered Is database record access sequential after retrieving the indexed page from disk?
Aug
21
answered How to back out of mass update in SQL Replication
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