User Paul White - Database Administrators Stack Exchange

Paul White

Moderator

Member for 12 years, 9 months
Last seen this week

Twitter
GitHub
sql.kiwi
New Zealand

22 Questions

Score Activity Newest Views

103 votes

6 answers

77k views

Retrieving n rows per group

asked Dec 17, 2014 at 14:33

63 votes

6 answers

69k views

Date range rolling sum using window functions

asked Sep 7, 2015 at 20:13

62 votes

1 answer

12k views

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

asked Jun 4, 2016 at 6:35

47 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

22 votes

1 answer

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

874 views

Unique index updates and statistics row modification counters

asked Sep 10, 2017 at 20:12

13 votes

1 answer

600 views

Prevent THREADPOOL waits due to idle worker thread trimming

asked Aug 29, 2020 at 14:55

11 votes

3 answers

4k 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

465 views

Hash aggregate bailout

asked Jul 17, 2019 at 20:47

10 votes

1 answer

729 views

Index Seek Operator Cost

asked Jul 3, 2018 at 9:00

10 votes

1 answer

490 views

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

asked Sep 1, 2018 at 14:22

9 votes

1 answer

678 views

SQL Server LOB variables and memory usage

asked Aug 3, 2022 at 20:39

8 votes

1 answer

462 views

Why are statistics slower to build on clustered columnstore?

asked Nov 3, 2022 at 22:06

8 votes

1 answer

403 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

4 votes

1 answer

192 views

Degree of parallelism and scheduler usage

asked May 3, 2018 at 3:52