Nov 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
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
logical read

SQL SERVER – What is Logical Read?

November 12, 2020
Pinal Dave
SQL Performance
Logical Read, SQL Server, SQL Server Management Studio, SQL Statistics, SSMS

Comprehensive Database Performance Health Check and they asked me a question about logical read based on my previous video about SET STATISTICS IO.

Read More
zero

SQL SERVER – Scan Count Zero for Statistics IO

October 28, 2020
Pinal Dave
SQL Performance
Execution Plan, Primary Key, SQL Scripts, SQL Server, SQL Statistics

On the production server and they noticed scan count as Zero on the result. They reached out to me asking what actually it means.

Read More
statistics time

SET STATISTICS TIME ON – SQL in Sixty Seconds 139

October 27, 2020
Pinal Dave
SQL Video
SQL DateTime, SQL in Sixty Seconds, SQL Statistics

Do you know how long your query took to execution? Well, let us learn that today in SQL in Sixty Seconds. We will discuss SET STATISTICS TIME ON.

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

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

Go to mobile version