Spot on, Grant.  Especially with only 12GB of RAM available.

Ah... didn't see Mike post while I was typing.  I also meant to say that once you're sure the code it produces is correct, change the PRINT @sql to EXEC...

As Grant suggests, the use of Dynamic SQL would be the ticket here.  Use a pattern search (LIKE) on the names of stored procedures in the sys.procedures system view to...

@frederico_fonseca ,

You should write a short article on the NULL/Empty String collision problem you pointed out to me.  It's a great catch.

Just in case anyone is interested in this script, the latest upgrade to the software on this site broke the link in the first post and it will take you...

I have a table which is partitioned (Total 10). The table is 1.6 TB in size. Rebuild index on that is quite challenging, especially we have some resource constraints....

Just as a sidebar in personal frustration, XML never ceases to amaze me in its inefficiencies.  The original XML in the original post occupies 244 characters.  Even if you convert...

I'll also state that RegEx is serious overkill for the type of validations you've described.  You certainly don't need CLR, either.  The example the ratback provided above will work quite...

Thanks for the feedback, Mike.  You're the second person I've heard of (I'm sure there are more that I haven't) that had the backups encrypted by ransomware.  I think I...

Thanks for the info, Solomon.

I don't know how to to what you ask but we backup all files when they're created and then again if they change.  For us, there would be no problem...

I'm checking the latest file created in a folder, and if it's GT than 1K ... I'm going to do further processing..

Is this a correct way to check that?

Thanks.

You should do a search on sys.tables instead of taking my word for it. ...

Sorry for the confusion, Jeff...that's partly why I wanted to include the graph of the plan performance but I didn't explain well. The "bad" plan I uploaded was the...

A quick way to check is to query against sys.tables in a database.  Every...