Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Paul White's user avatar
Paul White's user avatar
Paul White's user avatar
Paul White
Moderator
  • Member for 13 years, 2 months
  • Last seen this week
18 votes
1 answer
1k views

Single-row INSERT...SELECT much slower than separate SELECT

2 votes
1 answer
19 views

Sampled Statistics Percentage Internal Calculation

23 votes
2 answers
5k views

When does SQL Server warn about an Excessive Memory Grant?

19 votes
1 answer
1k views

Forced plans on readable secondaries

104 votes
6 answers
79k views

Retrieving n rows per group

9 votes
1 answer
735 views

SQL Server LOB variables and memory usage

7 votes
1 answer
2k views

Does lightweight pooling disable built-in CLR facilities?

8 votes
1 answer
478 views

Why are statistics slower to build on clustered columnstore?

12 votes
3 answers
5k views

Is MySQL breaking the standard by allowing selecting columns that are not part of the group by clause?

13 votes
1 answer
608 views

Prevent THREADPOOL waits due to idle worker thread trimming

63 votes
1 answer
13k views

Is there any benefit to SCHEMABINDING a function beyond Halloween Protection?

20 votes
1 answer
2k views

Nonclustered index storage on clustered columnstore

10 votes
1 answer
474 views

Hash aggregate bailout

18 votes
2 answers
3k views

CROSS APPLY produces outer join

46 votes
3 answers
12k views

Excessive sort memory grant

10 votes
1 answer
508 views

Why doesn't join elimination work with sys.query_store_plan?

10 votes
1 answer
743 views

Index Seek Operator Cost

4 votes
1 answer
193 views

Degree of parallelism and scheduler usage

8 votes
1 answer
430 views

What is the StatementParameterizationType plan attribute?

14 votes
1 answer
887 views

Unique index updates and statistics row modification counters

63 votes
6 answers
70k views

Date range rolling sum using window functions

24 votes
1 answer
4k views

Does SQL Server cache the result of a multi-statement table-valued function?

26 votes
1 answer
1k views

Logical reads different when accessing the same LOB data