Skip to main content
Paul Williams's user avatar
Paul Williams's user avatar
Paul Williams's user avatar
Paul Williams
  • Member for 12 years, 8 months
  • Last seen more than a month ago
18 votes
2 answers
11k views

Deadlocks From Locks on Same Temporary Tables In Different Processes

12 votes
1 answer
6k views

Unable to Watch Live Data on Extended Events Session

11 votes
2 answers
4k views

LATCH_EX Waits on Resource METADATA_SEQUENCE_GENERATOR

9 votes
2 answers
22k views

Slow Performance Inserting Few Rows Into Huge Table

6 votes
1 answer
874 views

Join on NULL Key Column Optimizing as Table and Index Scans

5 votes
1 answer
6k views

PAGELOCK Conversion Deadlock From Update to Intent Exclusive

4 votes
1 answer
2k views

Different Results From sys.databases As Different Users

2 votes
1 answer
111 views

Synchronize Queries Retrieving Sessions And Locks From DMVs

2 votes
1 answer
6k views

Why are timestamps not always increasing with concurrent inserts?

2 votes
1 answer
494 views

Excessive memory grants from indexed foreign key cascade delete

2 votes
0 answers
393 views

SQL Server buffer cache smaller after reboot with same workload [closed]

1 vote
1 answer
463 views

Incorrect Statistics EQ_ROWS Causing Parallel Table Scans and Deadlocks