Viewing 15 posts - 7,141 through 7,155 (of 8,415 total)
sqlrunner (9/4/2009)
September 8, 2009 at 3:51 am
GilaMonster (9/8/2009)
Well, excluding bulk-logged operations in bulk-logged recovery model.
You make it sound as if backing up the log, switching to the BULK_LOGGED recovery model, performing minimally-logged operations (like an index...
September 8, 2009 at 3:35 am
A differential backup contains all the changes since the last full backup.
An incremental backup contains all the changes since the last incremental backup (or the full, if no incrementals have...
September 8, 2009 at 3:15 am
winston Smith (9/7/2009)
September 8, 2009 at 3:07 am
GilaMonster (9/8/2009)
Paul White (9/8/2009)
If no errors are reported after a stage, you know that the corruption occurs somewhere in the following log restores.
Log backups generally will only have corruption in...
September 8, 2009 at 3:03 am
Indianrock (9/7/2009)
September 8, 2009 at 2:54 am
Actually, I might have misread the question first time around - I thought you were asking what to do if you received the DBCC message after restoring the database from...
September 8, 2009 at 2:33 am
winston Smith (9/7/2009)
September 8, 2009 at 2:07 am
benyos (9/7/2009)
Assuming your inline comamnds are plain SQL or through exceptions when there are internal erros, you could simply use the built in mechanism in SQL 2005:
You should check XACT_STATE()...
September 7, 2009 at 11:48 pm
This really needs to be in a stored procedure, and you should convert the query to a SARGable form.
See my previous post.
September 7, 2009 at 10:25 pm
TheSQLGuru (9/7/2009)
BTW, are you going to PASS this year? Would love to meet you.
This is NOT an on-line dating service :laugh:
September 7, 2009 at 10:17 pm
September 7, 2009 at 9:52 pm
Bob Hovious (9/7/2009)
I think I will start referring to you as Emperor Paulpatine.
Truly, you do deserve your reputation as a monitor-killer.
I was enjoying that cup of coffee too 😎
September 7, 2009 at 8:38 pm
Bob Hovious (9/7/2009)
Many thanks, Paul.Grant, I liked this question, even though I got it wrong. 😉
You're most welcome.
I haven't answered the question yet - but once again the discussion...
September 7, 2009 at 8:35 pm
crainlee2 (9/4/2009)
Yes, running against the production server. Plenty of reserve power. No harm in doing it. DTA barely shows any resource utilization on PERFMON.
It's good to know that DTA is...
September 7, 2009 at 7:37 pm
Viewing 15 posts - 7,141 through 7,155 (of 8,415 total)