Forum Replies Created

Viewing 15 posts - 11,221 through 11,235 (of 19,560 total)

  • RE: The Execute SQL Task

    Nice 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

    January 5, 2011 at 9:01 am

    #1269569

  • RE: Are the posted questions getting worse?

    Trey Staker (1/5/2011)

    They're doing some remodeling in our office and decided to get rid of a storage closet to make room for more offices. I was asked to make...

    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

    January 5, 2011 at 8:54 am

    #1269564

  • RE: Powershell Database Backup Script

    Nice article and interesting read. As an intro to powershell I can see the use for it. As Sean has stated though - I would rather the jobs...

    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

    January 5, 2011 at 8:53 am

    #1269562

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (1/5/2011)

    Koen (da-zero) (1/5/2011)

    Definately a PBCAC programming error.

    (problem between chair and computer)

    I've always heard of it as a PEBKAC error. "Problem exists between keyboard and chair."

    I had always just...

    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

    January 5, 2011 at 8:40 am

    #1269558

  • RE: Are the posted questions getting worse?

    Dave Ballantyne (1/5/2011)

    Brandie Tarvin (1/5/2011)

    Any programming language that complains when I try to use 0 as a divisor should be taken off the market and all its install disks buried...

    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

    January 5, 2011 at 8:38 am

    #1269557

  • RE: Today's Random Word!

    Contained

    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

    January 5, 2011 at 8:34 am

    #1269556

  • RE: Join Operations – Nested Loops

    Solomon Rutzky (1/4/2011)

    CirquedeSQLeil (1/4/2011)

    True it is a bit unfair to illustrate it that way (I alluded to that unfairness as well). An important part of that comparison is 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

    January 4, 2011 at 2:18 pm

    #1269211

  • RE: Join Operations – Nested Loops

    Solomon Rutzky (1/4/2011)

    Hey Jason. Nice article and one question. In your two main examples the difference is the WHERE condition that constrains the results to 10 rows as...

    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

    January 4, 2011 at 2:06 pm

    #1269203

  • RE: Goals

    Steve Jones - SSC Editor (1/4/2011)

    For those of you setting weight goals, I'd discourage that. I think you ought to work on your health, and trying to get to the...

    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

    January 4, 2011 at 11:55 am

    #1269151

  • RE: Goals

    Oh wow - I have a blog post coming and had not even given thought to adding the handyman chores to that goals list.

    Handyman chores:

    Finish basement (framed, plumbed, electrified 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

    January 4, 2011 at 11:23 am

    #1269131

  • RE: Join Operations – Nested Loops

    mtillman-921105 (1/4/2011)

    'Makes perfect sense Jason, thanks again.

    - Mark

    You're welcome.

    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

    January 4, 2011 at 10:27 am

    #1269109

  • RE: Join Operations – Nested Loops

    mtillman-921105 (1/4/2011)

    Well thought-out and illustrated Jason, thanks! 😎

    So should we always check queries returning just a few rows to see if a forced Nested Loop would help?

    I would...

    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

    January 4, 2011 at 10:11 am

    #1269097

  • RE: TRUNCATE in TRANSACTION

    I didn't like this question very much for the same reasons others have already noted. That said, I did learn a bit from it.

    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

    January 4, 2011 at 10:04 am

    #1269090

  • RE: Today's Random Word!

    Ray K (1/4/2011)

    WOTD: busy (you know I'm busy when I don't have time to post a WOTD!)

    Not too terribly busy then??:w00t:

    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

    January 4, 2011 at 9:10 am

    #1269049

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (1/4/2011)

    Brandie Tarvin (1/4/2011)

    Dave Ballantyne (1/4/2011)

    Brandie Tarvin (1/4/2011)

    And I found out I wasn't following Dave either. Silly me.

    Funnily enough , most people arent surprised to find out they are not...

    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

    January 4, 2011 at 9:08 am

    #1269047

Viewing 15 posts - 11,221 through 11,235 (of 19,560 total)