Viewing 15 posts - 9,376 through 9,390 (of 59,078 total)
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...
May 1, 2019 at 3:31 pm
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...
May 1, 2019 at 1:42 pm
Thanks all once again.. How can I attach the execution plan
Ya know... since they've updated this forum to new software, that's a really good question. I hope they fix...
May 1, 2019 at 12:20 pm
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...
May 1, 2019 at 12:59 am
Heh... wrong color... it needs to be a Red Herring to chop down trees with. 😀
April 30, 2019 at 10:44 pm
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...
April 30, 2019 at 9:15 pm
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...
April 30, 2019 at 1:45 pm
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...
April 30, 2019 at 1:38 pm
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...
April 30, 2019 at 1:27 pm
Thanks! I was able to solve this by taking database offline then immediately bringing it back online.
This sounds like the storage (SAN/mountpoint?) where the LOG file was...
April 30, 2019 at 1:07 pm
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.
April 29, 2019 at 11:11 pm
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...
April 29, 2019 at 10:53 pm
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...
April 29, 2019 at 10:46 pm
So how did you fix the issue? And when did the issue occur? After a restart or what?
April 29, 2019 at 10:39 pm
How many possible rows are going to be in the Search/Replace values table?
April 29, 2019 at 10:36 pm
Viewing 15 posts - 9,376 through 9,390 (of 59,078 total)