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
Temp stored procedures

What is Temp Stored Procedures? – Interview Question of the Week #294

September 20, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Stored Procedure, SQL TempDB, Temp Table

Temp stored procedures are the SPthat are created with the help of the # at the beginning of the name and only available until the SQL Server restarts.

Read More
Last Compiled

When was Stored Procedure Last Compiled? – Interview Question of the Week #292

September 6, 2020
Pinal Dave
SQL Interview Questions and Answers
SQL Cache, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure

Question: When was Stored Procedure Last Compiled?

Answer: Honestly, it is difficult to figure out when was the stored procedure last compiled.

Read More
recent execution

Recent Execution of Stored Procedure – SQL in Sixty Seconds #118

September 5, 2020
Pinal Dave
SQL Video
SQL DMV, SQL in Sixty Seconds, SQL Server Management Studio, SQL Stored Procedure, SSMS

My clients were not sure which SPs are the recent SP and which SP is no longer used. Today we will learn about the recent execution of the stored procedure. 

Read More
Reduce Deadlock

SQL SERVER – Reduce Deadlock for Important Transactions With Minimum Code Change

June 24, 2020
Pinal Dave
SQL Performance
Blocking, Deadlock, Locking, SQL Lock, SQL Server Configuration, SQL Stored Procedure

They had one transaction which was often the victim of deadlock. Today how to Reduce Deadlock for Important Transactions With Minimum Code Change.

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
slow performance

SQL SERVER – Top Reasons for Slow Performance

February 10, 2020
Pinal Dave
SQL Performance
Ad Hoc Query, Clustered Index, Disk, File Growth, Query Hint, SQL CPU, SQL DMV, SQL Function, SQL Index, SQL Memory, SQL Server, SQL Server Configuration, SQL Stored Procedure, SQL TempDB, SQL Utility

Yesterday, I had asked a very simple question on twitter about the top reasons for the slow performance. Let us discuss this topic today.

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
Previous 1 2 3 4 5 6 … 29 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version