Post reply

sp_spaceused rewritten as one query (no cursors)

  • June 13, 2013 at 8:45 pm

    #278575

    Comments posted to this topic are about the item sp_spaceused rewritten as one query (no cursors)

  • June 27, 2013 at 6:29 am

    #1627930

    I'm a relative novice. How can I use this?

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • June 27, 2013 at 10:25 am

    #1628055

    Very nice! Added to my utility "tool box."

    For Caruncles: If you have a situation where your db is running out of alloted space (such as on a 3rd-party shared server) you can use this script to see what objects are the space hogs. Often there are tables that can be "trimmed" of old data, or indexes rebuilt that will reduce the size of the db and avoid upgrade fees from the host.

    Or, in development, you can use this tool to see what your procedures are doing and confirm that they haven't created some endless loop that would cause a table to grow until it brings the server to its knees.

    Or, as I had to do just the other day, you need to analyze someone else's database and just want to see what's there. This tool will show almost instantly the most important tables because those would generally be the ones with high row counts. It will also tell you that certain tables are likely never used if the row count is zero.

    Just lots of good info about your db's tables and indexes.

     

  • June 27, 2013 at 2:44 pm

    #1628135

    Well stated, Old Hand. Thanx!

    Wallace Houston
    Sunnyland Farms, Inc.

    "We must endeavor to persevere."

  • June 27, 2013 at 3:30 pm

    #1628146

    Excellent! 🙂

  • May 2, 2016 at 12:58 pm

    #1876003

    Thanks for the script.

  • May 10, 2016 at 6:25 am

    #1877732

    I thought this looked familiar. Thanks again.

  • May 10, 2016 at 11:03 am

    #1877899

    Stolen -- err, 'borrowed'.

    Actually, this came at a very appropriate time. We're just getting ready to talk to a vendor about their vastly over-spec'ed database server. This query helps give me details about our current data size and helps my ability to demonstrate adequate performance over middling sized data (our largest table is only 2 Gb.) on much, much smaller hardware.

    Thanks again!

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply