There's a difference (to me, anyway) between a table that suffers a whole lot of INSERTs and a table that suffers UPDATEs.  Run logs (with only one exception that's not...

I have a very huge table (60GB) used for logging purpose(100 of records logged every second). Now the developers have added a new update script as procedure which is...

Ya know... since they've updated this forum to new software, that's a really good question.  I hope they fix...

Apologies... it took longer to find than expected.

The following code makes up to 450 possible substitutions.  Details are in the code.  Please understand that I've not tested the method I...

Heh... wrong color... it needs to be a Red Herring to chop down trees with. 😀

The NULLs for EACH ROW are actually stored in the Row Header of EACH ROW and, as of 2012, is always stored for every column even if the column is...

If you work for an organization that counts lines code as a metric for developer productivity, then RedGate's "SQL Prompt" extension for SSMS is a great investment. A poorly...

To be honest, there's something wrong with such people's mentality.  As a good online friend of mine once said, "It's probably 'cuz their mommas didn't know how to cook with...

I agree with the others about using the "Divide'n'Conquer" method.  The only thing is that if the output of these views is massive, you could end up having some problems...

This sounds like the storage (SAN/mountpoint?) where the LOG file was...

Thanks.  I've got to find some old code I wrote for fixing street addresses that did (IIRC) 400 replacements.  I'll look for it after work tonight.

I think the reason why you've gotten no help is because you've not provided any readily consumable data.  Please see the link in my signature below for one way to...

I've used this and it certainly wasn't overkill. The client had a lot of resources on the SQL Server, but the main database was highly transactional, and performed very...

So how did you fix the issue?  And when did the issue occur?  After a restart or what?

How many possible rows are going to be in the Search/Replace values table?