June 24, 2007 - SQL Authority with Pinal Dave

SQLAuthority News – Book Review – Microsoft(R) SQL Server 2005 Unleashed (Paperback)

June 24, 2007

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQLAuthority.com Book Review : Microsoft(R) SQL Server 2005 Unleashed (Paperback) by Ray Rankins, Paul Bertucci, Chris Gallelli, Alex T. Silverstein Link to book on Amazon Short Review : SQL Server 2005 Unleashed is focused on Database Administration and day-to-day administrative management aspects of SQL Server. All the chapters of this…

SQL SERVER – Comparison Index Fragmentation, Index De-Fragmentation, Index Rebuild – SQL SERVER 2000 and SQL SERVER 2005

June 24, 2007

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

DBA, SQL Index, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Utility

Index Fragmentation: When a page of data fills to 100 percent and more data must be added to it, a page split occurs. To make room for the new data, SQL Server must move half of the data from the full page to a new page. The new page that…