Feb 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
sql server 2022

SQL SERVER 2022 Features for Performance Optimization

November 8, 2021
Pinal Dave
SQL Performance
Parameter Sniffing, Query Store, SQL Server, SQL Server 2022, SQL TempDB

I am sure by this time you all are aware that Microsoft has announced SQL Server 2022. It will be released sometime next year.

Read More
bad plan

SQL SERVER – Parameter Sniffing and Bad Plan

August 5, 2021
Pinal Dave
SQL Performance
Parameter Sniffing, Query Hint, SQL Scripts, SQL Server

Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!

Read More
multiple param

SQL SERVER – Multiple Optimize Hint for a Query

November 6, 2020
Pinal Dave
SQL Performance
Execution Plan, Parameter Sniffing, Query Hint, SQL Scripts, SQL Server

An interesting question asked by one of my clients. The question was how to have multiple optimize hints for a query. Let us learn.

Read More
stored

What is Stored in TempDB? – Interview Question of the Week #271

April 5, 2020
Pinal Dave
SQL Interview Questions and Answers
Parameter Sniffing, SQL Scripts, SQL TempDB

Question: What is Stored in TempDB?
Answer: In my recent conversation my client asked me if I know what is currently stored in their TempDb.

Read More
disableparametersniffing

SQL SERVER – Disable Parameter Sniffing with DISABLE_PARAMETER_SNIFFING Query Hint

February 12, 2020
Pinal Dave
SQL Performance
Parameter Sniffing, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Stored Procedure, SSMS

Recently during the Health Check, I had a great conversation about how to disable Parameter Sniffing and DISABLE_PARAMETER_SNIFFING Query Hint.

Read More
Recompile Stored

How to Recompile Stored Procedure? – Interview Question of the Week #260

January 19, 2020
Pinal Dave
SQL Interview Questions and Answers
Parameter Sniffing, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure

Question: How to Recompile Stored Procedure?
Answer: The answer to this question is here:

EXEC sp_recompile ‘NameofSP’

Let us read more about it.

Read More
Recompiling Query

SQL SERVER – Performance and Recompiling Query – Summary

January 1, 2020
Pinal Dave
SQL Performance
Parameter Sniffing, Query Hint, SQL Scripts, SQL Server, SQL Stored Procedure

I have been having with many of the readers after reading the latest blog post series on Performance and Recompiling Query.

Read More
1 2 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version