question on datapages? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

question on datapages?

Hi everyone, i am working as oracle dba now i need to support sql server 2000/2005 i have a question.
senerio is:
i have a table which contain 1 million records. my end users are doing lot of inserts and updating one column. it is huge colums contain 2000 bytes. my question is i want to know how many extents are that i have per one table(big table).
again i want to know the datapages allocation per extent. if i found lot of extent per table then i how do i perform reorg. Regards,

In the SQL Server world, we have extents, but we don’t really care about them. If you goal is to do a reorg, read this article in SQL Server Books Online: "Reorganizing and Rebuilding Indexes". It will answer all your questions. ————————————————————–
Brad M. McGehee, SQL Server MVP
Technical Editor/Moderator www.SQL-Server-Performance.Com
Director of DBA Education for www.Red-Gate.Com
Welcome to SSP! & book references on what you should know within SQL Server for a Oracle pro. Also the books online entry for pages & extents. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.