Viewing 15 posts - 16 through 30 (of 444 total)
Thanks all for replies. Now I am convinced, will leave the 2nd index in place.
October 14, 2020 at 7:03 pm
The reason for these NOLOCK's is mostly performance, they don't want to be blocked.
October 6, 2020 at 4:16 pm
My goal is not a resultset.
What I have now is two queries which separately assign values to two single variables:
select @v1 = amt
from #t1
where type =...
October 24, 2019 at 3:40 pm
Thank you, Grant, for good advises. Because of permission issues, I am using Profiler (of course in lower environment) instead of extended events. Am I missing any features?
August 2, 2019 at 8:15 pm
I don't have application code. What developers sent me is a SQL query "converted" from LINQ. And it's very simple, basically select from a single table with a couple of...
July 31, 2019 at 10:21 pm
Ah, thanks Sue, when I placed my reply I did not notice that you already placed yours. Thanks, that's what I wanted.
June 24, 2019 at 8:16 pm
We have a stored procedure, that:
1. Deletes object_a
2. insert into object_a
select from object_b
Because step 2 takes a long time (like 10 minutes), ones it refreshed object_a, all reports select their...
June 24, 2019 at 8:13 pm
Thanks, Scott.
For #3: They use as_of_month not just for display but a lot in where clauses and join conditions, like a.as_of_month = b.as_of_month
And about money data type, aren't it deprecated?
June 14, 2019 at 7:50 pm
Exactly, Sue. We have an uncommitted transaction that holds this block. And the problem is that our blocking monitoring job (it is running every 30 sec) wrongfully points to another...
February 1, 2019 at 1:35 pm
Thank you Sue, tried it too. It still shows getdate().
In my situation, I don't have a chain. I simply replaced one command (that holds open transaction) with...
February 1, 2019 at 11:33 am
Thank you Luis for this great stored procedure!
I downloaded, ran it and applied to my situation. But unfortunately, in its result-set, in inputbuffer column it still shows select...
February 1, 2019 at 9:16 am
Is it still open? If yes, where can I send my resume?
January 30, 2019 at 2:08 pm
Thanks a lot Sreekanth for a detailed answer. The only question that I have is what is E2E?
Thanks
December 13, 2018 at 1:34 pm
Viewing 15 posts - 16 through 30 (of 444 total)