Access "Want to improve SQL Server performance? Fine-tune your applications"
This article is part of the October 2011, Vol. 7 issue of Microsoft Master Data Services boosts SQL master data management
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 >>>
Premium Content for Free.
Microsoft retooling SQL Server Master Data Services after 'vexing' debut
by Robert Sheldon
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.
- Microsoft retooling SQL Server Master Data Services after 'vexing' debut by Robert Sheldon
Want to improve SQL Server performance? Fine-tune your applications
by Roman Rehak, Contributor
Databases with large numbers -- read millions -- of rows require efficient applications. Improve SQL Server performance by following a few tips and guidelines.
- Want to improve SQL Server performance? Fine-tune your applications by Roman Rehak, Contributor
Microsoft StreamInsight charts course in unfamiliar waters
by Alan Earls
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.
- Microsoft StreamInsight charts course in unfamiliar waters by Alan Earls
More Premium Content Accessible For Free
Today, business analytics is largely focused on self-service software and pushing business intelligence capabilities down to the end user. In this ...
These days, virtual servers are often seen as time- and money-saving efforts for businesses. When deciding if going virtual is the right thing to do,...
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...