Viewing 15 posts - 31 through 45 (of 106 total)
The answers should have been a little more varied; as soon as one recognizes that restrictions 1 and 2 are both true, then 3-5 do not matter because 'all true'...
July 15, 2015 at 6:45 am
Ed Wagner (7/13/2015)
And here I thought I'd be the first one to comment that I don't like XML. 😀
Nope, lots of people hate XML. (raises hand)
I messed it up; didn't...
July 13, 2015 at 6:33 am
ZZartin (7/10/2015)
Xavon (7/10/2015)
July 10, 2015 at 8:19 am
It depends. We effectively have two systems, one for managing the business and the other for reporting. For the management system, downtime is more important. For the...
July 10, 2015 at 6:31 am
matthew.flower (7/1/2015)
As the first two answers...
July 1, 2015 at 6:33 am
Agreed on the vagueness. I got it right for the wrong reason; I thought "the other four are for row identification (in some way, shape, or form) while DATEADD is...
June 29, 2015 at 6:36 am
Of course perfect availability is impossible. Even you have mirrored copies of your DB in six different data centers, and only do maintenance on one at a time, you...
June 19, 2015 at 6:27 am
I thought it was number three, but when I ran dbcc checkdb on SalesArchive (from the last two questions about disabled Clustered Indexes), I got back an error saying it...
June 18, 2015 at 6:27 am
Xavon: I never rename objects!
Chorus: What, never?
Xavon: No, never.
Chorus: What, never?
Xavon: Well... hardly ever!
But seriously, the most common reason I rename objects, is when a non-null...
June 12, 2015 at 6:32 am
Yeah, I did it. I figured out the author's intent instead of the proper literal interpretation of the question.
I guess it helps that this is a follow-up...
June 10, 2015 at 6:27 am
I somehow read the options 2 &3 three as sproc is/is not created, not sproc is/is not executed. So I picked 2 instead of 3. Got 3/4, can...
May 14, 2015 at 6:39 am
Interesting question.
But I am disappointed the QotD was not May the 4th related.
May 4, 2015 at 6:19 am
Situation where this would be used... A sproc that creates a global temporary table, calls other sprocs on separate threads to populate/update that table and uses CDC to monitor...
April 30, 2015 at 6:37 am
An interesting point on this; PCI PADSS (credit card industry rules) require that the system be under support. So if your 2005 database holds credit card information, even if...
April 30, 2015 at 6:30 am
Upgrade Treadmill, or Upgrade Hamster Wheel?
It could be worse. Despite being a software developer with a side of DBA, my company does not let me control when upgrades get...
April 27, 2015 at 6:28 am
Viewing 15 posts - 31 through 45 (of 106 total)