Forum Replies Created

Viewing 15 posts - 406 through 420 (of 825 total)

  • RE: Order My Data

    Koen Verbeeck (12/2/2013)

    Evgeny (12/1/2013)

    What is wrong with this answer?

    CREATE NONCLUSTERED INDEX IDX_A ON #temp1(a)

    +1

    Why is this answer "incorrect"?

    Flawed question today, better luck next time 🙂

    It's wrong because the optimizer...

    December 2, 2013 at 12:55 am

    #1670014

  • RE: Order My Data

    steve.jacobs (11/30/2013)

    Comments posted to this topic are about the item <A HREF="/questions/T-SQL/104494/">Order My Data</A>

    OhiOhiOhi.

    The only right answer is add a "order by clause" to the select statement.

    Without the order by...

    December 1, 2013 at 3:35 pm

    #1669961

  • RE: SQL Server 2014 Configuration

    Koen Verbeeck (11/18/2013)

    Please read the entire MSDN page you linked to.

    The following SQL Server Database Engine features are supported in the next version of SQL Server, but will be removed...

    November 19, 2013 at 2:04 am

    #1667318

  • RE: Computed columns Data Types

    Optimum!

    November 15, 2013 at 2:22 am

    #1666652

  • RE: REGEX

    That's true:

    In SQL Server, regular expressions really are poor.

    😎

    November 14, 2013 at 12:56 am

    #1666278

  • RE: Data Compression

    Koen Verbeeck (11/13/2013)

    First of all, this question is way too easy. Enterprise has all the features, so you don't even have to think.

    Secondly, developer is the same as enterprise feature-wise,...

    November 13, 2013 at 1:27 am

    #1665942

  • RE: Analytical functions available in SQL 2005

    Bah!

    November 10, 2013 at 12:04 pm

    #1665345

  • RE: Using Max()

    I couldn't believe!

    I never expected this kind of question!

    It is the same as:

    any number multiplied by 0 returns ZERO,

    so, you assume that any number added to zero should return ZERO!

    :w00t:

    November 8, 2013 at 1:06 am

    #1665010

  • RE: COUNT, COALESCE, ISNULL, DISTINCT

    murray-906152 (11/6/2013)

    Steve,

    you state 'NOTE: You will notice that James was case insenstive (COLLATE SQL_Latin1_General_CP1_CI_AS )' in your answer but this is very much site specific.

    (I answered on the basis that...

    November 7, 2013 at 12:50 am

    #1664649

  • RE: Compressing Filestream

    It is recommended that you set the clusters to 4kb.

    Thanks! 🙂

    November 6, 2013 at 3:05 am

    #1664364

  • RE: 9002 ERROR

    What's DOA?

    October 29, 2013 at 2:03 am

    #1662227

  • RE: Date Functions

    Till now "Ask a co-worker?" is 0%.

    I am really surprised!

    😛

    October 24, 2013 at 12:59 am

    #1661155

  • RE: Slowly Changing Dimension Transformations

    Good work! 🙂

    October 22, 2013 at 12:55 am

    #1660378

  • RE: Space missing in SELECT statement

    Good tricky question!

    😀

    October 21, 2013 at 1:26 am

    #1660041

  • RE: Parameter sniffing

    palotaiarpad (10/17/2013)

    Is it a useful knowledge?

    Yes, it is.

    Sometimes, store procs run slow because of parameters sniffing and obsolete query plan.

    If you recompile, store procs may run better.

    October 17, 2013 at 1:32 am

    #1659142

Viewing 15 posts - 406 through 420 (of 825 total)