Reputation
347
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 10
Impact
~7k people reached

  • 0 posts edited
  • 0 helpful flags
  • 131 votes cast
Aug
18
awarded  Nice Question
Aug
17
asked Why does my WHERE clause benefit from an “included” column?
Aug
10
asked Is unique index combined with a “not null” constraint equivalent to a PK constraint?
Aug
6
accepted Why does PK constraint require a separate index when I already have a suitable unique clustered index?
Aug
4
comment Why does PK constraint require a separate index when I already have a suitable unique clustered index?
@MikaelEriksson I'm not sure I won't break anything. I'd rather have PK changed to use the clustered index if that's possible.
Aug
4
comment Why does PK constraint require a separate index when I already have a suitable unique clustered index?
@ypercube Maybe it's possible with on-prem server, but surely not with SQL Azure.
Aug
4
comment Why does PK constraint require a separate index when I already have a suitable unique clustered index?
@a_horse_with_no_name I have an existing table and so I cannot just drop the clustered index - the index stores my table.
Aug
4
comment Why does PK constraint require a separate index when I already have a suitable unique clustered index?
@a_horse_with_no_name This is legacy, that's why. Is it possible to tell SQL Server to use the existing clustered index for the PK constraint perhaps?
Aug
4
asked Why does PK constraint require a separate index when I already have a suitable unique clustered index?
Aug
3
asked Why is DistinctSort followed by TopNSort in my query plan?
Apr
7
comment Which of sys.dm_exec_query_stats columns should I pay most attention?
@MarkSinkinson Is there a kind of walkthrough to get started?
Apr
7
asked Which of sys.dm_exec_query_stats columns should I pay most attention?
Nov
11
comment 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?
@AaronBertrand: Some queries originate from Ling-to-Sql, others are being run using SqlCommand class. I'm not sure but it looks like there're no tweaks to concurrency beyond the default settings.
Nov
11
comment 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?
Emm... How is it possible that a session is sleeping and there's a row in locks for that session?
Nov
11
comment 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?
@aasim.abdullah: Same amount as without the filer (I compute count(*) and sum(case when locks.resource_database_id > 4 then 1 else 0 end) in the same query and they are equal).
Nov
11
asked 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?
Oct
28
comment Why would I not specify ROWLOCK to get rid of page locks?
Okay, suppose I will be testing with ROWLOCK. How do I ensure that those bag things with locks do not happen?
Oct
27
comment Why would I not specify ROWLOCK to get rid of page locks?
So is it true that READPAST has no effect when page locks are being taken?
Oct
24
awarded  Teacher
Oct
24
asked Why would I not specify ROWLOCK to get rid of page locks?