Viewing 15 posts - 3,871 through 3,885 (of 7,484 total)
Sean Pearce (12/28/2012)
gkganeshbe (12/26/2012)
How to deallocate the unused pages?
As mentioned in the reference URL you can either use the TABLOCK hint, use TRUNCATE TABLE or create a clustered...
December 28, 2012 at 8:04 am
A very good question.
Personally I would avoid writing a condition on one of the joined table expressions in the ON clause, but instead write it as an explicit...
December 27, 2012 at 10:09 am
Jeff Moden (12/26/2012)
[font="Arial Black"]SNOW[/font]!
Horror!!!!!
SNOW ??
Today was very cold: max temperature (about 2 pm) was 26.2C.
December 26, 2012 at 7:00 pm
Hugo Kornelis (12/26/2012)
Sean Lange (12/26/2012)
Hugo Kornelis (12/26/2012)
Thanks for a good question, Sean. I think I once read or heard that after deleting...
December 26, 2012 at 6:41 pm
Lynn Pettis (12/22/2012)
Constantly amazed by the number of people who think that full backups truncate the transaction log. Where do they get such ideas?
That's a clear sign that you...
December 23, 2012 at 6:40 am
Hugo Kornelis (12/23/2012)
CASE
WHEN x <> 0 THEN y...
December 23, 2012 at 6:33 am
Good question.
But the explanation, as it refers to nullif and to view5, is a bit of a mess - it appears to say that view5 will always return null, instead...
December 22, 2012 at 8:29 pm
Nice easy one.
The third query is clearly going to give an error, and that eliminates all but two of the options, so it boils down to whether select count(x) from...
December 22, 2012 at 2:11 pm
SQLRNNR (12/20/2012)
Anybody else not receiving the topic notifications from SSC?I have not received any since early this morning (1am-ish).
Last notification I got about thread messages was between 17 and 18...
December 20, 2012 at 5:55 pm
jasona.work (12/20/2012)
Well, unless the Mayans went by Eastern Standard Time (GMT-5 or so) the world hasn't ended...After all, right now it's tomorrow in Australia / Japan / China...
😎
If I remember...
December 20, 2012 at 5:44 pm
Narud (12/20/2012)
Good question, poor title.
The question is explicitly about constraints:
Is it possible to create a table with unique constraint ....
and the title is too. So why is the...
December 20, 2012 at 5:12 pm
George M Parker (12/20/2012)
"Also, unlike PRIMARY KEY constraints, UNIQUE constraints allow for the value NULL. However, as with any value participating in...
December 20, 2012 at 5:02 pm
dawryn (12/20/2012)
BTW found this request for unique constraint ANSI compliance regarding multiple null values
I greatly wish that a large number of people would pile in and downvote that awful connect...
December 20, 2012 at 8:43 am
Pretty poor QotD today.
The explanation is complete rubbish - nothing at all to do with unique constraints.
The answer is nevertheless correct, as Jason already pointed out so I...
December 20, 2012 at 8:16 am
Derek Dongray (12/19/2012)
(Bob Brown) (12/19/2012)
December 19, 2012 at 11:07 am
Viewing 15 posts - 3,871 through 3,885 (of 7,484 total)