To be honest, 500GB of TempDB is terribly large for most servers.  You'd probably do well to find out the cause.

Whatever happens, don't do a shrink.  It's a waste of...

It sounds like they're using the "Right click on the database in the object explorer" method.

FWIW - I backup a 6TB+ database every night in less than 2 hours.  That process backs up to a local drive - then copies the file to another...

On the first item, I'm not grokking what the anomaly is that you speak of.

On the second, lookup the LEN() function and the SUBSTRING function.

p.s.   Since ID seems to be a sign of grouping, do you want this done by groups formed by ID or what?  Is that why row 6 wasn't returned in...

Thank you.

Under normal conditions, when a row goes negative, the query lists the rows before that row.

However, if a movement has never been negative, it does not bring the...

I'm no help here but that "password in text" stuff is one of the reasons I hate it. 😀

Is that with our without Leap Seconds? 😀

I keep it real simple... I assume it's my problem until I can prove, usually with code or logs, that it isn't actually my problem.  As the old saying goes,...

Normally, when a company buys another company, like Solar Winds did, and the announce the discontinuation of a product that was owned by the company that was bought, they also...

Quote removed... it actually had a spam link in it that I flat out missed.

Thanks for the heads up, Frederico.

I guess I don't understand the issue here.  Just load up all the files name for, say, the employee table and process them in date order.  Then, move the processed...

@jeff Moden,

I updated my queries and now there are no 1900 dates for where death date does not exist. I added a new bit of code to the ETL...

Thanks for the feedback, Pat.  It sounds like you've got things under control.

I definitely agree with that.  Thanks for stopping...