Viewing 15 posts - 1 through 15 (of 59,053 total)
Like Granny used to say, "The faster they move, the behinder they get".
December 7, 2025 at 5:00 pm
I did that for the SQL Saturday in Kalamazoo, MI in 2013. I did a take on "Strolling through the park" to introduce my session on how to safely use...
December 1, 2025 at 6:36 pm
Too funny that people have given something like this a name. The problem has been brought to us by all the people the preach things like DONE > Perfection but...
November 30, 2025 at 8:36 pm
My biggest concern is people using it to do the things they don't know anything about.
A couple of recent examples that I've come up with are to ask AI 1)...
November 17, 2025 at 5:31 am
As for the old table, you were going to delete all but a million rows. When you're sure the copy worked correctly, just drop the old table.
Also, decide the maximum...
November 1, 2025 at 7:52 pm
I also read about using 'SWITCH' to map the data to the backup table, then insert the records back into the original table. Once the data dump is done,...
November 1, 2025 at 7:45 pm
If you're going to remove 25% or more of the data from a HEAP or a Table (Clustered Index Present), the best thing to do all the way around is...
November 1, 2025 at 6:32 pm
Good article. Thanks for taking the time to write it up.
What I'd like to see is...
You have a database that has a partitioned table. The partitioned table has 1 filegroup...
November 1, 2025 at 6:06 pm
This is a classic problem with where to start counting. It's compounded by the fact that when people generate the code for modification, it frequently adds a blank line above...
October 26, 2025 at 11:12 pm
Let me understand this clearly... an "intern" had the privs to bring a production database down?
Seriously???
October 26, 2025 at 7:29 pm
I think opinions are great for the same reasons as you, Grant. Just not when it comes to things like code. I've seen way too many things that turned out...
October 19, 2025 at 10:55 pm
Oz-860645 was happy to come here for a quick answer but then says "Nevermind, I figured it out." and disappeared.
When I created the synonym I did it without the...
October 17, 2025 at 6:49 pm
Sorry I'm lat on this thread and I may have missed it but no one is talking about the licensing costs of the SQL Server on the separate machine.
Also, did...
October 17, 2025 at 5:38 pm
When you want it 100% correct, you should use ORIGINAL_LOGIN().
Especially when, IMHO, people use that nasty little word of "audit" like they did in this question.
October 7, 2025 at 1:40 am
Viewing 15 posts - 1 through 15 (of 59,053 total)