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
104 votes
6 answers
79k views

Retrieving n rows per group

63 votes
6 answers
70k views

Date range rolling sum using window functions

63 votes
1 answer
13k views

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

46 votes
3 answers
12k views

Excessive sort memory grant

26 votes
1 answer
1k views

Logical reads different when accessing the same LOB data

24 votes
1 answer
4k views

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

23 votes
2 answers
5k views

When does SQL Server warn about an Excessive Memory Grant?

20 votes
1 answer
2k views

Nonclustered index storage on clustered columnstore

19 votes
1 answer
1k views

Forced plans on readable secondaries

18 votes
1 answer
1k views

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

18 votes
2 answers
3k views

CROSS APPLY produces outer join

14 votes
1 answer
887 views

Unique index updates and statistics row modification counters

13 votes
1 answer
608 views

Prevent THREADPOOL waits due to idle worker thread trimming

12 votes
3 answers
5k views

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

10 votes
1 answer
474 views

Hash aggregate bailout

10 votes
1 answer
743 views

Index Seek Operator Cost

10 votes
1 answer
508 views

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

9 votes
1 answer
736 views

SQL Server LOB variables and memory usage

8 votes
1 answer
480 views

Why are statistics slower to build on clustered columnstore?

8 votes
1 answer
431 views

What is the StatementParameterizationType plan attribute?

7 votes
1 answer
2k views

Does lightweight pooling disable built-in CLR facilities?

6 votes
1 answer
123 views

Sampled Statistics Percentage Internal Calculation

4 votes
1 answer
193 views

Degree of parallelism and scheduler usage