Viewing 15 posts - 5,941 through 5,955 (of 22,211 total)
Real life badass, Dracula, Saruman, Christopher Lee is no more
June 11, 2015 at 6:30 am
Capture the wait statistics on the job to see where it's slowing down.
June 10, 2015 at 6:53 pm
If the log has grown that's because there has been either some very big transactions, or there's a transaction that's open and not closed preventing the other transactions from clearing....
June 10, 2015 at 6:51 pm
You could RAISERROR after the rollback is complete so that your alert fires.
June 10, 2015 at 6:01 am
Just make sure you go to the execution plan to understand which of the indexes you have in place are being used and how they're being used. That can act...
June 10, 2015 at 3:40 am
Usually follow the Cumulative Update path. When they come out, get them, put them on Dev, see what happens there and then slowly march them through the various environments prior...
June 10, 2015 at 3:37 am
Piling on, Eirikur's request for information is really the only way to get to the bottom of this.
For the most part, I've usually seen improved performance on most queries. It's...
June 10, 2015 at 3:33 am
SQLRNNR (6/9/2015)
Grant Fritchey (6/9/2015)
So tempted to whip out "DO YOU KNOW WHO I AM?"Time to walk away from the forums for a few...
Where the **** is that tent?
Well, I don't....
June 10, 2015 at 3:03 am
GilaMonster (6/9/2015)
Grant Fritchey (6/9/2015)
So tempted to whip out "DO YOU KNOW WHO I AM?"Need a hand somewhere?
Nah, just a break. It actually wasn't a big deal. I'm glad I stayed...
June 9, 2015 at 4:42 pm
GilaMonster (6/9/2015)
GilaMonster (6/9/2015)
ericpap (6/9/2015)
Joie Andrew (6/9/2015)
Another question, you say that you only have two logs available. If you look at the C:\Archivos...
June 9, 2015 at 4:27 pm
Those stats get created when someone does a filter operation like a WHERE clause or a JOIN on columns that don't have either an index or custom statistics. The optimizer...
June 9, 2015 at 1:05 pm
ericpap (6/9/2015)
Alvin Ramard (6/9/2015)
ericpap (6/9/2015)
Alvin Ramard (6/9/2015)
Have you discussed this problem...
June 9, 2015 at 1:02 pm
I agree. It's always good to know what ultimately worked.
June 9, 2015 at 12:56 pm
So tempted to whip out "DO YOU KNOW WHO I AM?"
Time to walk away from the forums for a few...
Where the **** is that tent?
June 9, 2015 at 9:28 am
Viewing 15 posts - 5,941 through 5,955 (of 22,211 total)