Forum Replies Created

Viewing 15 posts - 5,491 through 5,505 (of 19,560 total)

  • RE: Upgrade from 2005 to 2008

    SQLCrazyCertified (12/6/2012)

    jerry-621596 (12/6/2012)

    Don't use that option. Restore with recovery so that SQL 2008 can run the various stored procedures that upgrade the database structure to the new format.

    Then change...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 6, 2012 at 6:39 pm

    #1566412

  • RE: what ports SQL uses

    Is it a default instance or is it a named instance?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 6, 2012 at 6:36 pm

    #1566410

  • RE: Aggregates

    Hugo Kornelis (12/6/2012)

    I picked the right answer, but only after thinking about it for a long time - go with Books Online, or go with common sense. So I am...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 6, 2012 at 2:04 pm

    #1566347

  • RE: SET Options - 2

    Thanks Ron.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 4, 2012 at 7:24 pm

    #1565553

  • RE: SQL

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 3, 2012 at 1:47 pm

    #1565036

  • RE: LIKE a vowel

    Excellent Question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    December 3, 2012 at 1:46 pm

    #1565033

  • RE: Queries

    Thanks for the question

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 30, 2012 at 4:56 pm

    #1564609

  • RE: SEQUENCE

    Thanks - good question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 30, 2012 at 4:52 pm

    #1564607

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (11/28/2012)

    At a SQL Server conference I was speaking at two weeks ago, I met one of the co-founders of lessthandot.com/[/url]. Later that day he asked me if I...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 28, 2012 at 8:41 pm

    #1563546

  • RE: Today's Random Word!

    Punch

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 28, 2012 at 10:05 am

    #1563294

  • RE: Datetime Default

    Koen Verbeeck (11/26/2012)

    Nice question. The explanation could be a bit more clear.

    It's not the default from the default expression GETDATE(), but the default value that is chosen when 0 or...

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 27, 2012 at 12:34 pm

    #1562827

  • RE: Thanksgiving 2012

    Happy Thanksgiving

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 21, 2012 at 11:51 pm

    #1561496

  • RE: Are the posted questions getting worse?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 21, 2012 at 3:41 pm

    #1561425

  • RE: File Tables

    Thanks for the question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 21, 2012 at 10:28 am

    #1561319

  • RE: Isolation Levels

    Good question - thanks

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

    November 21, 2012 at 10:25 am

    #1561316

Viewing 15 posts - 5,491 through 5,505 (of 19,560 total)