Viewing 15 posts - 1,591 through 1,605 (of 59,066 total)
It'll be interesting to see what kind of Execution Plan is built from all that. The use of DISTINCT also suggests that you may have at least 1 many-to-many return...
April 4, 2023 at 5:06 pm
In the following, you have an underscore in the code that does not exist in the TBL_Vendor table.
on vnd.ORDER_ID = ord.ID
April 4, 2023 at 4:56 pm
Lordy. My apologies. I didn't look at the "record layout" for sys.dm_tran_active_transactions (from your query you posted)... The bloody database_transaction_begin_time column in that DMV is returned, by the system, as...
April 4, 2023 at 3:44 pm
Thanks, ran into someone that didn't know you could do this in one statement.
That's the main reason I really liked the question. I've run into a whole lot of...
April 3, 2023 at 2:42 pm
@Sridevi kakolu,
Thanks for the reply and the referenced material . I was worked with this option for many PTO tasks, but what I am looking for is , a...
April 3, 2023 at 2:07 pm
Heh... Like I tell people, I don't hate computers... I hate the people that write the code and the people that don't test it properly.
And you don't even know if...
April 3, 2023 at 1:20 am
Like I said, glad to "meet" you.
The reference you provided is very helpful but it doesn't tell the OP how to find content like you did for the first thing...
April 3, 2023 at 12:06 am
Why does creating and inserting data into a table with insert into cause blocking but inserting into an existing table not cause blocking?
Someone like Paul White could answer that...
April 2, 2023 at 9:32 pm
The tran log I/O seems really high to me, as does query store. Without having more esoteric knowledge of the system, I'm hesitant to make any judgement on that.
I will...
April 2, 2023 at 7:40 pm
I was shocked to learn that this table still exists in SQL Server, and nobody is talking about it ^^. It seems to be around since the 80s as...
April 2, 2023 at 6:00 pm
Nothing like shifting gears but, whatever. It's also not always the "better" way. "It Depends".
April 2, 2023 at 5:50 pm
Ah... never mind... I found the source.
Consider telling the OP the search you did to find this documentation so that they may help themselves in the future. I believe it's...
April 2, 2023 at 1:48 pm
@Sridevi Kakolu...
First, welcome aboard!
Just to ask the question (and no argument from me one way or the other), did you actually construct all of your first reply or did you...
April 2, 2023 at 1:26 pm
Viewing 15 posts - 1,591 through 1,605 (of 59,066 total)