Why do "hundred of millions of rows" need to be updated?  If we knew what the table was for, what the structure was, and the need to do the update,...

Totally agree with the XP_CmdShell thing.  Of course, if you do that, you don't need PowerShell to begin with.  Just create the file deletion commands directly from MSDB backup history...

And that is no slight on the other SQL Saturdays.  It takes a good bit of dedication and good planning to make an SQL Saturday and I've not seen a...

It WAS working for me before on both places it is no longer working.  I've not made any security level changes in FireFox or Chrome, either.

I hope I don't have...

Why are you trying to do this in SQL, this is something that's extremely trivial in powershell, as in 1 line of code.   (Get-ChildItem -Path ("C:\Test\*.txt") | Sort-Object...

I don't see an upcoming SQLSaturday in Pittsburgh... for Sept, I only see events in Boston and Memphis in the US. Has it been announced yet? No, we always...

IIRC, the file paths and the fact that they're "COPY ONLY" are stored in the MSDB database.  I think it would be a simple, very quick, and very accurate method...

In addition to the other posts: Perform the operation in a transaction at first do it with ROLLBACK, so that you can verify that you got the correct results...

No... they haven't announced it yet.  IIRC, they normally announce it sometime in June.

Search for Brent Ozar's sp_Blitz.  I consider it to be a gold standard along with many of his other "Blitz" scripts.  The cool part is you can dump the output...

Yep... I know why it's there.  I just think the implementation leaves a bit to be desired.

I wonder why it's not working for me.  It times out for IE (yeah, I know but had to try) and FireFox on my personal laptop and it times out...

To add to that problem, when you're creating a post and need to lookup a BBCode and click on the "BBCode tags reference" (which points to https://www.bbcode.org/reference.php ), it takes...

On a different note, I'm really happy that they fixed the "code wrapping" and indentation issues on this forum but, unless they limit the vertical height of the code window,...

Like the article. I'd like to point to the fact that "PRINT @sql;" is limited to 4000 characters, therefore I use "SELECT CAST('<root><![CDATA[' + @sql + ']]></root>' AS...