Forum Replies Created

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

  • Reply To: Query Optimizer Suggests Wrong Index and Query Plan -- Why?

    I also think that the (main) issue is that the order of the columns in the proposed index,is based on the order of the columns in the table. Find a...

  • Reply To: Backing up a File for an offline filegroup

    Based on the following sentence on the page used as reference for the explanation, I would expect that the backup fails.

    Note that if any file in a filegroup is offline...

  • Reply To: Minus Query

    The order by is not allowed for an EXCEPT, and neither allowed for a UNION.

  • RE: Just the ranks

    I think the answer or in fact, the explanation is incorrect and/or incomplete.
    My assumption is that the the numbers between the brackets are first "calculated", and then the following...

  • RE: NULL Tests

    Same for me for selection the "wrong" right option.

    But probably none of the answers is right, or it should have been a combination of options. The thing is...

  • RE: Restore options

    Carlo Romagnano - Monday, June 25, 2018 4:45 AM

    From BOL:

    To enable backup checksums in a BACKUP statement, specify the...

  • RE: Mutable Objects

    IRL11 - Wednesday, April 25, 2018 3:20 AM

    the available answers to the question are incorrect as you are printing J who's value...

  • RE: Python division

    Louis Hillebrand - Wednesday, March 14, 2018 1:13 AM

    If I read this  this article 

    March 14, 2018 at 2:15 am


  • RE: JSON performance

    t.ovod-everett - Monday, February 26, 2018 11:00 AM

    I think the assertion that "standard indexes" will improve JSON performance is misleading.  That is...

  • RE: Basic COUNTs 3

    More of a trick question than a basic count question.

  • RE: Indexes for Memory-Optimized Tables

    Maybe something worth noting: starting from SQL Server 2017, there is not limit anymore on the number of indexes that can be created.

  • RE: Interesting Datenames

    Ed Wagner - Wednesday, November 15, 2017 9:22 AM

    Agreed.  All the country-specific formats are just that - formats.  The YYYY-MM-DD is...

  • RE: Interesting Datenames

    NBSteve - Tuesday, November 14, 2017 10:21 AM

    It feels inconsistent because it isn't quite accurate.  SET LANGUAGE doesn't change the value...

  • RE: Interesting Datenames

    Something that might not be clear is that only the date format is not changed until the end of the batch. What the DATENAME returns is directly affected.

  • RE: More Precedence

    ThomasRushton - Tuesday, November 7, 2017 4:21 AM

    Mighty - Tuesday, November 7, 2017 1:47 AM

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