I've found out the hard way in my early days that "Moving the Files" <> "Successfully moving the database".

If you are only moving the application databases (not the system databases). You can just detach the databases, move the database files to a different location then just Attach...

Who who or what was it that wrote "Reorganizes or Rebuilds index to optimize data base performance"?  The human author or the AI? 😀

Anyway, thanks for the article, Daniel.  I...

If I am interviewing for a new position, I always ask if I can be shown round the office and see some of the team. Whether existing people are...

Between that and the GENERATE_SERIES()  defeating Minimal Logging (article coming out on that on the 18th) and the DATETIME rounding issues into the next day that started in...

Sorry.  Post deleted.

@Frederico,

As you know, MS doesn't make it easy to find the correct documentation for doing certain things.  Do you have a link that might help the OP out?

Good Lord!  I've got more testing to do but I ran a simple "Tally CTE Function" test in 2017 and 2022 on my laptop.  The results are REALLY disappointing.

It's not the "last post" that doesn't show up.  It's the first post on a new page.  It's been a problem for a very long time just like...

Heh... you were right, Phil.

It's not the "last post" that doesn't show up.  It's the first post on a new page.  It's been a problem for a very long time just like the spam...

On a personal note, I just don't understand companies that post a webinar and, to register, they REQUIRE you have to provide your phone number and, frequently, a lot more...

Maybe it's something wrong with FireFox but I see no "stack trace" in the original post.

Please check the trace flags in the server startup.  There is a trace flag that can be set to force the old CE to be used and someone may have...

You bet, Sam... let us know how it turns out, please.