Forum Replies Created

Viewing 15 posts - 9,316 through 9,330 (of 19,560 total)

  • RE: group by/left outer join problem

    You have a ; before your group by. Thus you have nothing for the group by to work against.

    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

    July 25, 2011 at 12:53 pm

    #1358072

  • RE: sp_send_dbmail with dynamic body

    Please provide the code you are using to call your sp_send_dbmail proc?

    As Brandie explained, dynamic sql is one method to build a dynamic body. I typically do not go...

    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

    July 25, 2011 at 12:43 pm

    #1358068

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/25/2011)

    Ninja's_RGR'us (7/25/2011)

    Brandie Tarvin (7/25/2011)

    Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to...

    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

    July 25, 2011 at 12:38 pm

    #1358065

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/25/2011)

    Brandie Tarvin (7/25/2011)

    Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen to...

    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

    July 25, 2011 at 12:29 pm

    #1358059

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/25/2011)

    Brandie Tarvin (7/25/2011)

    Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen to...

    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

    July 25, 2011 at 12:11 pm

    #1358044

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (7/25/2011)

    Actually, it's not that post, Ninja. There was another one that I responded to in the first few posts and the guy didn't want to listen to me,...

    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

    July 25, 2011 at 12:05 pm

    #1358038

  • RE: Today's Random Word!

    crookj (7/25/2011)

    SQLRNNR (7/25/2011)

    FOG (horn)

    Foghorn Leghorn

    Yeah

    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

    July 25, 2011 at 12:04 pm

    #1358036

  • RE: Are the posted questions getting worse?

    Ninja's_RGR'us (7/25/2011)

    Steve Jones - SSC Editor (7/25/2011)

    Don't believe that I deleted that thread, or at least don't remember that.

    Ya but you closed it.

    It's Syed that wanted a MS link, so...

    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

    July 25, 2011 at 12:02 pm

    #1358035

  • RE: Are the posted questions getting worse?

    GilaMonster (7/25/2011)

    mtillman-921105 (7/25/2011)

    Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic 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

    July 25, 2011 at 11:44 am

    #1358016

  • RE: Are the posted questions getting worse?

    Gianluca Sartori (7/25/2011)

    Brandie Tarvin (7/25/2011)

    mtillman-921105 (7/25/2011)

    Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like...

    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

    July 25, 2011 at 11:42 am

    #1358013

  • RE: Are the posted questions getting worse?

    GilaMonster (7/25/2011)

    Brandie Tarvin (7/25/2011)

    mtillman-921105 (7/25/2011)

    Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand...

    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

    July 25, 2011 at 11:41 am

    #1358011

  • RE: Are the posted questions getting worse?

    mtillman-921105 (7/25/2011)

    Too many of these posters don't realize the level of expertise that they are getting here. Maybe you all need more intimidating titles like "Grand Intergalactic SQL Master"...

    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

    July 25, 2011 at 11:40 am

    #1358008

  • RE: Are the posted questions getting worse?

    GilaMonster (7/25/2011)

    I just had a fun one. Told someone that they shouldn't run Backup log with truncate only as it breaks the log chain. So they reference an article that...

    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

    July 25, 2011 at 11:38 am

    #1358005

  • RE: What's a safe backup?

    Gianluca Sartori (7/25/2011)

    Ninja's_RGR'us (7/25/2011)

    Gianluca Sartori (7/25/2011)

    Ninja's_RGR'us (7/25/2011)

    There's just no reason to shutdown the server to take a backup.

    ... unless you're working with Oracle. :Whistling:

    It's called "cold backup" and it's advertised...

    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

    July 25, 2011 at 11:19 am

    #1358002

  • RE: Today's Random Word!

    FOG (horn)

    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

    July 25, 2011 at 11:12 am

    #1357994

Viewing 15 posts - 9,316 through 9,330 (of 19,560 total)