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
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
Query Hints

SQL SERVER – Applying Query Hints to Views

July 14, 2021
Pinal Dave
SQL Tips and Tricks
Query Hint, SQL Scripts, SQL Server

I totally agree that it is not possible to apply query hints to views inside the view. It will give you an error. However, there is a workaround. 

Read More
goal optimizer

SQL SERVER – Disable Rowgoal Optimizer

December 28, 2020
Pinal Dave
SQL Performance
Execution Plan, Query Hint, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

In my career, this is I think 2 or 3 rd time I have seen this one, so do not consider this as a generic solution. How to Disable Rowgoal Optimizer works?

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
FORCE-DEFAULT

SQL SERVER – Simple Explanation FORCE DEFAULT CARDINALITY ESTIMATION

September 21, 2020
Pinal Dave
SQL Interview Questions and Answers
c, Cardinality, Query Hint, SQL Scripts, SQL Server

One of my client of Health Check recently asked me if I can help them understand how FORCE DEFAULT CARDINALITY ESTIMATION works

Read More
force index

How to Force Index on a SQL Server Query? – Interview Question of the Week #281

June 14, 2020
Pinal Dave
SQL Interview Questions and Answers
Clustered Index, Query Hint, SQL Index, SQL Scripts, SQL Server

Question: How to Force Index on a SQL Server Query?
Answer: I personally do not like to force an index on any query. Let us learn together.

Read More
option

SQL SERVER – SQL_NO_CACHE and OPTION (RECOMPILE)

April 6, 2020
Pinal Dave
SQL Tips and Tricks
MySQL, Query Hint, SQL Cache, SQL Scripts, SQL Server

How to retrieve queries, not from the cache for MySQL and SQL Server, we discussed SQL_NO_CACHE and OPTION (RECOMPILE). Let us discuss this.

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

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

Go to mobile version