Michael Green's user avatar
Michael Green's user avatar
Michael Green's user avatar
Michael Green
  • Member for 9 years, 8 months
  • Last seen this week
  • Melbourne, Australia
23 votes
1 answer
833 views

Implementation and contraindications for OPTIMIZE_FOR_SEQUENTIAL_KEY

12 votes
5 answers
3k views

Convert a date range to an interval description

11 votes
1 answer
182 views

Inline Scalar UDF Under RCSI - Can Results Differ

7 votes
3 answers
733 views

What is the stride of a GAM interval

6 votes
1 answer
112 views

Why does estimated memory have a three phase shape?

5 votes
2 answers
473 views

Why is there an aggregate in this UPDATE plan?

5 votes
1 answer
1k views

During rollback, is lock escalation reversed

5 votes
2 answers
524 views

Find Ancestry From JSON

5 votes
1 answer
342 views

Logical read count varies

5 votes
1 answer
816 views

What page type is page 516855552?

3 votes
1 answer
163 views

How is a statistics collection different to normal table stats?

3 votes
1 answer
1k views

How are deadlocks detected by Synapse

3 votes
0 answers
87 views

A hint changes query results. Why is this OK? [duplicate]

3 votes
1 answer
2k views

How does PolyBase collect statistics from external tables?

3 votes
3 answers
900 views

ADF patterns to minimise batch run elapsed time

2 votes
0 answers
210 views

Exactly-once FIFO queue in Synapse

2 votes
1 answer
394 views

How are tasks assigned to ForEach iterations

2 votes
1 answer
111 views

SQL Server 2014, Volumes in Resource Governor

2 votes
3 answers
127 views

Find "naked" varchars

1 vote
1 answer
332 views

Design for graph polymorphism

1 vote
1 answer
165 views

Explanation for second Compute Scalar

1 vote
0 answers
15 views

Resource overlap between Synapse databases

0 votes
3 answers
875 views

Split intervals

0 votes
1 answer
31 views

Synapse column store datetime encoding

0 votes
1 answer
56 views

What is the meaning of lsn_time_mapping.start_lsn