Forum Replies Created

Viewing 15 posts - 3,166 through 3,180 (of 19,560 total)

  • RE: First SQl job were you nervous?

    thomashohner (5/3/2014)

    Anyone else sometimes feel nervous that you wont measure up?

    Every new client and often times with new projects for old clients.

    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

    May 6, 2014 at 6:41 pm

    #1711327

  • RE: Are the posted questions getting worse?

    hisakimatama (5/6/2014)

    SQLRNNR (5/6/2014)

    hisakimatama (5/1/2014)

    Whew, busy times at work lately. I've been out of The Thread for a good bit :-).

    Anyone else from The Thread planning to attend this week's...

    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

    May 6, 2014 at 6:38 pm

    #1711326

  • RE: Today's Random Word!

    Revenant (5/6/2014)

    Ed Wagner (5/6/2014)

    crookj (5/6/2014)

    SQLRNNR (5/6/2014)

    Stuart Davies (4/29/2014)

    Zeus

    dog

    Day Afternoon

    Beach

    Boys

    Beatles

    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

    May 6, 2014 at 12:03 pm

    #1711212

  • RE: Today's Random Word!

    Stuart Davies (4/29/2014)

    Zeus

    dog (springer spaniel)

    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

    May 6, 2014 at 6:57 am

    #1711038

  • RE: Are the posted questions getting worse?

    hisakimatama (5/1/2014)

    Whew, busy times at work lately. I've been out of The Thread for a good bit :-).

    Anyone else from The Thread planning to attend this week's SQL Saturday...

    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

    May 6, 2014 at 6:56 am

    #1711036

  • RE: Saving Execution Plans

    jcox 10222 (5/5/2014)

    Has this been completed? If not I'd like to give it a crack. Also do you want to mention any free tools you can use 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

    May 6, 2014 at 6:11 am

    #1711017

  • RE: Join Operations – Hash Match

    I haven't taken any of the IE courses by SQLSkills so couldn't compare what is actually on the slides and the context.

    But from what you posted it looks like 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

    May 4, 2014 at 5:31 pm

    #1710604

  • RE: Memory-Optimized Table checkpoint

    Excellent 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

    May 1, 2014 at 12:13 pm

    #1710187

  • RE: Are the posted questions getting worse?

    GilaMonster (4/24/2014)

    Finally making some progress on at article on premature optimisation. Anyone willing to be a proof-reader? Hopefully will be done this week or next.

    yes please.

    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 24, 2014 at 1:12 pm

    #1708564

  • RE: Table size not reducing after large data delete and index rebuid

    Eric M Russell (4/23/2014)

    I believe that performing a clustered index reorganization is always an online operation, and LOB_COMPACTION (on by default) will also reclaim deallocated LOB pages, which is 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

    April 23, 2014 at 9:44 am

    #1708168

  • RE: script to find most expensive queries across all databases

    Here's an alternative query you could try. Keep in mind it could be a heavy load on a production box.

    SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;

    GO

    /*

    For statement optimization levels 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

    April 23, 2014 at 8:44 am

    #1708142

  • RE: Table size not reducing after large data delete and index rebuid

    Here's an alternative as well for table space usage that is very detailed.

    http://jasonbrimhall.info/2014/03/28/table-space-updated-again/

    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 23, 2014 at 8:29 am

    #1708136

  • RE: Table size not reducing after large data delete and index rebuid

    S_Kumar_S (4/23/2014)

    Can i change the data type from ntext to nvarchar(max) and then will I be able to rebuild the index online?

    Is there any other way around to rebuild 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

    April 23, 2014 at 8:14 am

    #1708124

  • RE: Today's Random Word!

    periwinkle

    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 23, 2014 at 8:05 am

    #1708113

  • RE: Open Source the MCM

    GilaMonster (4/23/2014)

    Brent Ozar (4/23/2014)

    A lot of the fun of the MCM lab was that the questions had surprising catches. The questions and answers alone weren't enough - the lab environment...

    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 23, 2014 at 7:42 am

    #1708103

Viewing 15 posts - 3,166 through 3,180 (of 19,560 total)