Hard lessons in the past (especially for but not limited to SQL Server 2012) have "helped" me understand not to trust Microsoft for at least a year (and sometimes more)...

Like Granny used to say, "The faster they move, the behinder they get".

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...

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...

If only...

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)...

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...

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,...

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...

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...

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...

Let me understand this clearly... an "intern" had the privs to bring a production database down?

Seriously???

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...

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...

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...