Viewing 15 posts - 646 through 660 (of 827 total)
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 - 646 through 660 (of 827 total)