Blog Home Page - Page 124 of 829 - SQL Authority with Pinal Dave

At that point, I realized that I should have a blog post that explains to easy way to recompile stored procedures. Today, we will learn about 2 methods.

Nov21

SQL SERVER – Batch Mode in RowStore – Performance Comparison

Pinal Dave

SQL Performance

Batch Mode, ColumnStore Index, Compatibility Level, Execution Plan, SQL Scripts, SQL Server, SQL Server 2019

Let us see in this blog post the performance comparison between Batch Mode and Row Mode. The most asked question was about the Performance difference.

Nov20

SQL SERVER – Improving Deployment Performance by SQL Server Monitoring

Changing trends in the industry where people are now accepting that we can improve deployment performance if we apply proper SQL Server Monitoring.

SQL SERVER - Find Current Location of Data and Log File of All the Database samplexml1

SQL SERVER – Simple Example of Creating XML File Using T-SQL

SQL SERVER – Simple Example of Reading XML File Using T-SQL

SQL SERVER – Restore Master Database – An Easy Solution

SQL SERVER – Reasons to Backup Master Database – Why Should Master Database Backedup

SQL SERVER – List All Server Wide Configurations Values

SQL SERVER – Find Current Location of Data and Log File of All the Database

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.

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.

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.

Feb 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

Task Manager – Confusing Story of CPU

SQL SERVER – ColumnStore Index Displaying Actual Number of Rows To Zero

How to Disable Batch Mode in SQL Server? – Interview Question of the Week #252

SQL SERVER Management Studio – Enable Statistics Time and IO for Every Query

SQL SERVER – Recompile Stored Procedures Two Easy Ways