Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Table Information View -- No Cursors! Expand / Collapse
Author
Message
Posted Tuesday, June 30, 2009 12:27 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 9:14 AM
Points: 9,294, Visits: 9,483
Thanks Glenn.

-- RBarryYoung, (302)375-0451 blog: MovingSQL.com, Twitter: @RBarryYoung
Proactive Performance Solutions, Inc.
"Performance is our middle name."
Post #744195
Posted Tuesday, January 29, 2013 1:02 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Saturday, September 6, 2014 10:30 PM
Points: 32, Visits: 219
Very good script ... I will realize small modifications only to customize it. I ask your permission to publish the amended version on a small blog that I'm building ... I can do it?

Fernando Casas Osorio
Post #1413278
Posted Thursday, December 26, 2013 4:44 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, September 25, 2014 10:26 AM
Points: 441, Visits: 458
Here's a link to a similar query I published in June.
http://www.sqlservercentral.com/scripts/99716/

For contrast, that one was attempting to stay as close to the original sp_spaceused results as possible, whereas this new one throws in some extra metadata. That's to say, Barry's version is more customized instead of trying to be super-exact.

My main recommendation would be to put an ORDER BY clause in there. I also notice that this script won't show some user objects that take up space, like an indexed view.

Thanks for sharing!
Post #1526064
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse