Viewing 15 posts - 121 through 135 (of 179 total)
Great question. For me, I couldn't decide between the background task running after the ALTER DATABASE command completed or immediately, before the ALTER DATABASE completed, as the background thread is...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
July 5, 2011 at 2:18 am
ako58 (7/5/2011)
ms-help://MS.SQLCC.v10/MS.SQLSVR.v10.en/s10de_4deptrbl/html/c75d0d4b-4008-4e71-9a9d-cee2a566bd3b.htmThe pages in an encrypted database are encrypted before they are written to disk and decrypted when read into memory
That's right, for new writes, but when encryption is set...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
July 5, 2011 at 2:13 am
Good questions, thanks.
Unfortunately, I rushed the answer and got it wrong! Doh!
Not enough due diligence 🙂
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
June 22, 2011 at 2:59 am
Tom.Thomson (6/15/2011)
I guess about two thirds getting it right is reasonable, as it's something a lot of people will not have come across. But currently 16%...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
June 15, 2011 at 5:01 am
Ach... I used that msdn article as my reference before answering the question. However, nowhere does it mention "Software NUMA" but instead uses "Soft-NUMA" (which was not an answer option),...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
June 14, 2011 at 3:31 am
A 50/50 chance of getting this right and, at this time, 50% got it right LOL!! 😀
Fortunately, I'm in the right half. Cheers Steve.
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
June 9, 2011 at 4:57 am
honza.mf (6/7/2011)
DugyC (6/7/2011)
honza.mf (6/7/2011)
WayneS (6/6/2011)
1. NEWID() returns a random GUID (aka uniqueidentifier)
2. Select statement has no order...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
June 7, 2011 at 5:02 am
honza.mf (6/7/2011)
WayneS (6/6/2011)
1. NEWID() returns a random GUID (aka uniqueidentifier)
2. Select statement has no order by clause,...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
June 7, 2011 at 3:34 am
Yep, 2 different questions with 2 different answers.
Fortunately for me I answered the second question, but I can understand the frustration for those that answered the first.
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
May 27, 2011 at 3:09 am
SanDroid (5/23/2011)
GilaMonster (5/23/2011)
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
May 24, 2011 at 4:23 am
Great question! Nice to start off the week with. Thank You.
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
May 23, 2011 at 3:33 am
Koen Verbeeck (5/20/2011)
Nice question. Had to do some research on 8.3 naming.
Me too 🙂 Cheers Steve, learnt something new again.
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
May 20, 2011 at 3:08 am
Nice, and quite straightforward, question for a Monday morning. Thank you.
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
May 16, 2011 at 3:15 am
Living in the UK was sorely tempted to go for the SQL Server answer, but couldn't find the definite date of release through Google... so went to eliminate the rest...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
April 15, 2011 at 2:21 am
Great question perfectly worded. It was quite clear that dateformat was relevant to the question and that you were looking for only the 2 statements that would work under all...
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]
April 13, 2011 at 3:09 am
Viewing 15 posts - 121 through 135 (of 179 total)