User Paul Holmes - Database Administrators Stack Exchange

Paul Holmes

Member for 5 years, 7 months
Last seen more than 1 year ago

13 Questions

Score Activity Newest Views

12 votes

3 answers

2k views

Query challenge: Creating even sized buckets, based on a measure not row count

asked Jul 6, 2018 at 8:08

11 votes

2 answers

516 views

Inner join elimination inhibited by prior outer join

asked Aug 30, 2020 at 19:59

9 votes

2 answers

571 views

EXCEPT & INTERSECT: Purpose of Passive Projection in Logical Plan

asked Apr 16, 2020 at 3:09

8 votes

1 answer

612 views

Determining if auto stats update is in progress

asked Sep 27, 2019 at 11:00

5 votes

2 answers

914 views

SSMS constraint script: Purpose of second alter table statement?

asked Aug 17, 2017 at 14:09

5 votes

1 answer

129 views

Logical trees: difference between Before Project Normalization and Join Collapsed

asked Aug 6, 2020 at 14:38

4 votes

3 answers

2k views

DBCC SHRINKFILE - Necessary to run more than once to achieve shrink?

asked Oct 12, 2017 at 11:12

4 votes

1 answer

129 views

DMVs - Relating tasks to branches

asked Jul 18, 2019 at 12:47

3 votes

1 answer

47 views

Azure Readable Secondary - How to: Different Access Policy to Primary?

asked Oct 16, 2020 at 15:55

2 votes

0 answers

58 views

Repro for missed rows during Allocation Order Scan + Page Splits

asked Jan 28, 2020 at 13:37

2 votes

1 answer

704 views

Is xp_create_subdir supported on Linux SQL Server

asked Aug 22, 2017 at 22:56

2 votes

2 answers

2k views

SQL To Fetch Partition Boundaries and Filegroups

asked Oct 25, 2018 at 13:08

1 vote

1 answer

79 views

Optimizer logical trees: Order of the different tree types?

asked Jul 25, 2020 at 20:45