Transaction Size - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Transaction Size

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2006-11-29 : 01:49:29

Dear All,

I want to know the size of the single row in a transaction table and how can i calculate the whole day transaction size..?

can any one able to help me please..?

Thanks and regards
Krishnakumar.c

Thanks
KK

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-11-29 : 02:48:12

"I want to know the size of the single row in a transaction table"

Select IsNull(datalength(col1),0) + IsNull(datalength(col2),0) + ...
from Tbl
where <condition>

"how can i calculate the whole day transaction size"

select sum(IsNull(datalength(col1),0) + IsNull(datalength(col2),0) + ...
from tbl
where dateadd(d, 0, datediff(d, 0, datecol)) = dateadd(d, 0, datediff(d, 0, getdate()))

Harsh Athalye
India.
"Nothing is Impossible"

monty
Posting Yak Master

130 Posts

Posted - 2006-11-30 : 00:58:01

hey harsh you rock man ...

gr8 stuff even i was looking for this query..

its me monty

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources