19,618 reputation
457109
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 6 months
seen 16 mins ago

1d
answered What is the logic behind ISNUMERIC for certain special characters?
2d
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
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?