Viewing 15 posts - 1,891 through 1,905 (of 19,564 total)
I like to have the safety net. Allow for the log to grow just in case so it doesn't bring down an application.
If the log file does grow, you...
October 17, 2014 at 9:23 am
Rechana Rajan (10/17/2014)
Thanks a lot BrainDonor,Can high CPU usage over 95% for hours will bring SQL Server down??
It depends on what is causing the high cpu. If you have...
October 17, 2014 at 9:14 am
Joy Smith San (10/17/2014)
That depends. Are you rebuilding those unwanted indexes? Are you rebuilding all of your indexes? Or are you using a defrag process that is...
October 17, 2014 at 7:54 am
Joy Smith San (10/16/2014)
Grant Fritchey (10/16/2014)
The size of the indexes is much more of a question than the number of them.
Thank you.
So if I have multiple unwanted indexes, obviously...
October 16, 2014 at 8:45 pm
Sounds like the cleanup job is not running properly.
You should also check your cdc capture job and make sure it is running without error as well.
October 16, 2014 at 7:59 am
Here is a quick article on how to dedupe data.
http://jasonbrimhall.info/2011/03/21/dedupe-data-cte/
Since you know the data is duplicated, then use whatever criteria you know should make the data unique to help identify...
October 16, 2014 at 7:29 am
Ed Wagner (10/15/2014)
crookj (10/15/2014)
SQLRNNR (10/15/2014)
bifurcatedforked
Tongue
UVULA
October 15, 2014 at 10:00 am
Ed Wagner (10/14/2014)
SQLRNNR (10/14/2014)
Ed Wagner (10/14/2014)
crookj (10/14/2014)
SQLRNNR (10/14/2014)
djj (10/14/2014)
Ed Wagner (10/14/2014)
Stuart Davies (10/14/2014)
BWFC (10/14/2014)
Ed Wagner (10/13/2014)
djj (10/13/2014)
Ed Wagner (10/13/2014)
SQLRNNR (10/13/2014)
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Brulee
Fire
Torch
Singer
sewing (machine)
Needle
Thread
Doe
Buck
Rifle
shotgun
Venison
cow heart
October 14, 2014 at 10:39 pm
Steve Jones - SSC Editor (10/14/2014)
We implemented ASKIMET for posts. This took effect today and shouldn't slow things down, but we are evaluating and discarding SPAM posts....
October 14, 2014 at 2:35 pm
Eirikur Eiriksson (10/14/2014)
Luis Cazares (10/14/2014)
Thank you for the update, Steve.
In an unrelated topic, have you ever seen...
October 14, 2014 at 2:33 pm
Ed Wagner (10/14/2014)
crookj (10/14/2014)
SQLRNNR (10/14/2014)
djj (10/14/2014)
Ed Wagner (10/14/2014)
Stuart Davies (10/14/2014)
BWFC (10/14/2014)
Ed Wagner (10/13/2014)
djj (10/13/2014)
Ed Wagner (10/13/2014)
SQLRNNR (10/13/2014)
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Brulee
Fire
Torch
Singer
sewing (machine)
Needle
Thread
Doe
Buck
Rifle
shotgun
October 14, 2014 at 10:40 am
Steve Jones - SSC Editor (10/14/2014)
Is quoting and general access slow for anyone else today?
It was painfully slow the past few days but seems a bit better today.
October 14, 2014 at 7:31 am
djj (10/14/2014)
Ed Wagner (10/14/2014)
Stuart Davies (10/14/2014)
BWFC (10/14/2014)
Ed Wagner (10/13/2014)
djj (10/13/2014)
Ed Wagner (10/13/2014)
SQLRNNR (10/13/2014)
djj (10/13/2014)
SQLRNNR (10/13/2014)
DanishPastry
creme
Brulee
Fire
Torch
Singer
sewing (machine)
Needle
Thread
Doe
October 14, 2014 at 7:30 am
Viewing 15 posts - 1,891 through 1,905 (of 19,564 total)