Forum Replies Created

Viewing 15 posts - 11,371 through 11,385 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    Brandie Tarvin (12/16/2010)

    Steve Jones - SSC Editor (12/16/2010)

    I think Intellisense can make this just as bad. If you're used to using "p", downarrow to get to ProductDetail and someone adds...

    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

    December 16, 2010 at 11:20 am

    #1263616

  • RE: Nested Temporary Tables

    WayneS (12/16/2010)

    Okay, I messed up. I posted the wrong code (the posted code was run to get the error message for the QotD). Then I went and gave the explanation...

    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

    December 16, 2010 at 11:17 am

    #1263613

  • RE: Hyper-V Guests

    If you say that a product is supported or supports platform x, y, or z - you should have trained staff that can at least provide a certain level of...

    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

    December 16, 2010 at 10:45 am

    #1263582

  • RE: Nested Temporary Tables

    Thanks for the question. I learned from this 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

    December 16, 2010 at 9:44 am

    #1263549

  • RE: Nested Temporary Tables

    Paul Peeters (12/16/2010)

    The real error that is displayed is "Incorrect syntax" because there is a non-matching closing parenthesis in the select statement in dbo.Proc1 😛

    Look more closely. 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

    December 16, 2010 at 8:22 am

    #1263491

  • RE: Cursor vs. set based procedure

    Dave Ballantyne (12/16/2010)

    KennethParker (12/16/2010)

    So, in the end I'd have something like this?

    Select * from

    <YourSourceTable> Cross apply dbo.CalcField_1(param1,param2,param3,...)

    Cross apply dbo.CalcField_2(param1,param2,param3,...)

    ...

    Cross apply dbo.CalcField_20(param1,param2,param3,...)

    It looks pretty messy and uninviting, I must admit:(

    What...

    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

    December 16, 2010 at 8:06 am

    #1263474

  • RE: Slight Problem :(

    skcadavre (12/16/2010)

    Backups used to be made regularly, but due to disk space it was turned off (not by me).

    In the end, the tape disk was there, so I was able...

    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

    December 16, 2010 at 7:59 am

    #1263472

  • RE: SELECT All Columns from a table - without re-engineering if table stucture changes

    ASDL (12/15/2010)

    Thanks all! This was a good discussion.

    My options are Method 2 and Method 3, I'll choose #3 (SELECT * query) because it is simple and AFAIK I would get...

    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

    December 15, 2010 at 9:20 pm

    #1263281

  • RE: Are the posted questions getting worse?

    WayneS (12/15/2010)

    My second ever QotD is being published tomorrow. Can you'll let me know what you think of it please?

    Far too easy

    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

    December 15, 2010 at 8:22 pm

    #1263266

  • RE: Are the posted questions getting worse?

    The Dixie Flatline (12/15/2010)

    You tell 'em, Steve !!!

    I wander in here for the first time in a month and get bombarded with utterly useful technical information.

    Now...

    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

    December 15, 2010 at 6:16 pm

    #1263247

  • RE: Are the posted questions getting worse?

    LutzM (12/15/2010)

    Regarding the money data type:

    Here's an interesting example I just found here

    -- code removed (too much technical stuff in THE THREAD)

    Another interesting article can be found here at SSC

    HAHAHAHA

    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

    December 15, 2010 at 6:14 pm

    #1263246

  • RE: Back up restoration problem

    Duplicate post

    Please post answers here:

    http://www.sqlservercentral.com/Forums/Topic1035554-1550-1.aspx

    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

    December 15, 2010 at 4:51 pm

    #1263232

  • RE: Back up restore problem

    Duplicate post

    Please post answers here:

    http://www.sqlservercentral.com/Forums/Topic1035554-1550-1.aspx

    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

    December 15, 2010 at 4:50 pm

    #1263231

  • RE: Passed 70-432 Yesterday

    Congrats

    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

    December 15, 2010 at 4:48 pm

    #1263230

  • RE: Problem with restore.

    Duplicate post

    Please refer answers to:

    http://www.sqlservercentral.com/Forums/Topic1035554-1550-1.aspx

    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

    December 15, 2010 at 4:47 pm

    #1263228

Viewing 15 posts - 11,371 through 11,385 (of 19,560 total)