May 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
  • Hire Me
  • Health Check
Sep25

Nested Transactions are Myth – SQL in Sixty Seconds #125

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Scripts, SQL Server, SQL Transactions
1 Comment

Many sent me an email that they want to know more about the nested transactions. Let us learn about them in today’s blog post. 

Read More
Sep24

SQL SERVER – Finding Open Transactions for Session – @@TRANCOUNT

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, SQL Transactions
1 Comment

How do I find the open transactions for any session? One of my clients recently asked me during the Comprehensive Database Performance Health Check.

Read More
Sep23

SQL SERVER – Simple Recovery Model and Restrictions

Pinal Dave
SQL Tips and Tricks
Recovery Model, SQL Backup, SQL Log, SQL Restore, SQL Scripts, SQL Server
No Comments

I received a question from a client that they want to move their database from the Full Recovery Model to the Simple Recovery Model, can they do it?

Read More
Sep22

Dropping Temp Table in Stored Procedure – SQL in Sixty Seconds #124

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Performance, SQL Scripts, SQL Server, SQL Stored Procedure, SQL TempDB, Temp Table
11 Comments

Is it necessary to drop a temp table created in the stored procedure? I was recently asked this question during the Comprehensive Database Performance.

Read More
Sep21

SQL SERVER – Simple Explanation FORCE DEFAULT CARDINALITY ESTIMATION

Pinal Dave
SQL Interview Questions and Answers
c, Cardinality, Query Hint, SQL Scripts, SQL Server
No Comments

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

Read More
Sep20

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

Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server, SQL Stored Procedure, SQL TempDB, Temp Table
2 Comments

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
Sep19

SQL SERVER – Running Log Backup While Taking Full Backup

Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Log, SQL Restore, SQL Server, Transaction Log
2 Comments

They found out that they have a full backup running for one of the largest servers and at the same time they are running a log backup on the same server.

Read More
Previous 1 … 78 79 80 81 82 83 84 … 830 Next

SQL SERVER – Create Database Error in Windows Vista

SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2

SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server

SQL SERVER – Function Property – Deterministic or Non-Deterministic

SQL SERVER 2005 – Microsoft Will Release SP3 Soon

SQL SERVER – SQL SERVER – Comparison : Similarity and Difference #TempTable vs @TempVariable – Part 2

SQL SERVER – Four Basic SQL Statements – SQL Operations

Previous 1 … 78 79 80 81 82 83 84 … 830 Next

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 22 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 14 SQL Server database books and 104 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,800 database tech articles on his blog at https://blog.sqlauthority.com.

Pinal is an experienced and dedicated professional with a deep commitment to flawless customer service. If you need help with any SQL Server Performance Tuning Issues, please feel free to reach out at pinal@sqlauthority.com.

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Comprehensive Database Performance Health Check

Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.

Once you learn my business secrets, you will fix the majority of problems in the future.


SQL Server Performance Tuning Practical Workshop

Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.

Essentially I share my business secrets to optimize SQL Server performance.


  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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