Viewing 15 posts - 1 through 15 (of 19 total)
In fact whilst the first answer works, the second answer is more correct since an instance of SQL Server 2012 would also do the job.
March 19, 2014 at 5:13 am
I'd be interested to know what your rationale was for going for the answer you did.
Can you explain please? I just want to know whether my assumptions were different. Did...
January 30, 2014 at 9:03 am
The question requires you to make some assumptions (the compressed database is wholly compressed, and the data is basically the same in both databases, for instance).
The answer is based on...
January 30, 2014 at 8:48 am
No - The create sp statement has to be the first statement in the batch, so, as written, the TSQL will not execute. (Try it.)
March 1, 2013 at 6:24 am
Good question.
However just because I could get away with a differential backup, the 'once bitten twice shy' part of me would always go for a full backup unless there was...
June 28, 2012 at 4:35 am
Good question that made me think. Shame the quoted reference doesn't match the 'correct' answers.
February 20, 2012 at 2:10 am
Just because you CAN trick SQL Server into allowing a computed column to indirectly reference columns in other tables does not mean you should. My strong suspicion is that if...
January 31, 2012 at 4:02 am
Good question, however the answer is a bit pedantic, so I'm going to be a bit pedantic in my comment. Whilst you can't disable full text search at the database...
October 28, 2011 at 3:38 am
Poorly worded question that has nothing to do with the the subject in the title and with none of the possible answers matching what actually happens in practice.
Other than that...
July 20, 2011 at 6:49 am
SQL Server Central have screwed up the answer to question of the day!
The world is deafened by the sound of wailing and gnashing of teeth!
Can I have my point, please?:crying:
July 15, 2011 at 2:19 am
It seems to be a common thread with a few of these questions which is that you have to try and second guess what the questioner meant to ask rather...
March 30, 2011 at 2:15 am
The answer I got is 1,2,3,4. Running through SSMS 2008 R2 to an instance of SQLServer 2005.
Seems like nobody tested this properly! That's the real answer that should be taken...
December 23, 2010 at 4:30 am
Yep. I missed something - as th eprviuous poster said I was supposed to be selecting the incorrect answers.
Doh!
November 11, 2010 at 2:29 am
Viewing 15 posts - 1 through 15 (of 19 total)