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 space usage 3 Expand / Collapse
Author
Message
Posted Monday, December 5, 2011 5:35 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Thanks for the question Hugo. I thought it might be trick and almost talked myself out of the correct answser.

http://brittcluff.blogspot.com/
Post #1216227
Posted Friday, March 7, 2014 7:00 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 17, 2014 12:08 AM
Points: 806, Visits: 1,409
Disclaimer : Please excuse me for the delayed attempt for these questions


I have attempted "table space usage" questions 1,2 and 3 in sequence, but the answer for question 3 is mentioned in discussion of question 2 .



http://www.sqlservercentral.com/Forums/Topic1206403-1328-3.aspx

"In the real world, one would never calculate the data size to the exact page number."
Post #1548723
Posted Friday, March 7, 2014 1:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 3:07 AM
Points: 6,040, Visits: 8,322
pmadhavapeddi22 (3/7/2014)
Disclaimer : Please excuse me for the delayed attempt for these questions


I have attempted "table space usage" questions 1,2 and 3 in sequence, but the answer for question 3 is mentioned in discussion of question 2 .



http://www.sqlservercentral.com/Forums/Topic1206403-1328-3.aspx

"In the real world, one would never calculate the data size to the exact page number."


I think that quote in the discussion on question 2 is about the lack of practical application. And that is true. In a real database, I want to have a good estimate about the data size I can expect, but I truly am not bothered by just a few pages more or less. However, the table designs I used in question 1 and 2 were such that an exact calculation is at least possible.
For question 3, the table design is such that based on the given information it is impossible to do this exact computation - even if you would want to.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1548881
Posted Sunday, March 9, 2014 11:28 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, October 17, 2014 12:08 AM
Points: 806, Visits: 1,409
Thanks for the explanation and for all the detailed and brilliant knowledge/analysis.
Post #1549101
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse