March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
11tips

11 Essential Tips for Avoiding Common SQL Server Performance Tuning Mistakes

February 1, 2023
Pinal Dave
SQL Performance
Data Type, Normalization, Software Development, SQL Backup, SQL Cursor, SQL Data Storage, SQL Index, SQL Server, SQL Server Security, SQL Statistics, Temp Table

This blog post will cover 11 tips for avoiding common SQL server mistakes. From indexing to security, these tips will help you optimize your database’s performance.

Read More
index performance

SQL SERVER – Measure Index Performance

October 27, 2021
Pinal Dave
SQL Performance
Clustered Index, SQL Index, SQL Server, SQL Statistics

My client reached out to me asking if there is a way to measure the performance of the newly created index. How to measure index performance. 

Read More
Time of Stored Procedure

SQL SERVER – Execution Time of Stored Procedures

August 11, 2021
Pinal Dave
SQL Performance
Execution Plan, SQL Statistics, SQL Stored Procedure, SSMS

How to measure the execution time of the stored procedure when it contains lots of statement inside of it. Let us learn today about Stored Procedures

Read More
maximum column

SQL SERVER – Maximum Column Per Index – 32

March 22, 2021
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Index, SQL Scripts, SQL Server, SQL Statistics

Well, the answer is you can have 32 Maximum Column Per Index but that does not mean you should have 32 indexes. Let us learn today.

Read More
Disabled Nonclustered

SQL SERVER – sp_updatestats Performance and Disabled Nonclustered Indexes

December 4, 2020
Pinal Dave
SQL Performance
Clustered Index, SQL Scripts, SQL Server, SQL Statistics

Today I am going to share our very interesting conversation about sp_updatestats and Disabled Nonclustered Indexes. Let us discuss.

Read More
JOIN Elimination

SQL SERVER – JOIN Elimination for Not Selected Column

November 25, 2020
Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Operator, SQL Scripts, SQL Server, SQL Statistics, SSMS

The question is about JOIN Elimination for Not Selected Column. It was discussed in the Comprehensive Database Performance Health Check.

Read More
disable statistics

SQL SERVER – Disable Statistics Update for a Single Table

November 17, 2020
Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Server Configuration, SQL Statistics

Recently I had encountered an interesting issue with one table where we had to disable statistics update for a single table. How we can do that?

Read More
1 2 3 4 … 10 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version