Table Space revised Again

Categories: News, Professional, Scripts, SSC
Comments: 2 Comments
Published on: November 17, 2011

Since I am in the Collation Sensitive mood, I am finally getting around to updating this script.  This is the Table Space script that I have had out there for a while.  In the last release of this script, a request (by Remi) was made to update it so it will work with CS.  In addition to that, a request was made to add a few columns.  I have done both.

The CS request was not too big of a deal – just took a minute to actually sit down and do it.  Then it was a matter of setting a test database to CS and confirming that the script continued to work.  A friend did the same legwork (thx Remi) and posted his update in a thread I had been planning on getting back to with the update.  Now it will just get a link to this, and then there can be a circular reference.

The second part of the request was for a change in calculations and possibly additional columns.  I just added columns and someday hope to get back to this script and parameterize the whole thing so that a variable set of columns can be returned – based on user input.  Oh the glory of those someday goals.

So, here is the updated Table Size script.

[codesyntax lang="tsql"]

[/codesyntax]

If you recall, I did two versions of the table size script.  One followed the path of sp_spaceused and the other followed sp_MStablespace.  This script is the one that follows the sp_spaceused version.  I will post an update for the sp_MStablespace version shortly.

2 Comments - Leave a comment
  1. quoted on SQL Table Size | SQL RNNR says:

    […] Today we have another update for an age old script on this site.  You can find the last update to the script here. […]

  2. […] Today we have another update for an age old script on this site.  You can find the last update to the script here. […]

Leave a comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">






Calendar
November 2011
M T W T F S S
« Oct   Dec »
 123456
78910111213
14151617181920
21222324252627
282930  
Content
SQLHelp

SQLHelp

  • @SQLSoldier: @SQLDBA @SQLYard If not connected to the internet, will need to download manually and specify an alternate path for it. #sqlhelp
  • @SQLDBA: @SQLYard That's .NET framework 3.5. Enable through Windows features. #sqlhelp
  • @SQLYard: #sqlhelp, Issue installing SQL on a VM 2012 Please try enabling Windows feature :NetFx3. I have tried most of the fixes on the web.Thanks
  • @sqlconcepts: Dear #sqlhelp, does anyone have a bit of code that will help me estimate the space requirement for Change Tracking on a table?
  • @DevDBABrian: @SQLPoolBoy #SQLHelp Thank you Jonathan. SSMS wizard be good.
  • @SQLPoolBoy: @DevDBABrian Or if it needs to be up to date near real time look at replication to the other location #sqlhelp All depends on requirement
  • @SQLPoolBoy: @DevDBABrian For just a one time copy of the data Import/Export wizard in SSMS #sqlhelp Save the package for routine use if necessary
  • @DevDBABrian: Need to copy 20 tables (5GB) to another server/db to support a monthly process. What approach do you recommend? #sqlhelp
  • @ChrisAdkin8: @MladenPrajdic you have to admire their tanacity, my #sqlhelp question memory grants in execution plans in mamagement studio are in bytes ?
  • @ChrisAdkin8: #sqlhelp when you mouse over the left most node in a plan that has granted memory the memory grant unit is in bytes ?

Welcome , today is Tuesday, September 30, 2014