Viewing 15 posts - 631 through 645 (of 812 total)
Steve Jones - SSC Editor (4/12/2011)
You do not have to post to get points...
April 13, 2011 at 2:57 am
Thank you very much for this beautiful qotd.
It's unbelievable, but true, only new types DATE and DATETIME2 work in any case.
April 13, 2011 at 1:29 am
The correct answer is "None of the above"
http://msdn.microsoft.com/en-us/library/ms188783.aspx
Tables must be referenced by two-part names, schema.tablename, in the view definition.
I want back my points.
March 30, 2011 at 3:47 am
In these days, I am changing collate on third party's database.
March 23, 2011 at 2:01 am
Unbelievable, but true!
Thank you for qotd and a clear explanation!
March 21, 2011 at 2:01 am
tommyh (3/18/2011)
I was hoping that SQL would fail on the last comma in the create table part. But SQL was just as happy to create a table like that./T
I...
March 18, 2011 at 2:20 am
Thank you for qotd. I really learnt something new and useful.
I should read it 10 times carefully, but at last, when I understand that the goal of qotd was to...
March 7, 2011 at 1:17 am
Koen Verbeeck (3/3/2011)
RAID 1+0: mirrored sets in a striped set (minimum two disks but more commonly four disks to...
March 4, 2011 at 1:24 am
This is an old problem with sql2000 too: restoring a database on a different instance, logins to database become invalid.
The solution is create login on the restoring instance with the...
February 7, 2011 at 1:16 am
Thank you Koen (da-zero).
Now, the qotd seems more clear!
😀
February 2, 2011 at 7:41 am
Koen (da-zero) (2/2/2011)
paul s-306273 (2/2/2011)
So, is the correct answer 'FALSE'?
No, it is TRUE.
You cannot use the /Set or the /Connection option to override single values that are also set by...
February 2, 2011 at 6:36 am
I think that the answer is FALSE, because the question asks
you CANNOT override a property from the command-line.
Then, the explanation says that
the command line always “wins”
, that means...
February 2, 2011 at 1:14 am
It's a good idea to repeat the QOTD until everybody answers correctly.:-D
January 31, 2011 at 1:08 am
Avoid beginners to update production table is the better way to avoid disaster!
In the author concept thers's a BIG BUG!
If before the trigger as described in the article another trigger...
January 27, 2011 at 1:28 am
Viewing 15 posts - 631 through 645 (of 812 total)