I have to admit that I'm seriously concerned about AI, especially but not limited to when it's been asked to do something in SQL.

When it comes to such a thing,...

I can't see any of the comments that were posted according to the discussion pages near the bottom of the article,

the reason why the code was removed (post deleted really) is because since sometime ago any post that contains 2 URL's gets that treatment. there is no error, just...

I hope I'm not too late... simple conversions of DATETIMEOFFSET(7) to DATETIME will cause rounding up to the next unit of time once out of every 600 times... and that...

• This reply was modified 5 days, 11 hours ago by Jeff Moden. Reason: Forum software kept destroying the post

The timing is less than ideal but that 21 years means I'm going to get quite a significant payout.  By my calculations, after tax it's a year's money so...

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