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. For example, a query which was running quickly now takes too long to run, or a report is now running very slow. Or, during data import, everything gets slow, or every day during a specific period, many deadlocks occur. Or, queries are continuously responding with time-outs, or SELECT queries are slower when INSERT, UPDATE, and DELETE are happening.
The 8-page whitepaper “7 Indexing Tips to Improve SQL Server Performance” by Pinal Dave highlights several best practices that can give maximum benefits to the SQL Server system.
Drop unused indexes, create missing indexes, remove duplicate indexes, adequately set up clustered indexes, consider using column store indexes for data warehousing, and use the cardinality estimation algorithm.
The author, Pinal Dave, is a SQL Server performance tuning expert and an independent consultant. He authored eleven SQL Server database books, taught 21 Pluralsight courses, and has written over 4500 articles on database technology on his blog. Along with more than 16 years of hands-on experience, he holds a Master’s of Science degree and many database certifications.