User Paul White - Database Administrators Stack Exchange

105 votes

6 answers

79k views

Retrieving n rows per group

asked Dec 17, 2014 at 14:33

65 votes

1 answer

13k views

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

asked Jun 4, 2016 at 6:35

63 votes

6 answers

70k views

Date range rolling sum using window functions

asked Sep 7, 2015 at 20:13

46 votes

3 answers

12k views

Excessive sort memory grant

asked Dec 17, 2014 at 10:12

26 votes

1 answer

1k views

Logical reads different when accessing the same LOB data

asked May 8, 2016 at 14:07

24 votes

1 answer

4k views

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

asked Dec 28, 2016 at 13:20

23 votes

2 answers

5k views

When does SQL Server warn about an Excessive Memory Grant?

asked Jan 28, 2019 at 12:15

20 votes

1 answer

2k views

Nonclustered index storage on clustered columnstore

asked Jan 6, 2017 at 8:30

19 votes

1 answer

1k views

Forced plans on readable secondaries

asked Aug 29, 2019 at 22:54

18 votes

1 answer

1k views

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

asked Feb 25, 2019 at 10:22

18 votes

2 answers

3k views

CROSS APPLY produces outer join

asked Jun 5, 2019 at 14:08

14 votes

1 answer

896 views

Unique index updates and statistics row modification counters

asked Sep 10, 2017 at 20:12

13 votes

1 answer

611 views

Prevent THREADPOOL waits due to idle worker thread trimming

asked Aug 29, 2020 at 14:55

12 votes

3 answers

5k views

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

asked Jun 29, 2021 at 10:58

10 votes

1 answer

479 views

Hash aggregate bailout

asked Jul 17, 2019 at 20:47

10 votes

1 answer

748 views

Index Seek Operator Cost

asked Jul 3, 2018 at 9:00

10 votes

1 answer

512 views

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

asked Sep 1, 2018 at 14:22

9 votes

1 answer

754 views

SQL Server LOB variables and memory usage

asked Aug 3, 2022 at 20:39

8 votes

1 answer

485 views

Why are statistics slower to build on clustered columnstore?

asked Nov 3, 2022 at 22:06

8 votes

1 answer

443 views

What is the StatementParameterizationType plan attribute?

asked Mar 27, 2018 at 15:19

7 votes

1 answer

2k views

Does lightweight pooling disable built-in CLR facilities?

asked Jul 13, 2018 at 17:02

6 votes

1 answer

154 views

Sampled Statistics Percentage Internal Calculation

asked May 22 at 15:24

4 votes

1 answer

197 views

Degree of parallelism and scheduler usage

asked May 3, 2018 at 3:52

Stack Exchange Network

23 Questions

Retrieving n rows per group

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

Date range rolling sum using window functions

Excessive sort memory grant

Logical reads different when accessing the same LOB data

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

When does SQL Server warn about an Excessive Memory Grant?

Nonclustered index storage on clustered columnstore

Forced plans on readable secondaries

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

CROSS APPLY produces outer join

Unique index updates and statistics row modification counters

Prevent THREADPOOL waits due to idle worker thread trimming

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

Hash aggregate bailout

Index Seek Operator Cost

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

SQL Server LOB variables and memory usage

Why are statistics slower to build on clustered columnstore?

What is the StatementParameterizationType plan attribute?

Does lightweight pooling disable built-in CLR facilities?

Sampled Statistics Percentage Internal Calculation

Degree of parallelism and scheduler usage