User sharptooth

23 votes

1 answer

2k views

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

asked Apr 22, 2016 at 9:46

12 votes

2 answers

921 views

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

sql-server index execution-plan azure-sql-database

asked Aug 17, 2015 at 8:37

10 votes

4 answers

9k views

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

performance azure-sql-database

asked Mar 28, 2016 at 7:21

7 votes

1 answer

2k views

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

sql-server performance azure-sql-database blocking query-performance

asked Sep 25, 2015 at 8:39

7 votes

2 answers

10k views

Will altering order of columns in GROUP BY affect performance?

sql-server performance azure-sql-database query-performance

asked Apr 27, 2012 at 8:57

6 votes

1 answer

111 views

Why is DistinctSort followed by TopNSort in my query plan?

sql-server execution-plan azure-sql-database sorting

asked Aug 3, 2015 at 15:15

6 votes

2 answers

1k views

Why would I not run "index reorganization" regularly?

sql-server index disk-space azure-sql-database

asked Jun 19, 2017 at 13:17

6 votes

1 answer

199 views

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

sql-server index constraint ddl

asked Jan 25, 2018 at 14:01

5 votes

2 answers

214 views

Are existing entries immediately included into a newly created index?

sql-server sql-server-2008 performance index

asked Mar 27, 2012 at 7:47

5 votes

1 answer

116 views

How is SQL Server host identity ensured?

sql-server security identity cryptography

asked Apr 9, 2013 at 11:03

4 votes

1 answer

339 views

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

sql-server performance azure-sql-database execution-plan query-performance

asked Apr 21, 2014 at 9:33

4 votes

1 answer

165 views

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

sql-server performance execution-plan azure-sql-database

asked Aug 27, 2014 at 10:01

3 votes

2 answers

2k views

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

sql-server sql-server-2008-r2 performance azure-sql-database query-performance

asked Apr 26, 2012 at 13:01

2 votes

1 answer

1k views

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

sql-server azure-sql-database locking

asked Dec 12, 2013 at 14:40

2 votes

3 answers

405 views

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

sql-server index primary-key azure-sql-database

asked Aug 4, 2015 at 11:28

2 votes

1 answer

179 views

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

index azure-sql-database

asked Sep 16, 2015 at 9:06

2 votes

1 answer

91 views

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

sql-server query-performance optimization execution-plan azure-sql-database

asked Jan 30, 2019 at 13:24

1 vote

0 answers

158 views

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

permissions access-control azure-sql-database master-system-database

asked Mar 16, 2016 at 8:51

1 vote

1 answer

887 views

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

sql-server locking azure-sql-database hints

asked Oct 24, 2014 at 5:48

1 vote

2 answers

367 views

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

sql-server disk-space azure-sql-database

asked Aug 5, 2013 at 8:57

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?

sql-server index update

asked Jan 17, 2013 at 13:23

0 votes

1 answer

342 views

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

sql-server transaction azure-sql-database concurrency

asked Jan 16, 2014 at 7:21

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?

sql-server locking azure-sql-database

asked Nov 11, 2014 at 15:09

0 votes

0 answers

185 views

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

performance azure-sql-database performance-tuning query-performance

asked Apr 7, 2015 at 9:31

0 votes

2 answers

97 views

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

index primary-key constraint azure-sql-database data-integrity

asked Aug 10, 2015 at 13:58

0 votes

1 answer

83 views

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

sql-server performance index azure-sql-database maintenance

asked Dec 9, 2016 at 9:14

Stack Exchange Network

current community

your communities

more stack exchange communities

26 Questions

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

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

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

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

Will altering order of columns in GROUP BY affect performance?

Why is DistinctSort followed by TopNSort in my query plan?

Why would I not run "index reorganization" regularly?

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

Are existing entries immediately included into a newly created index?

How is SQL Server host identity ensured?

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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