One of the beautiful things about SQL Server is how accessible it is. It is about as difficult to install as, say, Microsoft Office. This is great if you want a sandbox, or a database to support just a handful of users. The problem is that in order for SQL Server to perform as an enterprise-level database management system, the out of the box install does not cut it. In addition, you need to consider and implement design considerations and maintenance to enable the true capability of the platform.
Watch the educational Geek Sync webinar “Top 10 SQL Server performance makers and breakers” with Mindy Curnutt to learn about the items that will have the biggest impact on scalability. Topics will include indexes, virtualization, maintenance, T-SQL techniques, configuration settings, and trace flags.