Viewing 15 posts - 301 through 315 (of 380 total)
Nice easy Monday question. 😀
Could have been worded a little better. 😎
August 12, 2013 at 6:19 am
WWDMark (8/12/2013)
FYI: If anyone didn't know, this also a deprecated feature, see http://technet.microsoft.com/en-us/library/ms151149.aspx
That is right. CDC and new SSIS features replace this.
August 12, 2013 at 6:18 am
Festeron (8/9/2013)
PHYData DBA (8/8/2013)
This happens every day somewhere.... Some days it happens and the ad-hoc backup that was created has been deleted....
Backup chain totally busted at that point.
Joie Andrew...
August 9, 2013 at 11:59 am
Good easy question on new TSQL functionality... Thanks Steve! 😎
August 9, 2013 at 10:15 am
Steve Jones - SSC Editor (8/8/2013)
In general, here's what I'd say. Separate LUN if possible, but not critical. Go with # cores for <= 8. After that, stick...
August 8, 2013 at 1:17 pm
Nice question. Even Better your explanations.
If only I had paid enough attention to see it was multiple options....
August 8, 2013 at 1:10 pm
ok181ko (8/8/2013)
How aboutnewid() = '00000000-0000-0000-0000-000000000000'
The question is not correct. Answer is 0 (zero).
Question was which of the following could be returned.
Zero is possible but was not in the...
August 8, 2013 at 1:08 pm
What is your opinion on how many TempDB files you should have?
I know that it is best to have the TempDB on it's own LUN separate from all others.
I have...
August 8, 2013 at 1:02 pm
Steve Jones - SSC Editor (8/8/2013)
August 8, 2013 at 1:00 pm
Myth 6: Full and differential backup breaks the log chain
Truly a myth.... since tran log backups are only linked to the last tran log backup the only way to break...
August 8, 2013 at 10:17 am
PHYData DBA (8/8/2013)
chuck.hamilton (8/8/2013)
This happens every day somewhere.... Some days it happens and the ad-hoc backup that was created has been deleted....
Backup chain totally busted at that point.
I...
August 8, 2013 at 10:05 am
chuck.hamilton (8/8/2013)
This happens every day somewhere.... Some days it happens and the ad-hoc backup that was created has been deleted....
Backup chain totally busted at that point.
I dont think...
August 8, 2013 at 9:53 am
chuck.hamilton (8/8/2013)
If your backup solution/server version allows you to restore transaction logs created after a full backup to an earlier full backup file without having the differential backup or full...
August 8, 2013 at 9:45 am
Viewing 15 posts - 301 through 315 (of 380 total)