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.
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!
http://www.sql-server-performance.com/sql_2000_for_oracle_dbas_review.asp &http://www.microsoft.com/sql/prodinfo/compare/oracle/oracle.mspx book references on what you should know within SQL Server for a Oracle pro. Alsohttp://msdn2.microsoft.com/en-us/library/ms190969.aspx the books online entry for pages & extents. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
@http://www.askasqlguru.com/ 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.