Forum Replies Created

Viewing 15 posts - 1,471 through 1,485 (of 19,560 total)

  • RE: Today's Random Word!

    snake

    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

    March 30, 2015 at 5:11 pm

    #1787522

  • RE: Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

    jellybean (3/30/2015)

    If I can summarise. You can upgrade from Sql Server 2005 SP4 to Sql Server 2014. However it changes the compatibility mode to that of SQL Server 2008 -...

    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

    March 30, 2015 at 4:57 pm

    #1787518

  • RE: Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

    Kris Gruttemeyer (3/30/2015)

    SQLRNNR (3/30/2015)

    The documentation poses an interesting conundrum for which I previously submitted connect items (MS closed saying they won't fix).

    If you try to change to compat 90 (sql...

    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

    March 30, 2015 at 11:19 am

    #1787438

  • RE: Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

    The documentation poses an interesting conundrum for which I previously submitted connect items (MS closed saying they won't fix).

    If you try to change to compat 90 (sql 2005) you will...

    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

    March 30, 2015 at 10:59 am

    #1787432

  • RE: sp_who3 does not show any active processes?

    Welsh Corgi (3/30/2015)

    Eirikur Eiriksson (3/29/2015)

    Welsh Corgi (3/28/2015)

    Lowell,

    I have googled and googled.

    I can't find one.

    Do you have a link to one that works?

    Thanks.

    First result I got was A Better sp_who2 using...

    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

    March 30, 2015 at 9:41 am

    #1787405

  • RE: Sql server 2005 --> 2014 upgrade. Risks/things to consider/etc...

    To get to 2014, you will need to upgrade to 2008 or R2 first.

    There is not a direct upgrade path to 2014 from 2005 (2005 compat mode is not even...

    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

    March 30, 2015 at 9:25 am

    #1787396

  • RE: split value into two columns

    What have you tried to do so far to make it work?

    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

    March 30, 2015 at 7:47 am

    #1787348

  • RE: CTE Syntax

    Eirikur Eiriksson (3/30/2015)

    ;With due respect, additional and extra semicolons between statements will not cause any problems and CTE statements will run, without the semicolon it will not.

    😎

    A CTE will run...

    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

    March 30, 2015 at 7:40 am

    #1787342

  • RE: CTE Syntax

    sipas (3/30/2015)

    Koen Verbeeck (3/30/2015)

    Such a bad habit to start a CTE with

    ;WITH

    I hate it 😀

    Nice question though, thanks Steve.

    +1 - maybe part of the answer should be promoting the correct...

    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

    March 30, 2015 at 7:37 am

    #1787341

  • RE: CTE Syntax

    GilaMonster (3/30/2015)

    Koen Verbeeck (3/30/2015)

    Such a bad habit to start a CTE with

    ;WITH

    I hate it 😀

    .This .It's a statement terminator .It has no place at the beginning of statements .I can't...

    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

    March 30, 2015 at 7:33 am

    #1787338

  • RE: Today's Random Word!

    fruition

    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

    March 27, 2015 at 3:44 pm

    #1787052

  • RE: Today's Random Word!

    Tandy

    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

    March 27, 2015 at 12:24 pm

    #1787014

  • RE: Are the posted questions getting worse?

    Did you guys hear about this awesome new feature in SQL Server called indexed views? It is so awesome that you can create 999 indexes on a view and...

    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

    March 27, 2015 at 11:37 am

    #1787007

  • RE: Are the posted questions getting worse?

    Luis Cazares (3/27/2015)

    In a different order of ideas, I want to share with you my happiness.

    Starting on April 21st I'll be working in the US. I'll make a stop at...

    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

    March 27, 2015 at 10:31 am

    #1786979

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (3/27/2015)

    Eirikur Eiriksson (3/27/2015)

    My Friday fun version:rolleyes:

    IF EXISTS (SELECT 1 FROM (VALUES(CAST(1 AS BIT))) d (n)) SELECT 1 FROM sys.all_columns X,sys.columns Y,sys.computed_columns Z

    AWESOME!!!!!!!

    Yes you can certainly get a red...

    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

    March 27, 2015 at 10:07 am

    #1786968

Viewing 15 posts - 1,471 through 1,485 (of 19,560 total)