Viewing 15 posts - 196 through 210 (of 832 total)
KWymore (7/12/2013)
MSDN confused me on this one. Oh well, learned something new. Thanks for the question Steve!
Same here! The TDE article did seem to imply you needed both backups...ah well,...
July 12, 2013 at 9:32 am
This Connect item suggests Microsoft acknowledges this as a bug and that it'll be fixed in the "next major release", whatever that is...
July 10, 2013 at 8:58 am
GilaMonster (7/8/2013)
It will use the first then the second then the first again then the second again, etc. The log files will only grow if both are full.
Just curious--will SQL...
July 9, 2013 at 9:04 am
Is ISNULL such an expensive operation, then? (Genuinely curious, never actually sat down and analysed it)...
June 27, 2013 at 2:23 am
Not sure how I can explain my reasoning (or lack thereof, probably) more clearly, sorry...
June 26, 2013 at 8:27 am
Jeff Moden (6/25/2013)
No. NULLs cannot be compared to so they would also be excluded from any check for <> 0. Try it an see.
I would tend to use...
June 26, 2013 at 8:01 am
Hugo Kornelis (6/19/2013)
The format yyyy-mm-dd is NOT a safe format. It does work in American English, but not in British English - just put "SET LANGUAGE British;" in front of...
June 19, 2013 at 8:10 am
There are other reasons for not moving on from a job. My main reason is that I absolutely hate looking for new jobs--I don't like the disruption, I never get...
June 18, 2013 at 7:15 am
As only 6% selected the wrong answer it must be down to not selecting three options. If you don't read the question you won't get the point 😉
In my case...
June 17, 2013 at 6:02 am
Generally that error means that something is not set up right in your new domain. For instance, the only occasions I can recall seeing it are when the DNS server...
June 4, 2013 at 6:07 am
Duncan Pryde (5/30/2013)
If the same values were put in both columns, we would still get different numbers of rows returned for all values of @x greater than 3 since ordering...
May 30, 2013 at 4:32 am
I actually got the right answer, but only because I misread the question--I assumed it was something to do with string sorting (where the sort order would become 1, 10,...
May 30, 2013 at 3:00 am
james.of.rivendell (5/16/2013)
nuh.. uh.. the 'correct' answer is wrong. This will produce a syntax error due to the misspelt column name in the subquery.
No it won't. Try running it yourself, and...
May 17, 2013 at 12:53 am
More information on granting appropriate file system permissions here:
May 10, 2013 at 3:06 am
Viewing 15 posts - 196 through 210 (of 832 total)