Paul Holmes's user avatar
Paul Holmes's user avatar
Paul Holmes's user avatar
Paul Holmes
  • Member for 6 years, 6 months
  • Last seen more than a month ago
12 votes
3 answers
3k views

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

11 votes
2 answers
567 views

Inner join elimination inhibited by prior outer join

9 votes
2 answers
588 views

EXCEPT & INTERSECT: Purpose of Passive Projection in Logical Plan

8 votes
1 answer
859 views

Determining if auto stats update is in progress

5 votes
2 answers
1k views

SSMS constraint script: Purpose of second alter table statement?

5 votes
1 answer
133 views

Logical trees: difference between Before Project Normalization and Join Collapsed

4 votes
3 answers
3k views

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

4 votes
1 answer
155 views

DMVs - Relating tasks to branches

3 votes
1 answer
49 views

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

2 votes
0 answers
66 views

Repro for missed rows during Allocation Order Scan + Page Splits

2 votes
1 answer
807 views

Is xp_create_subdir supported on Linux SQL Server

2 votes
2 answers
3k views

SQL To Fetch Partition Boundaries and Filegroups

1 vote
1 answer
91 views

Optimizer logical trees: Order of the different tree types?