Table space usage 3

Question

Post reply

Table space usage 3

Viewing 9 posts - 16 through 23 (of 23 total)

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

OzYbOi d(-_-)b SSCarpal Tunnel Points: 4054 More actions · Answer 1

OzYbOi d(-_-)b

SSCarpal Tunnel

Points: 4054

December 2, 2011 at 9:47 am

#1416030

Thanks Hugo 🙂

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 2

Great question. I debated for awhile, completely forgot the way data is stored in pages, and got the answer wrong. But I really enjoyed reading why 🙂

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]

ChrmnMAO Say Hey Kid Points: 675 More actions · Answer 3

Ah, correctly answering one of Hugo's questions is a great start to the weekend! I will savor this feeling, as it may very well months until it happens again.

Great question, Hugo.

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 4

Thanks, all, for the kind words. I figured a not-too hard yes/no question would make for a nice change of pace. (It being scheduled on a friday is not my doing, though).

The next question in this series (which will be a tough one, I hope) is still being prepared, but I do have another (unrelated) question scheduled for next week - so brace yourselves! 😛

Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 5

Nice question, thanks!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 6

Thanks for the question Hugo. I thought it might be trick and almost talked myself out of the correct answser.

http://brittcluff.blogspot.com/

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 7

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."

Hugo Kornelis SSC Guru Points: 64790 More actions · Answer 8

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/Data Platform MVP (2006-2016)
Visit my SQL Server blog: https://sqlserverfast.com/blog/
SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 9

Thanks for the explanation and for all the detailed and brilliant knowledge/analysis.