How to check which column is taking more space in a table?

Question

How to check which column is taking more space in a table?

Chowdary's

SSCrazy

Points: 2978
More actions
November 30, 2014 at 10:04 pm

#397710

Hi Everyone..
One of the table is occupying more space.
how to check which column is taking more space in a table?
Regards
Chowdary...

Viewing 2 posts - 1 through 1 (of 1 total)

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

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 1

Chowdary's (11/30/2014)
Hi Everyone..
One of the table is occupying more space.
how to check which column is taking more space in a table?

This is for the same problem that you're having at the following post.

http://qa.sqlservercentral.com/Forums/Topic1640102-1550-1.aspx

I strongly recommend that you don't post multiple questions on different posts for the same problem because it'll just end up dividing the resources of the people trying to help you.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions