247 reputation
29
bio website
location
age
visits member for 2 years, 8 months
seen Dec 5 at 8:08

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?
Sep
19
awarded  Notable Question
Aug
29
comment Why does my query end up with two seeks instead of one and how do I fix that?
@AaronBertrand: Okay, I used code from here social.msdn.microsoft.com/Forums/en-US/… with two getutcdate() calls. The initial query takes about 2200 milliseconds while the modified one takes 4300 to 6500 milliseconds.
Aug
29
comment Why does my query end up with two seeks instead of one and how do I fix that?
@RobFarley: I added the picture with the plan and included the details from earlier comments into the question.
Aug
29
comment Why does my query end up with two seeks instead of one and how do I fix that?
@AaronBertrand: I cannot know, but it's reproducible and it's much slower compared to SELECT 1.
Aug
29
revised Why does my query end up with two seeks instead of one and how do I fix that?
added 518 characters in body
Aug
28
comment Why does my query end up with two seeks instead of one and how do I fix that?
@RobFarley: Nope, that's a web interface that contains a fraction of SSMS functionality.
Aug
28
comment Why does my query end up with two seeks instead of one and how do I fix that?
@RobFarley: Yes, something like a million records per Owner is not uncommon for specific owners (only a small fraction of all). I doubt I can export anything better than a tree picture from Management Portal.
Aug
28
comment Why does my query end up with two seeks instead of one and how do I fix that?
@RobFarley: The delay between I press "run" and see the results in the Management Portal is longer compared to the original query.
Aug
28
comment Why does my query end up with two seeks instead of one and how do I fix that?
I tried this - it yields an index scan for TaskItems which is slower.
Aug
27
comment Why does my query end up with two seeks instead of one and how do I fix that?
@wBob: There are clustered indexes which I haven't shown.
Aug
27
comment Why does my query end up with two seeks instead of one and how do I fix that?
@MartinSmithL I presumably fixed the query so that it's valid now.
Aug
27
revised Why does my query end up with two seeks instead of one and how do I fix that?
deleted 2 characters in body