How many pages in a table?

Hello, everyone:
How to calculate or estimate the pages or a table? I always heard someone said their databases have many pages increase one day. What does it mean?
Thanks
ZYTwhat does "page" mean? i have heard of databases, tablespaces, and tables, but not pages

can you give more information?|||Look at sp_spaceused
It converts pages to KB.
Just take that part out and you should have what you asked for|||R937: Pages are part of the physical implementation of Microsoft SQL Server (and also of Sybase). While this isn't absolutely correct, you can think of pages as the database engine's "atomic unit" of storage.

Yitongzhang: Calculating the pages used by a table is a slippery kind of thing because it gets pretty far down into how the SQL engine stores data. There are several kinds of pages, some used for data, some for indicies, some for blobs (TEXT and IMAGE columns), and some for log space. Until you really understand how these pages are used, it doesn't make much sense to just count them directly...

Using the sp_spaceused procedure gives you a commonly accepted way to measure table size. You could also study Inside SQL Server (http://www.amazon.com/Inside-Microsoft-Server-2000-CD-ROM/dp/0735609985/ref=pd_bbs_sr_3/104-8575354-0303117?ie=UTF8&s=books&qid=1182263258&sr=1-3) for more details on how tables are stored, and what pages are important for your own purposes and measurements.

-PatP|||thanks, pat, that does sort of ring a bell now

(by the way, and i realize this is really minor, but the handle is r937, not R937, thanks)|||thanks, pat, that does sort of ring a bell now

(by the way, and i realize this is really minor, but the handle is r937, not R937, thanks)

sql server is not case sensitive by default.sql