Forum Replies Created

Viewing 15 posts - 1 through 15 (of 93 total)

  • Reply To: sp_who4

    I get the same error as bteague

    February 4, 2021 at 2:27 pm

    #3840979

  • RE: Problems with partitioned views

    TomThomson (1/16/2015)

    Andre Ranieri (1/16/2015)

    Thanks for the great question - I learned something here.

    Wouldn't this solution involve droppping and re creating the check constraint ever day to maintain workability?

    Andre Ranieri

    No. ...

    May 29, 2015 at 10:00 am

    #1801641

  • RE: How to find the needle in the haystack

    Is it possible that the database or log file was growing at the time?

    April 8, 2015 at 3:23 pm

    #1789715

  • RE: Cardinality Regression

    I just tested this on my 2014 server and this is what I observed

    Running a query with trace flag 2312 will use version 120 (the new version) of the cardinality...

    June 11, 2014 at 8:40 am

    #1720772

  • RE: Cardinality Regression

    Please update this QOTD

    The documentation now states.

    you can run the query with trace flag 2312 to use version 120 (the new version) of the cardinality estimator

    June 4, 2014 at 7:28 am

    #1718820

  • RE: COUNT, COALESCE, ISNULL, DISTINCT

    L' Eomot Inversé (11/7/2013)

    Point 5 in the explanation, although it is a direct quotation from BOL, is actually incorrect: the definition of @@rowcount is a bit more complicated that that,...

    November 7, 2013 at 10:30 am

    #1664864

  • RE: Declare Variable

    The scope of a variable is the range of Transact-SQL statements that can reference the variable. The scope of a variable lasts from the point it is declared until the...

    September 16, 2013 at 8:57 am

    #1650488

  • RE: Return

    Rune Bivrin (8/19/2013)

    Got it. But to be precise there won't even be a result set. Not even one with zero rows.

    Thought I would see more comments like this. This can...

    August 19, 2013 at 9:53 am

    #1642744

  • RE: How can I get the dates I need?

    I think you might be looking for the DATEDIFF function

    http://msdn.microsoft.com/en-us/library/ms189794.aspx

    May 10, 2013 at 4:32 pm

    #1614345

  • RE: FK to IDENTITY

    Great question thanks

    April 24, 2013 at 2:19 pm

    #1609719

  • RE: TRY...CATCH

    Hugo Kornelis (4/2/2013)

    Good question, but the explanation falls a bit short. I was very disappointed when I first saw this behaviour. A semicolon is a statement terminator and should be...

    April 2, 2013 at 8:54 am

    #1602840

  • RE: CASCADE - 2

    L' Eomot Inversé (3/26/2013)

    kevin.l.williams (3/26/2013)

    L' Eomot Inversé (3/26/2013)

    And intensly I dislike the horrible violation of 1NF - code examples like this risk teaching really awful habits to inexperienced people who...

    March 26, 2013 at 8:26 am

    #1600832

  • RE: CASCADE - 2

    L' Eomot Inversé (3/26/2013)

    And intensly I dislike the horrible violation of 1NF - code examples like this risk teaching really awful habits to inexperienced people who see them.

    I'm very embarrassed...

    March 26, 2013 at 7:26 am

    #1600781

  • RE: INNER JOIN

    kapil_kk (3/12/2013)

    Hi all,

    Actually I read an article with a name Difference between Datetime and Datetime2 and surprised with the functioning of that so then I think of implementing that...

    March 12, 2013 at 8:53 am

    #1596062

  • RE: Five percent rounded down

    mhtanner (10/24/2012)

    Some have commented that @Quota should be not an integer, but this doesn't make sense when my answer is to be an integer.

    I think you may get an argument...

    October 24, 2012 at 9:17 am

    #1552325

Viewing 15 posts - 1 through 15 (of 93 total)