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

Let us learn, ISNUMERIC Function and Interesting Result. An interesting observation from my client of the Comprehensive Database Performance Health Check.

Jan1

SQL SERVER – Performance and Recompiling Query – Summary

Pinal Dave

SQL Performance

Parameter Sniffing, Query Hint, SQL Scripts, SQL Server, SQL Stored Procedure

No Comments

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

Dec31

SQL SERVER – Parameter Sniffing and OPTION (RECOMPILE)

Pinal Dave

SQL Tips and Tricks

Parameter Sniffing, Query Hint, SQL Scripts, SQL Server, SQL Server Management Studio, SQL Stored Procedure, SSMS

I strongly recommend that you read my earlier blog posts on this topic before you consider the option of recompile suggested in this blog post.

SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL

SQL SERVER – Time Delay While Running T-SQL Query – WAITFOR Introduction

SQL SERVER - Find Currently Running Query - T-SQL color5

SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor

SQL SERVER – sqlcmd vs osql – Basic Comparison

SQL SERVER – Interesting Observation – Using sqlcmd From SSMS Query Editor

SQL SERVER – Find Currently Running Query – T-SQL

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.

Mar 2026 Discount: Comprehensive Database Performance Health Check | Testimonials

SQL SERVER 2019 – How to Turn On or Enable Instant File Initialization?

How to Map Network Drive as Fixed Drive? – Interview Question of the Week #258

SQLBits 2020 – SQL Server Performance Tuning Real-World Scenarios – at ExCel London

SQL SERVER – SQL Azure Managed Instance Restore Error – The Database Was Backed Up on a Server Running Version 15.00.2000

SQL SERVER – ISNUMERIC Function and Interesting Result