Viewing 15 posts - 1 through 15 (of 1,243 total)
removed dupe
July 10, 2024 at 7:05 pm
disregard. i found it. I'll reply w/ what i end up with to close the loop
Did you ever find the solution? If so, would you be kind enough to...
July 10, 2024 at 7:05 pm
For the love of whatever you hold dear, stop using “MMDDYYYY” formatting!
It doesn't sort chronology as text. You should be using “YYYYMMDD”.
September 15, 2023 at 1:56 pm
I don't see where anyone has already said it, so I'll say it… “MMYYYY” is a date format to avoid. Using “YYYYMM” instead will allow you to actually sort those...
July 27, 2023 at 4:29 pm
That’s the thing about tempdb, it’s true to it’s name. Nothing you put there is truly permanent. By using normal create commands in tempdb you don’t have to worry about...
April 29, 2023 at 3:44 am
Just create a “permanent” table in tempdb. It will persist and be available like any other table, until it is explicitly dropped or or the SQL service is restarted.
April 29, 2023 at 12:11 am
Maybe I'm missing something but it seems that there are two easier options...
1) put everything on your local test machine into SIMPLE recovery.
2) if #1 isn't an option, just do...
March 31, 2023 at 7:53 pm
Wow. Thanks Jason. I seriously had no clue. Like I said, my aim is to help, not collect accolades for a resume but that comment just made the last...
March 20, 2023 at 1:10 pm
Thanks, Jason. I have to tell you, you've made my month. I had no idea about that and I sometimes wonder to myself whether or not I accomplished my...
March 17, 2023 at 5:01 pm
Thank you both for the feedback and the very kind words.
Simply giving credit where credit is due. Prior to this particular article, the benefits of nested sets were known...
March 16, 2023 at 9:00 pm
Now that is impressive! Thank you for the update Jonathan.
March 7, 2023 at 2:44 pm
Assuming the pattern in the sample data is actually representative of your production data, the following would be simpler and more efficient as it eliminates the need to unpivot, sort...
March 7, 2023 at 2:30 pm
If that's what is coming out of ChatGPT, then my job is still safe for the time being.
All 3 of CGPT queries are doing an update of the entire table,...
March 7, 2023 at 1:51 pm
Viewing 15 posts - 1 through 15 (of 1,243 total)