Sql Server - How to calculate the size of some rows in a table?

Posted by Tom S. on Stack Overflow See other posts from Stack Overflow or by Tom S.
Published on 2010-04-22T14:51:00Z Indexed on 2010/04/22 14:53 UTC
Read the original article Hit count: 130

Filed under:
|
|

How can i calculate the size of only some rows in a table?

For example, with the code:

EXEC sp_spaceused 'Users'

you obtain the size of all rows, however i want to calculate the size of part of them, something like this:

EXEC sp_spaceused 'Users WHERE Gender='f''

How can i achieve this?

Thanks in advance

© Stack Overflow or respective owner

Related posts about sql-server

Related posts about sql