Forum Replies Created

Viewing 15 posts - 18,331 through 18,345 (of 19,560 total)

  • RE: Today's Random Word!

    Extraction

    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 7, 2010 at 9:21 am

    #1100305

  • RE: Today's Random Word!

    Still warm here 😀

    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 7, 2010 at 9:21 am

    #1100304

  • RE: T-SQL

    Steve Jones - Editor (1/7/2010)

    I see both sides in this argument. BOL is inconsistent and I have added feedback to that note to various links to have this clarified 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

    January 7, 2010 at 9:19 am

    #1100301

  • RE: T-SQL

    Ok, my turn now. I answered operator as well and got it wrong. Being the first one to respond to the thread - I didn't want to beat...

    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 7, 2010 at 9:14 am

    #1100293

  • RE: TSQL SELECT and TABLOCK

    Jeff Moden (1/6/2010)

    I have to admit, Jason... you've confused even me on this one 😛 The query runs in about 13 ms according to the op... how 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

    January 6, 2010 at 11:49 pm

    #1100035

  • RE: T-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

    January 6, 2010 at 11:09 pm

    #1100020

  • RE: Today's Random Word!

    Ha, we had warm temps here, sunny and no wind.

    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 6, 2010 at 9:24 pm

    #1100007

  • RE: Talking baseball

    Steve Jones - Editor (1/6/2010)

    Alomar doesn't get in. Not sure that makes sense. I dislike a little that we somehow decide the HOF after a few years. If you don'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

    January 6, 2010 at 9:22 pm

    #1100006

  • RE: TSQL SELECT and TABLOCK

    striking this comment - tired eyes turned ms into Mins

    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 6, 2010 at 9:20 pm

    #1100005

  • RE: Cursor Not Working As Expected

    Jeff Moden has written some good articles here at SSC about triangular joins, set based method, and RBAR. I think those articles would be better able to fully explain...

    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 6, 2010 at 9:12 pm

    #1100004

  • RE: Women in Technology

    Antares686 (1/6/2010)

    nasoto (1/6/2010)

    In my last position I made 55% of the male developers' salary (and so did the 1 other woman out of 16 men). Currently I'm at about...

    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 6, 2010 at 9:08 pm

    #1100003

  • RE: Cursor Not Working As Expected

    donne4real (1/6/2010)

    Here is my code but for some reason, it seems not to be working correctly. It is not going through the loop as expected and will appreciate it if...

    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 6, 2010 at 12:05 pm

    #1099842

  • RE: Women in Technology

    Dave-148053 (1/6/2010)

    jen-1118637 (1/6/2010)

    First, a non-IT example: I worked at Wendy's for two years in high school. My favorite station was grill, but they consistently gave it to whatever guy...

    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 6, 2010 at 11:59 am

    #1099838

  • RE: TSQL SELECT and TABLOCK

    Some questions and a suggestion

    Suggestion: Remove the subqueries and turn them into their own views.

    Question: How long are your queries taking?

    Question: Why do you want to prevent...

    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 6, 2010 at 11:57 am

    #1099835

  • RE: Transaction log in one or several tables

    Could you please clarify what it is you are looking to accomplish?

    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 6, 2010 at 11:51 am

    #1099825

Viewing 15 posts - 18,331 through 18,345 (of 19,560 total)