Forum Replies Created

Viewing 15 posts - 3,031 through 3,045 (of 19,560 total)

  • RE: Table/Database size doesn't shrink after Index Deletion

    Run the script here and see if it also reports that same size

    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

    May 27, 2014 at 10:29 am

    #1716758

  • RE: Laptop Dreams

    I just recently played through this exercise. I was at SQL Saturday Atlanta and my laptop decided to start acting finicky. I have fixed that problem on that...

    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 27, 2014 at 9:56 am

    #1716750

  • RE: Laptop Dreams

    Gary Varga (5/27/2014)

    People using the tablet as a camera/video recorder reminds me of the comedian Dom Jolly's sketch "I'm on the phone". It can be a variant of wearing 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

    May 27, 2014 at 9:52 am

    #1716747

  • RE: Laptop Dreams

    BWFC (5/27/2014)

    Robert Sterbal-482516 (5/25/2014)

    Am I spoiled by the fact that I'm willing to lug my digital SLR virtually everywhere?

    My wife's the same. I've got a smaller, lighter mid-range compact...

    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 27, 2014 at 9:51 am

    #1716746

  • RE: Today's Random Word!

    typical

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

    #1716729

  • RE: Get User In Reporting Services

    Gary Varga (5/27/2014)

    Terrible "side effect" coding style!!!

    +10

    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 27, 2014 at 9:09 am

    #1716723

  • RE: Temp table limitations

    Nakul Vachhrajani (5/25/2014)

    I got it wrong, but the "correct" answers stumped me. How are "local" temporary tables visible across sessions?

    They are not. Take a look at the notes posted...

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

    #1716480

  • RE: Temp table limitations

    Steve Jones - SSC Editor (5/24/2014)

    Hany Helmy (5/24/2014)

    SQLRNNR (5/23/2014)

    Steve Jones - SSC Editor (5/23/2014)

    Question changed and points awarded back as you can apparently partition a temp table: http://www.sqlservercentral.com/blogs/sqlrnnr/2014/05/23/can-you-partition-a-temporary-table/

    Thanks Steve.

    And by...

    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 24, 2014 at 10:19 am

    #1716323

  • RE: Temp table limitations

    Hany Helmy (5/24/2014)

    SQLRNNR (5/23/2014)

    Steve Jones - SSC Editor (5/23/2014)

    Question changed and points awarded back as you can apparently partition a temp table: http://www.sqlservercentral.com/blogs/sqlrnnr/2014/05/23/can-you-partition-a-temporary-table/

    Thanks Steve.

    And by the way - thanks for...

    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 24, 2014 at 10:18 am

    #1716322

  • RE: Temp table limitations

    Steve Jones - SSC Editor (5/23/2014)

    Question changed and points awarded back as you can apparently partition a temp table: http://www.sqlservercentral.com/blogs/sqlrnnr/2014/05/23/can-you-partition-a-temporary-table/

    Thanks Steve.

    And by the way - thanks for continuing this feature...

    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 23, 2014 at 11:58 pm

    #1716296

  • RE: SSMS 2012 is using 3+ Gigs of Ram... suggestions?

    How long before it ramps up to 3gb?

    I have seen SSMS consume GBs of memory before due to returning query results. Is this person running some extremely complicated queries...

    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 23, 2014 at 3:28 pm

    #1716271

  • RE: Temp table limitations

    KWymore (5/23/2014)

    SQLRNNR (5/23/2014)

    TomThomson (5/23/2014)

    SQLRNNR (5/23/2014)

    I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

    Temp tables...

    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 23, 2014 at 2:43 pm

    #1716263

  • RE: Are the posted questions getting worse?

    Sean Lange (5/23/2014)

    LOL. Apparently I need to endorse my SSC friends more on LinkedIn.

    That can't be dwain 😉 there is no giant fish.

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

    #1716249

  • RE: Today's Random Word!

    whereisSQL? (5/23/2014)

    TomThomson (5/23/2014)

    Revenant (5/23/2014)

    Ed Wagner (5/23/2014)

    SQLRNNR (5/23/2014)

    Ed Wagner (5/23/2014)

    crookj (5/23/2014)

    Ed Wagner (5/23/2014)

    BWFC (5/23/2014)

    Ring

    Rule

    Decree

    Dictate

    PotatoHead

    Toy

    Story

    Board

    Chalk

    ongle

    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 23, 2014 at 12:59 pm

    #1716238

  • RE: Temp table limitations

    TomThomson (5/23/2014)

    SQLRNNR (5/23/2014)

    I disagree that this is an easy question. There may be two obviously correct options but there is a third option that is correct.

    Temp tables can 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

    May 23, 2014 at 12:57 pm

    #1716237

Viewing 15 posts - 3,031 through 3,045 (of 19,560 total)