user avatar
user avatar
user avatar
sharptooth
  • Member for 10 years, 4 months
  • Last seen more than 2 years ago
23 votes
1 answer
2k views

Where do this Constant Scan and Left Outer Join come from in a trivial SELECT query plan?

12 votes
2 answers
921 views

Why does my WHERE clause benefit from an "included" column?

10 votes
4 answers
9k views

How do DTUs in Standard and Premium performance tiers in SQL Azure compare?

7 votes
1 answer
2k views

How do I prevent a massive SELECT from blocking other statements?

7 votes
2 answers
10k views

Will altering order of columns in GROUP BY affect performance?

6 votes
1 answer
111 views

Why is DistinctSort followed by TopNSort in my query plan?

6 votes
2 answers
1k views

Why would I not run "index reorganization" regularly?

6 votes
1 answer
199 views

Can I specify a name for the index which SQL Server creates for my unique constraint?

5 votes
2 answers
214 views

Are existing entries immediately included into a newly created index?

5 votes
1 answer
116 views

How is SQL Server host identity ensured?

4 votes
1 answer
339 views

How do I deal with query getting slower when a select parameter is not specified inline?

4 votes
1 answer
165 views

Why does my query end up with two seeks instead of one and how do I fix that?

3 votes
2 answers
2k views

How do I count rows with two properties in one index scan in SQL?

2 votes
1 answer
1k views

Can I limit the time a table lock is being held server side?

2 votes
3 answers
405 views

Why does PK constraint require a separate index when I already have a suitable unique clustered index?

2 votes
1 answer
179 views

Why would CREATE INDEX with "online" mode suddenly slow my database down?

2 votes
1 answer
91 views

Why does elimination of an if-statement cause notable speed up in my function?

1 vote
0 answers
158 views

How would I access a system view in SQL Azure master database without logging into master?

1 vote
1 answer
887 views

Why would I not specify ROWLOCK to get rid of page locks?

1 vote
2 answers
367 views

How do I track why my SQL Azure occupied space pulsates?

1 vote
1 answer
196 views

Is it a good idea to have an index when the column value changes several times over record lifetime?

0 votes
1 answer
342 views

What causes lost updates being observed in my SQL Azure database?

0 votes
1 answer
2k views

What does it mean when I see a lock in sys.dm_tran_locks and there's no matching row in sys.dm_exec_requests?

0 votes
0 answers
185 views

Which of sys.dm_exec_query_stats columns should I pay most attention?

0 votes
2 answers
97 views

Is unique index combined with a "not null" constraint equivalent to a PK constraint?

0 votes
1 answer
83 views

How do I know an index is used for any queries?