When a file is created or grows larger, that file is initialized by dumping zeros before the file gets used. This can affect performance, especially when you are performing backups/restores, create database, etc. SQL Server 2005 now supports Windows...

Database Engine Tuning Advisor in SQL Server 2005 replaces ITW (Index Tuning Wizard). Database Tuning Advisor has much improved and provides very good recommendations. Physical design structures now include: Clustered Indexes, Non-clustered indexes, Indexed...

....very helpful. SQL Server Customer Advisory Team SQL Server Data Engine and CLR Integration Team SQL Server Database Engine - Tips Site SQL Server Communication Protocols Relational Engine Management Team Query Optimizer Team ...

I had a wonderful experience presenting this time at Tech-Ed India 2006 . I presented two sessions: SQL Internals: Core Database Engine Changes in SQL Server 2005 and Getting the Best out of your SQL Box: Performance Tuning SQL Server 2005 . It was so...