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 |
|
Wittich
Starting Member
2 Posts |
 Posted - 2006-02-21 : 10:28:23
|
| I would like to look at the way my data is stored in the page. I have done this for a long time on Sybase, but I am having trouble with the page number on MS SQLServer 2000. I have a 5 row table. When I select INDID and FIRST from SYSINDEXES, I get indid first ------ -------------- 1 0x370300000100I have tried all manner of gyrations to put this in to the DBCC PAGE command. No matter how I do it, I get an error saying that page is not part of the database, or the format is wrong. From my searching and reading, I think that this actually a combination number, consisting of the file and page number, but I can't see how to separate it. Any assistance would be appreciated. A link to documentation on internals, such as system table details and page formats would be most helpful. I looked in Ken Henderson's book on architecture and internals, and could not find it.Or is there a DBCC command that will tell me more about the table, and perhaps give me the page number in decimal? So far, I can only find the checkdb gives that info on errors only.Thanks for looking at this with me.Doug WHunt Valley, Md |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
Wittich
Starting Member
2 Posts |
Posted - 2006-02-21 : 13:47:49
|
| Thank you, that's exactly what I needed. I never would have dreamed that it was 3 bytes in reverse order.DougDoug WHunt Valley, Md |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-21 : 14:21:30
|
quote:
Originally posted by Wittich
Thank you, that's exactly what I needed. I never would have dreamed that it was 3 bytes in reverse order.
cool, thank nr for the article. He is an occasional regular here at sqlteam.-ec |
|
|
|
|
|
|
|
|
How do I get page number for DBCC PAGE?