Viewing 15 posts - 1,036 through 1,050 (of 59,078 total)
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
Heh... I was having too much fun with this post and thought that someone might take it too negatively, and so I deleted it.
October 2, 2023 at 12:55 am
it is resolved
You should post your solution so that we can check it for you... a lot of people make a pretty bad error for things like this.
October 1, 2023 at 8:05 pm
I'll also add that what looks to be the "3rd INSERT" is the only one that has non-sargable criteria in the Joins ...
...
October 1, 2023 at 7:57 pm
Viewing 15 posts - 1,036 through 1,050 (of 59,078 total)