Forum Replies Created

Viewing 15 posts - 11,656 through 11,670 (of 19,560 total)

  • RE: Are the posted questions getting worse?

    GilaMonster (11/23/2010)

    CirquedeSQLeil (11/23/2010)

    GilaMonster (11/23/2010)

    CirquedeSQLeil (11/23/2010)

    If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what is 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

    November 23, 2010 at 11:04 am

    #1254618

  • RE: Are the posted questions getting worse?

    Alvin Ramard (11/23/2010)

    CirquedeSQLeil (11/23/2010)

    GilaMonster (11/23/2010)

    CirquedeSQLeil (11/23/2010)

    If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what is...

    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

    November 23, 2010 at 11:02 am

    #1254617

  • RE: Are the posted questions getting worse?

    Craig Farrell (11/23/2010)

    CirquedeSQLeil (11/23/2010)

    Topic changer:

    I want to bring up the age old question related to books.

    If you were to buy a SQL book, what would you buy? If there...

    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

    November 23, 2010 at 10:46 am

    #1254606

  • RE: Are the posted questions getting worse?

    GilaMonster (11/23/2010)

    CirquedeSQLeil (11/23/2010)

    If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what is it? Is...

    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

    November 23, 2010 at 10:45 am

    #1254603

  • RE: Are the posted questions getting worse?

    Topic changer:

    I want to bring up the age old question related to books.

    If you were to buy a SQL book, what would you buy? If there is a topic...

    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

    November 23, 2010 at 10:18 am

    #1254585

  • RE: Automated Driving

    GSquared (11/22/2010)

    CirquedeSQLeil (11/22/2010)

    GSquared (11/22/2010)

    CirquedeSQLeil (11/22/2010)

    Great Idea - not sure it is feasible. Issues are a plenty with something like this - virus in the system, hackers, bugs, system outages...

    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

    November 23, 2010 at 7:21 am

    #1254447

  • RE: Work around for SQL server performance issue

    GSquared (11/23/2010)

    On the first stored procedure, I'd convert all the inserts into the table variable into a single CTE, with a few OR statements in the Where clause. Then...

    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

    November 23, 2010 at 7:18 am

    #1254443

  • RE: Today's Random Word!

    LLC

    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

    November 23, 2010 at 7:07 am

    #1254437

  • RE: Are the posted questions getting worse?

    Grant Fritchey (11/23/2010)

    Paul White NZ (11/23/2010)

    GilaMonster (11/23/2010)

    Anyone up for a challenge?

    http://www.sqlservercentral.com/Forums/Topic1024140-360-1.aspx

    I suspect the developer who said those can't be optimised doesn't know the meaning of the word. Dynamic SQL and...

    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

    November 23, 2010 at 7:03 am

    #1254434

  • RE: Work around for SQL server performance issue

    If I missed this suggestion then my apologies. Besides the obvious optimization suggestions already made, you also need to remove the nolock hint from your insert queries at a...

    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

    November 23, 2010 at 7:00 am

    #1254433

  • RE: Delete data in a table

    Grant Fritchey (11/22/2010)

    pavan_srirangam (11/22/2010)

    Check isolation for snapshot isolation level which stores data in tempdb while retrieving data so that actual table can be updated with out lock any row locks...

    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

    November 22, 2010 at 7:20 pm

    #1254150

  • RE: The DBA Disconnect

    I don't know the cost in actual dollars that a breach would cost us, but I could generalize it enough to understand the gravity of the cost. I know...

    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

    November 22, 2010 at 7:18 pm

    #1254149

  • RE: Little Devices

    Nakul Vachhrajani (11/19/2010)

    Personally, I hate the idea of having the office along with me during commutes and at home (that maybe because I have been lucky to have a max....

    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

    November 22, 2010 at 7:15 pm

    #1254148

  • RE: Are You a Ten?

    This is one of those questions that I don't like. There is no way I would rate myself a 9 or 10. But rating yourself at all seems...

    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

    November 22, 2010 at 6:44 pm

    #1254140

  • RE: Google Scale

    I think doing it correct the first time is better than whipping it together incorrectly. There may be a bug or an assumption or business requirement that is wrong...

    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

    November 22, 2010 at 6:38 pm

    #1254136

Viewing 15 posts - 11,656 through 11,670 (of 19,560 total)