Viewing 15 posts - 2,086 through 2,100 (of 2,783 total)
I'm with Jeff, and I'd toss in a few other suggestions as well...
First, pick up or download (hey, it's free!) a copy of "Troubleshooting SQL Server A guide from the...
June 26, 2014 at 8:07 am
Ed Wagner (6/20/2014)
Stuart Davies (6/20/2014)
BWFC (6/20/2014)
AtheistMuse
Beckett
Castle
June 20, 2014 at 9:21 am
Short answer:
Nope.
😀
Long answer:
The only way to "break" the TLog backup chain would be to switch the DB to Simple recovery and back to Full. If you had a full...
June 19, 2014 at 12:07 pm
Ed Wagner (6/19/2014)
SQLRNNR (6/19/2014)
Stuart Davies (6/19/2014)
Sean Lange (6/19/2014)
SQLRNNR (6/19/2014)
JAZZ Master (6/19/2014)
SQLRNNR (6/19/2014)
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
djj (6/19/2014)
Ed Wagner (6/19/2014)
crookj (6/19/2014)
Ed Wagner (6/19/2014)
Stuart Davies (6/19/2014)
rhythmk (6/19/2014)
Stuart Davies (6/19/2014)
BWFC (6/19/2014)
MethodTechnique
Procedure
Stored
Function
Script
Visual Basic
Visual...
June 19, 2014 at 10:22 am
Quite possible, and relatively easy to do.
Just keep this guide handy:
http://msdn.microsoft.com/en-us/library/ms143799(v=sql.105).aspx
and you shouldn't have any problems.
Of course, you also need to change the connection on the workstations, which depends on...
June 18, 2014 at 12:29 pm
Well, the log results are in, and the cause of the time increase?
The Index rebuilds. They're around 1/2 (maybe a bit more) of the total time for the SSIS...
June 18, 2014 at 6:56 am
Koen Verbeeck (6/18/2014)
jasona.work (6/18/2014)
Figured it was a glitch on our network here...It was a glitch in the matrix, Neo.
That explains the deja-vu when I saw the same person walk past...
June 18, 2014 at 6:38 am
Koen Verbeeck (6/18/2014)
jasona.work (6/18/2014)
Figured it was a glitch on our network here...It was a glitch in the matrix, Neo.
That explains the deja-vu when I saw the same person walk past...
June 18, 2014 at 6:38 am
I wonder if some of the site problems are due to the influx of soccer (OK, OK, futball... OK, OK, football) spam?
Yesterday I had the "site-in-the-site" thing (yes, IE9)...
June 18, 2014 at 6:24 am
GilaMonster (6/17/2014)
Gotta love a review system where an above-average rating requires "Leaves only when work is done and stays to assist others""No pressure to work overtime" they say. :ermm:
Gotta love...
June 18, 2014 at 6:23 am
So, according to the customer, the application usage is right on-line with their historical rates, so it's not had a lot of churn, comparitively. The full backups have been...
June 17, 2014 at 9:18 am
Koen - You mean 'DBCC TimeWarp(SlowTime)' doesn't speed up response by slowing time for the end-user? Drat...:-D
I don't think Prod has slowed down, as none of the...
June 17, 2014 at 8:49 am
Jeff Moden (6/13/2014)
I guess that brings up another pet peeve of mine. Experts that talk in absolutes in a world where "It Depends" should rule.
Come now, there is at...
June 13, 2014 at 11:51 am
Ed Wagner (6/13/2014)
Jack Corbett (6/13/2014)
GilaMonster (6/13/2014)
- Tune a proc quick, then go home
- Wait, it's got user defined functions
- Wait,...
June 13, 2014 at 9:42 am
Viewing 15 posts - 2,086 through 2,100 (of 2,783 total)