Viewing 15 posts - 121 through 135 (of 55,829 total)
Thank you for the very kind feedback, WebRunner. Coming from such a long time regular as you, it means a lot. Thanks again.
Looking back at that, it might make a...
May 31, 2022 at 8:25 pm
A bit of a sidebar... I almost always avoid both EOMonth and anything else that is used to calculate the last day of the month because so many...
May 31, 2022 at 7:53 pm
Do all of the files have a similar issue? Perhaps you need to tweak the code to handle the anomalies. Frederico offered a hint about that above.
And, no... they're not...
May 31, 2022 at 7:46 pm
First, welcome aboard.
Understand that your reply looks like a "prelude to spam" that spammers regularly use to see if they successfully got a working account. They also...
May 31, 2022 at 3:01 pm
As a bit of a sidebar, your slowest queries are frequently NOT your worst queries. Rather it's usually some fairly small stuff that gets called thousands of times per hour. ...
May 31, 2022 at 2:55 pm
I stated in early post I couldn't supply file but fill check table as you gave a good starting place... What about job_type in there twice?
Thx.
Check the code. Do...
May 31, 2022 at 2:22 pm
Thanks for the answer.
Hi and welcome aboard, Robert.
Understand that your reply looks like a "prelude to spam" that spammers regularly use to see if they successfully got a working...
May 31, 2022 at 2:19 pm
A bit of a sidebar... I almost always avoid both EOMonth and anything else that is used to calculate the last day of the month because so many people forget...
May 31, 2022 at 2:16 pm
Sorry... not enough coffee yet. Misread some code and removed the post.
And I totally agree with Johan... avoid Scalar UDFs at all costs. They even prevent parallelism if you do...
May 31, 2022 at 2:06 pm
Thanks for the reply.
Weird that this is somehow not more public knowledge since the problem seems to be pretty impactful and somehow mentioned "no where" in most (popular) google...
May 31, 2022 at 2:01 pm
Referring to the following page, search for the number 128. It turns out that's a threshold and its 128 extents. Since an extent is 8 pages and there 128 of...
May 31, 2022 at 8:04 am
Great "Decoder" post. Thanks for taking the time to put it together, Steve. You're the best!
Joining in the "Decoder" fun, decode this. 😀 Folks like Lynn Pettis will have no...
May 31, 2022 at 6:32 am
Hello Johan.
I have a couple of Scalar Functions that are sub-second.
1 that I use every day passes an IP Address/Subnet in and returns a human friendly site name by...
May 30, 2022 at 11:29 pm
Thanks for the feedback, Thom. I appreciate it.
May 30, 2022 at 2:19 pm
Also, if you need something "right away", they do have a previous presentation of mine on the subject. I have a couple of "mis-speaks" that I made during the "heat...
May 30, 2022 at 2:08 pm
Viewing 15 posts - 121 through 135 (of 55,829 total)