<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Ahmad Osama
»
Estimating the table size...
15 posts, Page 2 of 2
««
1
2
Estimating the table size...
Rate Topic
Display Mode
Topic Options
Author
Message
dant12
dant12
Posted Thursday, July 02, 2009 1:24 PM
SSC Veteran
Group: General Forum Members
Last Login: Monday, May 13, 2013 2:19 PM
Points: 242,
Visits: 656
according to your script one of my tables has 440 MBs but SSMS says it has around 46 MBs
u sure u did the math right?
--
Thiago Dantas
@DantHimself
Post #746589
Sqlfrenzy
Sqlfrenzy
Posted Thursday, July 02, 2009 1:30 PM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 12:47 AM
Points: 1,431,
Visits: 1,540
thanks william...
Regards,
Sqlfrenzy
Post #746594
Sqlfrenzy
Sqlfrenzy
Posted Thursday, July 02, 2009 1:42 PM
Ten Centuries
Group: General Forum Members
Last Login: Monday, May 20, 2013 12:47 AM
Points: 1,431,
Visits: 1,540
dant12 (7/2/2009)
according to your script one of my tables has 440 MBs but SSMS says it has around 46 MBs
u sure u did the math right?
I tested the script against the 7 tables of adventureworks database...5 tables gave me result with a margin +1/-1..
Regards,
Sqlfrenzy
Post #746599
Langston Montgomery
Langston Montgomery
Posted Wednesday, June 09, 2010 6:25 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, April 11, 2013 10:55 AM
Points: 37,
Visits: 402
Wouldn't it be incorrect to compare this script to an existing table, since the script is meant to
estimate
a table's size
Sqlfrenzy (7/2/2009)
dant12 (7/2/2009)
according to your script one of my tables has 440 MBs but SSMS says it has around 46 MBs
u sure u did the math right?
I tested the script against the 7 tables of adventureworks database...5 tables gave me result with a margin +1/-1..
Post #935085
SQL_ME_RICH
SQL_ME_RICH
Posted Friday, February 25, 2011 1:35 PM
SSC-Addicted
Group: General Forum Members
Last Login: Yesterday @ 2:58 PM
Points: 438,
Visits: 1,145
I like this, but Richard Ding's creation "sp_sos" is a little more thorough, and is a PROC instead of a group of Functions.
http://media.techtarget.com/searchSQLServer/downloads/URL_for_SQL_Script_download_Tip_on_Sp_SOS.doc
Post #1069836
« Prev Topic
|
Next Topic »
15 posts, Page 2 of 2
««
1
2
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
