Forum Replies Created

Viewing 15 posts - 15,496 through 15,510 (of 19,560 total)

  • RE: The Missing Certification

    Lynn Pettis (4/2/2010)

    WayneS (4/2/2010)

    Grant Fritchey (4/2/2010)

    I think the time in service, as part of the bridge between MCTIP and MCM, actually adds unnecessary overhead that is simply going to be...

    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

    April 2, 2010 at 10:24 am

    #1144917

  • RE: The Missing Certification

    Grant Fritchey (4/2/2010)

    I think the time in service, as part of the bridge between MCTIP and MCM, actually adds unecessary overhead that is simply going to be gamed anyway. I'm...

    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

    April 2, 2010 at 10:21 am

    #1144915

  • RE: The Missing Certification

    Grant Fritchey (4/2/2010)

    That's the problem with bringing titles and time in rate to the equation. One of the best DBA's I know isn't a DBA, she's a developer; Gail Shaw....

    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

    April 2, 2010 at 9:55 am

    #1144903

  • RE: Creating Indices on Temp Tables from Stored Procedures

    kramaswamy (4/2/2010)

    Oh don't get me wrong - I'm far from complaining. I just wanted to clarify my situation, and perhaps add somewhat to the discussion.

    Sometimes I read comments on these...

    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

    April 2, 2010 at 9:50 am

    #1144899

  • RE: The Missing Certification

    WayneS (4/1/2010)

    Lynn Pettis (4/1/2010)

    I'm thinking more about the interaction between them in a BI environment. As you gain experience, you are going to find yourself working more closely with...

    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

    April 2, 2010 at 9:48 am

    #1144893

  • RE: The Missing Certification

    Lynn Pettis (4/1/2010)

    CirquedeSQLeil (4/1/2010)

    Lynn Pettis (4/1/2010)

    CirquedeSQLeil (4/1/2010)

    Correct. As a SQL Server Database professional. It shouldn't matter that you are a developer, BI Specialist, or Admin. Working with...

    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

    April 2, 2010 at 9:46 am

    #1144888

  • RE: Today's Random Word!

    crookj (4/2/2010)

    dbowlin (4/2/2010)

    Here comes the sun!

    I am the Walrus

    Joe

    Goo goo ga joob.

    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

    April 2, 2010 at 9:39 am

    #1144877

  • RE: Today's Random Word!

    Lynn Pettis (4/2/2010)

    dbowlin (4/2/2010)

    Here comes the sun!

    With a chance of rain or snow this afternoon.

    We were supposed to get rain - and as usual didn'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

    April 2, 2010 at 9:37 am

    #1144874

  • RE: Today's Random Word!

    Paul White NZ (4/2/2010)

    Bob

    Square

    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

    April 2, 2010 at 9:37 am

    #1144871

  • RE: Transcender Training Materials Adequate? (70-448)

    You're welcome.

    Looking forward to the feedback.

    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

    April 2, 2010 at 9:36 am

    #1144868

  • RE: Are the posted questions getting worse?

    Steve Jones - Editor (4/2/2010)

    I think the statement that table variables don't participate in transactions is clearer. It implies that they can be exempt from a rollback, which is handy....

    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

    April 2, 2010 at 8:37 am

    #1144800

  • RE: Foreign key constraints...WHY??

    PaulB-TheOneAndOnly (4/2/2010)

    in short, hire a senior DBA with proven experience in data modeling and physical implementation 🙂

    Superb Idea

    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

    April 2, 2010 at 8:32 am

    #1144794

  • RE: Creating Indices on Temp Tables from Stored Procedures

    Gianluca Sartori (4/2/2010)

    TheSQLGuru (3/26/2010)

    Will you be iteratively (and by iteratively I mean 5+ perhaps) hitting the temp table?

    I have found in some cases that taking off a copy 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

    April 2, 2010 at 8:31 am

    #1144793

  • RE: SQL side by side install - but not completely

    Paul White NZ (4/2/2010)

    CirquedeSQLeil (4/1/2010)

    Often times the database will be fine on a SQL 2005 box while running under 2000 compatibility. Testing is necessary though.

    Yes. Compatibility levels are...

    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

    April 2, 2010 at 8:23 am

    #1144781

  • RE: SP says it's exceeded nesting level when there is no nesting involved!

    Paul White NZ (4/2/2010)

    chrismat (4/1/2010)[hrApparently the entire query window becomes the SP and doesn't stop at the END; statement at the end of the CREATE PROCEDURE... I didn't realize...

    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

    April 2, 2010 at 8:21 am

    #1144780

Viewing 15 posts - 15,496 through 15,510 (of 19,560 total)