It has been recommended for SQL 2000 and 2005 to enable trace flag 1118 to disable mixed extent allocation. Recently a hotfix came out for SQL Server 2005 SP2 that resolved a potential contention issue with the flag itself: http://support.microsoft.com/kb/936185 Read More...