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