Viewing 15 posts - 346 through 360 (of 584 total)
Duncan Pryde (7/3/2012)
There might be someone who does, but this thread from someone trying to find out makes entertaining reading (he never got his answer): http://social.msdn.microsoft.com/Forums/en-AU/sqldatabaseengine/thread/04d9917d-fc05-4e3e-ba70-0e8a3eac3fe8
Thanks for the link. I...
July 3, 2012 at 7:16 am
Thanks for the question. I thought it was bad enough being in America where most everyone uses mmddyyyy. But, yyyyddmm makes even less sense to me. Anyone know why thats...
July 3, 2012 at 5:55 am
Bob Razumich (7/2/2012)
July 2, 2012 at 6:31 am
I had the advantage of being so old, that Ron's series was a distant, fuzzy memory. So, I got it right.
However, when running the script as provided, I got this...
June 29, 2012 at 5:52 am
Thanks for the question Steve. I was surprised to see the number of incorrect answers. I hardly ever administer DBs, mostly design and programming. Maybe the lack of certainty about...
June 28, 2012 at 5:47 am
I too went for the #2 choice. I knew that the no index would be created automatically, but thought ..... same as the others. At least I have lots of...
June 27, 2012 at 6:28 am
Thanks for the question. Never used NULLIF, so forced me to investigate.
I got my point, but am inclined to agree with those that feel that the question could have been...
June 26, 2012 at 5:45 am
Christian Buettner-167247 (6/25/2012)
June 25, 2012 at 5:52 am
Arriving later on the scene than others, primarily due to time zone (and the fact that I don't get up at 3 AM to do the QotD), all I can...
June 22, 2012 at 7:02 am
tommyh (6/21/2012)
Works just fine to attach a database with just "for attach" with only one log file.
/T
I figured it would. But it's nice to have it confirmed. (Yes, I...
June 21, 2012 at 7:25 am
David P Fisher (6/21/2012)
ipounder (6/21/2012)
Seems to me that both answers can be correct.Ian
I agree 🙂
Anybody care to test it? 🙂
Thanks for the question.
BTW, love the cat with the mice crawling...
June 21, 2012 at 6:23 am
Thanks for the question. I thought it was too easy to be true at first.
As for the "depends on the file system" consideration, "maximum database size in SQL Server 2012"...
June 20, 2012 at 5:35 am
Sean Lange (6/19/2012)
Thomas Abraham (6/19/2012)
Of course you are correct. My mind must still be on that beach. Thanks for correcting me.
I wish my mind was still on the beach...so jealous....
June 19, 2012 at 7:57 am
Sean Lange (6/19/2012)
Thomas Abraham (6/19/2012)
Appreciate the question. Had to think for a minute, as I almost never use OUTER joins.
I suspect you actually use outer joins far more frequently...
June 19, 2012 at 7:53 am
mbova407 (6/19/2012)
no riots?
The five days we were in Athens, right up to the 15th, there was nada. We did see a gathering of about 500 people for a speech. The...
June 19, 2012 at 6:25 am
Viewing 15 posts - 346 through 360 (of 584 total)