Reputation
479
Next privilege 500 Rep.
Access review queues
Badges
3 11
Impact
~11k people reached

  • 0 posts edited
  • 0 helpful flags
  • 142 votes cast
Apr
22
awarded  Nice Question
Apr
22
accepted Where do this Constant Scan and Left Outer Join come from in a trivial SELECT query plan?
Apr
22
asked Where do this Constant Scan and Left Outer Join come from in a trivial SELECT query plan?
Mar
29
comment How do DTUs in Standard and Premium performance tiers in SQL Azure compare?
I'm okay seeing it lower, but it went from 100 percent to 8 percent - more than ten times lower.
Mar
29
comment How do DTUs in Standard and Premium performance tiers in SQL Azure compare?
I've seen this table. It doesn't explain how I got avg_cpu_percent lowered from 100 percent to 8 percent after switching from S3 to P2.
Mar
28
asked How do DTUs in Standard and Premium performance tiers in SQL Azure compare?
Mar
16
awarded  Yearling
Mar
16
asked How would I access a system view in SQL Azure master database without logging into master?
Oct
6
comment How do I prevent a massive SELECT from blocking other statements?
@MarkWilkinson Well, nothing interesting, just a heavy SELECT which was likely causing either a table scan or gazillion of index seeks. The problem was resolved by creating a suitable index. Looks like something is seriously wrong with SQL Azure performance tiers.
Sep
25
comment How do I prevent a massive SELECT from blocking other statements?
@jkavalik That would be a speculation, not a real plan.
Sep
25
comment How do I prevent a massive SELECT from blocking other statements?
@MarkSinkinson I guess I can but that surely requires quite a lot of effort and time.
Sep
25
comment How do I prevent a massive SELECT from blocking other statements?
@MarkSinkinson I cannot even obtain an execution plan anymore because that requires running the query and disrupting production.
Sep
25
asked How do I prevent a massive SELECT from blocking other statements?
Sep
21
comment Why would CREATE INDEX with “online” mode suddenly slow my database down?
Why would this not happen earlier and what do I do to overcome it?
Sep
21
comment Why would CREATE INDEX with “online” mode suddenly slow my database down?
@SQLmojoe I added that into the question. The problem occurs both when creating an identical index and a non-identical index.
Sep
21
comment Why would CREATE INDEX with “online” mode suddenly slow my database down?
@JoshSimar The slowdown starts immediately once the statement start running.
Sep
21
revised Why would CREATE INDEX with “online” mode suddenly slow my database down?
added 273 characters in body
Sep
16
asked Why would CREATE INDEX with “online” mode suddenly slow my database down?
Aug
18
awarded  Nice Question
Aug
17
asked Why does my WHERE clause benefit from an “included” column?