Forum Replies Created

Viewing 15 posts - 391 through 405 (of 812 total)

  • RE: Hekaton

    Mr. Kapsicum (12/5/2013)

    this is one feature that i am eagerly waiting,,, wanna try my hand out on this.

    😎

    +1

    December 6, 2013 at 5:48 am

    #1671477

  • RE: Declare @local variable

    Starting from sqlserver2008, you can declare and set a variable in one statement,

    but you can NOT initialize a second variable with another inside the same declaration.

    declare @a varchar=...

    December 5, 2013 at 7:31 am

    #1671094

  • RE: Filegroup for indexes

    Pawel Borkowski (12/3/2013)

    According to the explanation - I think that 3rd query shall be about table, not about index:

    WHERE i.name = 'Tab1'

    No, it returns the filegroup for the index.

    December 3, 2013 at 6:30 am

    #1670365

  • 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

Viewing 15 posts - 391 through 405 (of 812 total)