About the Talk
November 5, 2011 11:45 AM
Microsoft MTC 5404 Wisconsin Ave Suite 700 Chevy Chase MD 20815Microsoft MTC 5404 Wisconsin Ave Suite 700 Chevy Chase MD 20815
Performance of SQL Server poor? One cause may have been that starting file size that you didn't think was important because it will auto-grow. Why is auto-grow bad? Why shouldn't files be auto-shrunk? Why keep that free space in the files? Explore the physical structure of a database, how table structure effects use of memory and key mistakes to avoid. Additionally, dive into the transaction log process - VLFs, auto-recovery and lock escalation. Solid foundation for Programmers and Administrators!