Access your Pro+ Content below.
Want to improve SQL Server performance? Fine-tune your applications
This article is part of the SQL Server Insider issue of October 2011, Vol. 7
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 ...
Access this PRO+ Content for Free!
Features in this issue
Microsoft’s master data management product in SQL Server, Master Data Services, drew tepid reviews from users, but the company has high hopes for a revamped release.
Databases with large numbers -- read millions -- of rows require efficient applications. Improve SQL Server performance by following a few tips and guidelines.
News in this issue
Microsoft StreamInsight, a complex event processing product, is a stab at a whole new space for the company, and not a bad one at that, experts say.