user avatar
user avatar
user avatar
Paul Holmes
  • Member for 4 years, 10 months
  • Last seen more than a month ago
12 votes
3 answers
2k views

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

12 votes
2 answers
464 views

Inner join elimination inhibited by prior outer join

9 votes
2 answers
559 views

EXCEPT & INTERSECT: Purpose of Passive Projection in Logical Plan

8 votes
1 answer
467 views

Determining if auto stats update is in progress

5 votes
2 answers
821 views

SSMS constraint script: Purpose of second alter table statement?

5 votes
1 answer
118 views

Logical trees: difference between Before Project Normalization and Join Collapsed

4 votes
3 answers
2k views

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

4 votes
1 answer
108 views

DMVs - Relating tasks to branches

3 votes
1 answer
46 views

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

2 votes
0 answers
52 views

Repro for missed rows during Allocation Order Scan + Page Splits

2 votes
1 answer
636 views

Is xp_create_subdir supported on Linux SQL Server

2 votes
2 answers
2k views

SQL To Fetch Partition Boundaries and Filegroups

0 votes
1 answer
65 views

Optimizer logical trees: Order of the different tree types?