Whitepaper : 7 Indexing Tips to Improve SQL Server Performance

SQL Server performance is always one of the most challenging subjects. Hard drives are getting cheaper and cheaper, and data is growing exponentially. With this new pattern, we all have a significant challenge. In the database world, though, we now have new problems affecting performance. Here are a few issues that keep coming up in various systems in the industry:

  • A query which was running quickly now takes too long to run
  • Our report is now running very slow
  • During data import everything gets slow
  • Every day during a specific period we are facing many deadlocks
  • Queries are continuously responding with time-outs
  • SELECT queries are slower when INSERT, UPDATE and DELETE are happening

Throughout the years Pinal Dave has seen and solved many similar issues. He has seen many bad practices implemented in SQL Server at the server and database level. There are hundreds of tips that one can practice to keep a database at optimal performance.

The purpose of this whitepaper is to highlight a few best practices that can give maximum benefits to the SQL Server system. Out of thousands of best practices, Pinal has selected the seven best practices related to indexes. The whitepaper describes how to drop unused indexes, create missing indexes, remove duplicate indexes, the significance of clustered indexes, column store indexes for data warehousing, cardinality estimation, and additional indexing best practices.

Author: Pinal Dave

Pinal Dave is a SQL Server performance tuning expert and an independent consultant. He has authored 11 SQL Server database books, taught 21 Pluralsight courses, and has written over 4500 articles on database technology on his blog at https://blog.sqlauthority.com. Along with 16+ years of hands-on experience, he holds a Masters of Science degree and many database certifications.

Register to read the full whitepaper.

 

See Also:

Topics : Database Performance,SQL Query Performance,

Products : SQL Query Tuner,

Register for Free Whitepaper

Note: By registering, you confirm that you agree to the processing of your personal data by Idera, Inc. as described in the Privacy Statement.
Idera, Inc. is part of the Idera group and may share your information with its parent company Idera, Inc., and its affiliates. For further details on how your data is used, stored, and shared, please review our Privacy Statement.