Premium Content

Access "Want to improve SQL Server performance? Fine-tune your applications"

Roman Rehak, Contributor Published: 13 Oct 2012

As you develop SQL Server applications that hundreds of users will tap into at once -- using databases with up to millions of rows -- it is critical that you make those applications as efficient as possible so that the hardware can keep up with the workload. This applies to both the database and the client-side application code. Follow these tips and guidelines on fine-tuning your applications and you’ll improve SQL Server performance in no time. It’s all about indexing Pretty much everyone with even a little database experience agrees that indexes are crucial for developing efficient database applications. Yet in practice, indexing gets neglected or isn’t implemented properly. Often, senior-level software engineers develop applications that lack proper indexes (see “Four steps to proper table indexing” below). Without proper indexes, SQL Server has to scan all data in the table to find matching rows. Imagine how difficult it would be to look for certain words in a book without having an index at the end. You would have to read the book cover to cover every ... Access >>>

Access TechTarget
Premium Content for Free.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

What's Inside

Features

More Premium Content Accessible For Free