Viewing 15 posts - 1,021 through 1,035 (of 59,066 total)
Hello,
I have come across this peculiar problem.
This stp is called every begin of the day of the application startup. A bug got introduced in the stp.
The BEGIN TRAN was...
October 4, 2023 at 6:01 pm
I'm curious as to what measurable benefit you realized from performing reindexing / reorg on your indexes?
😉
October 4, 2023 at 5:57 pm
Perhaps you could create a view with the columns in your (client's) preferred order? It it was a full view, it should be updatable and therefore the view name...
October 4, 2023 at 5:54 pm
Thank you All.
Two way street here, Sam. You've not answered my question above. Why is someone trying to Truncate a table while others are trying to SELECT from it? ...
October 4, 2023 at 2:51 pm
Is there a way to reorganise the fields into alphabetical order without creating a new table and transferring all the data?
That is, quite possibly, the worst table design idea...
October 4, 2023 at 2:49 pm
Heh... Ok! The OP has left the building!
October 4, 2023 at 2:07 pm
I don't have much time this evening but I do have a question...
WHY are people trying to TRUNCATE a table that the app or other people are trying to SELECT...
October 4, 2023 at 12:30 am
Also, if you really are using RCSI, then using (NOLOCK) is a complete waste of code realestate. Also, using (NOLOCK) by itself was deprecated years ago. MS says...
October 2, 2023 at 7:08 pm
@steve-2 Jones...
Have you taken a look at the "business end" of Sessionize? I've not. I've only been on the receiving end as a speaker but their write-up seems encouraging and...
October 2, 2023 at 5:42 pm
Surely, someone has already done this (although I've not actually looked for such a thing). Wouldn't it be easier to find something that already works and buy it?
It's...
October 2, 2023 at 4:18 pm
You said in your narrative in your original post that "it reads last 30 mins of data from the tables involved" and yet ALL of...
October 2, 2023 at 4:16 pm
Sorry, but the answer is wrong! I ran the code in SQL 2022 got below error:
Msg 102, Level 15, State 1, Line 15 Incorrect syntax near 'WINDOW'.
You're probably not...
October 2, 2023 at 3:58 pm
Just call it "P-cubed" or "P3" for "Proper Programming Practices" instead of all this Dev-this and Ops-that stuff.
Admirable restraint there Jeff. The temptation for "P-Sept" or "P7" must...
October 2, 2023 at 3:28 pm
Just call it "P-cubed" or "P3" for "Proper Programming Practices" instead of all this Dev-this and Ops-that stuff.
October 2, 2023 at 2:34 am
Viewing 15 posts - 1,021 through 1,035 (of 59,066 total)