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.
| Author |
Topic |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2003-03-18 : 17:40:12
|
| Hi,Which table will have the values displayed by DBCC Showcontig? I want to add the pages scanned for each table in the database.ex: Tab A- Pages Scanned: 2Tab B- Pages Scanned: 3Total Pages scanned # 5.Thanks,Sarat |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-18 : 17:44:02
|
| Why would you want to to get the data from the actual tables instead of just using the result set from the DBCC statement? Just output the result set into a temp table and do your calculations from there.Tara |
 |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2003-03-18 : 18:21:05
|
| Oh, no! I do want to get the result set from DBCC, I just wanted to know if there is field in any system table which stores the value for scanned pages and all i would do is to sum that column but i guess you answered my question anyway, direct dbcc output to temp table and sum the required column!Thanks,Sarat. |
|
|
|
|
|
|
DBCC Showcontig values