Forum Replies Created

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

  • RE: Filtered Index vs Indexed View

    jchu 39760 (1/15/2014)

    Could you please explain more details about the pass of query 4 and the fail of query 6?

    The error 8622 is raised when you are searching a value...

    January 15, 2014 at 3:50 am

    #1680175

  • RE: Dropping indexes

    PRR.DB (1/1/2014)

    Good Question..

    +1

    🙂

    January 2, 2014 at 3:33 am

    #1676822

  • RE: New Year's Eve

    sqlnaive (12/30/2013)

    Easy QOTD to end the year on good note.

    Thanks Steve and all for making the year wonderful and interactive with QOTD efforts. And a wish you a wonderful...

    December 31, 2013 at 9:22 am

    #1676615

  • RE: predict the output

    I remembered the double behaviour!

    😀

    December 26, 2013 at 6:54 am

    #1675944

  • RE: Replicating Data with Mobile Clients - SQL Server 2012

    Hany Helmy (12/17/2013)

    Nice & easy question, can be simply answered by just excluding the non-logic answers.

    ... or including the only possible!

    😀

    +1

    December 18, 2013 at 1:35 am

    #1674305

  • RE: Central Management Servers

    Good! I will try!

    😀

    December 12, 2013 at 12:29 am

    #1672842

  • 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= 'A'

    ,@b 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

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