Forum Replies Created

Viewing 15 posts - 376 through 390 (of 821 total)

  • RE: Stored Procedure Boundaries

    February 25, 2014 at 1:05 am

    #1691773

  • RE: Stored Procedure Boundaries

    GO is NOT a statement, but a batch separator. It is recognized only by SSMS and you can change it. E.g. you can change with RUN_BABY.

    This statement confirms it:

    execute ('

    SELECT...

    February 25, 2014 at 12:57 am

    #1691772

  • RE: In Database We Trust

    Good question!

    Thanks!

    create database DEFAULT_DATABASE

    This runs!

    create database DELETE

    This DOESN'T run!

    You can use reserved words that stand for OPTIONS!

    February 20, 2014 at 1:18 am

    #1690560

  • RE: IDENTITY

    Thomas Abraham (2/19/2014)

    Good question. Thanks Igor.

    If you want numbers for your records in a SELECT, why not use:

    ROW_NUMBER ( ) OVER ( <partition_by_clause> <order_by_clause> )

    in...

    February 19, 2014 at 7:24 am

    #1690253

  • RE: IDENTITY

    SQLRNNR (2/19/2014)

    I wonder how many people have used identity in this way (select into...).

    Just one per year!

    😉

    February 19, 2014 at 1:25 am

    #1690169

  • RE: Valentines Day

    twin.devil (2/14/2014)

    now who said sql server does not have a heart 😛

    +1

    😛

    February 14, 2014 at 1:02 am

    #1688989

  • RE: Logic Precedence

    Do Humor questions take 7 points?

    Extremely easy.

    😀

    February 12, 2014 at 1:24 am

    #1688230

  • RE: Analysis Services Multidimensional

    I also found this doc from MSDN that explains the answer

    SSAS2005PerfGuide.doc

    February 2, 2014 at 12:03 pm

    #1685356

  • RE: Analysis Services Multidimensional

    Easy one!

    Thanks!

    🙂

    February 2, 2014 at 12:00 pm

    #1685355

  • RE: Compression

    It is too much easy and logical!

    😀

    January 30, 2014 at 1:09 am

    #1684543

  • RE: IDENTITY RESEED

    Koen Verbeeck (1/24/2014)

    Great question and a very nice explanation.

    +1

    January 24, 2014 at 1:55 am

    #1683024

  • RE: I No Longer Have Access to My DB and I'm a DBCreator!

    Andy Warren (1/22/2014)

    Comments posted to this topic are about the item <A HREF="/questions/Security/105935/">I No Longer Have Access to My DB and I'm a DBCreator!</A>

    Easy one! Thanks!

    😀

    January 23, 2014 at 2:13 am

    #1682658

  • RE: Tempdb

    Very easy one!!! ... after reading BOL!

    😀

    January 20, 2014 at 1:16 am

    #1681445

  • RE: Filtered Index vs Indexed View

    sneumersky (1/17/2014)

    That was a nice one--though I have never encountered a case where I would intentionally use a filtered index on a table that also has an indexed view on...

    January 17, 2014 at 9:50 am

    #1681145

  • RE: Filtered Index vs Indexed View

    Sean Pearce (1/17/2014)

    Hugo Kornelis (1/16/2014)

    Carlo Romagnano (1/16/2014)

    The focus of the question is "How are filtered indexes usefull?".

    My answer is "They are not so usefull as Indexed view".

    Isn't this like saying...

    January 17, 2014 at 6:09 am

    #1681037

Viewing 15 posts - 376 through 390 (of 821 total)