Forum Replies Created

Viewing 15 posts - 211 through 225 (of 455 total)

  • RE: Ghost Cleanup

    Sean Lange (1/15/2013)

    Great question Wayne. I knew the page would not be deallocated but I didn't know all of the details. The article was very interesting and informative read.

    I wonder...

    January 15, 2013 at 9:48 am

    #1577406

  • RE: Finding New Years Eve

    nigel. (1/4/2013)

    Thanks Steve for the question.

    Thought I'd throw this in just for fun. Should work for every day of the year:

    SELECT DATEADD(DAY, -DATEPART(dayofyear,GETDATE()),GETDATE())

    The only problem with that is, since getdate()...

    January 4, 2013 at 11:32 am

    #1573887

  • RE: Single Quotation Marks in SQL

    Steven Willis (1/4/2013)

    For anyone who really cares about proper typography The Chicago Manual of Style is the editor's Bible.

     

    Oh. I thought the Chicago Manual of Style was about pinstripes and...

    January 4, 2013 at 10:20 am

    #1573852

  • RE: Single Quotation Marks in SQL

    roger.plowman (1/3/2013)

    This issue is yet another example of why SQL is one of the worst-designed languages of all time from a syntactic POV.

    Would it have killed the designers to create...

    January 3, 2013 at 8:58 am

    #1573367

  • RE: Finding New Years Eve

    L' Eomot Inversé (1/1/2013)

    That's quite a mess, isn't it!

    The only correct answer is "none of the above", for two reasons:

    1) none of the select statements is syntactically valid.

    2) even when...

    January 1, 2013 at 8:40 am

    #1572694

  • RE: UNIQUE constraint

    L' Eomot Inversé (12/20/2012)

    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...

    December 20, 2012 at 8:56 am

    #1570588

  • RE: UNIQUE constraint

    Yggaz (12/19/2012)

    The problem lies in the words "unique constraint". It has at least TWO meanings: "something that does not allow duplicates" and "SQL Server object implemented via unique index".

    This is...

    December 20, 2012 at 8:39 am

    #1570580

  • RE: STUFF - 2

    Toreador (12/10/2012)

    DavidBridgeTechnology.com (12/10/2012)

    SELECT STUFF('123456', 1,3,NULL) -- "456" - SQL has found the first character, removed it and two next to it (3 in total) and inserted nothing into the...

    December 10, 2012 at 8:26 am

    #1567066

  • RE: STUFF - 2

    Toreador (12/10/2012)

    The explanation is fine for the second example.

    But there's no mention of why a NULL value for 'replace with' returns a non-null result.

    This confused me when I first came...

    December 10, 2012 at 7:53 am

    #1567053

  • RE: Which Statement will execute sucessfully

    I knew this question would generate some discussion as soon as I read "Suppose I have two schemas: "

    For reference, a database created with default options in SQL Server 2008R2...

    December 7, 2012 at 6:49 am

    #1566596

  • RE: Aggregates

    Hugo Kornelis (12/6/2012)

    I picked the right answer, but only after thinking about it for a long time - go with Books Online, or go with common sense. So I am...

    December 6, 2012 at 7:00 am

    #1566152

  • RE: Tip: Resetting Identity Fields

    So you've essentially saved having to declare and set a value in a variable. But to do so, you've had to run an extra DBCC command.

    It would be interesting to...

    December 2, 2012 at 9:35 pm

    #1564728

  • RE: Queries

    No, this question was not useless.

    As many have said, the answer given was incorrect, but the value of this question lies in why the answer given was given, and why...

    November 28, 2012 at 7:37 am

    #1563152

  • RE: COALESCE - 2

    L' Eomot Inversé (11/12/2012)

    sknox (11/10/2012)

    If you think of it that way, you'll see why a NULL in a column or variable can (must) have a type associated with it, while...

    November 13, 2012 at 7:26 am

    #1558484

  • RE: COALESCE - 2

    Mike Dougherty-384281 (11/9/2012)

    I feel like the concept of a "typed null" is wrong. I'd say type is a property (metadata) of a variable rather than the value itself.

    Type isn't...

    November 10, 2012 at 9:47 am

    #1557915

Viewing 15 posts - 211 through 225 (of 455 total)