This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Gouache painting of a picket fence with a tiny padlock on every picket beside a gate with one big vermilion padlock

ROWLOCK Hint and Slow Performance in SQL Server

July 26, 2018
Pinal Dave
SQL Performance
Query Hint, SQL Lock, SQL Scripts, SQL Server

A ROWLOCK hint makes SQL Server lock each row it reads instead of whole pages. This post counts the locks of the same scan with and without the hint, times both versions, shows how an open transaction on a busy server changes the result, and explains how ROWLOCK differs from UPDLOCK.

Read More
Opaque cord sleeves with matching and different crimped profiles beside crimping pliers

Blind Index: Searching an Encrypted Column Without Decrypting

July 11, 2018
Pinal Dave
SQL Performance
ColumnStore Index, Computed Column, SQL Column, SQL Index

Encrypted emails cannot be searched, so store a keyed digest beside them. A hands-on demo of how it works, what it leaks and how rotation hurts.

Read More
An empty classroom lectern covered in small gifts from students, a red apple on top

Practical Real World Performance Tuning – Fun and Reviews

June 27, 2018
Pinal Dave
SQL Performance
Brent Ozar, SQL Server, SQL Training

Part two of my behind the scenes story of Practical Real World Performance Tuning: the fun we had in class and the reviews our students shared.

Read More
Six evenly spaced bird feeders on a fence, a flock of sparrows crowding one and a robin alone on another

Local Variable Estimates: Why the Density Vector Wins

June 18, 2018
Pinal Dave
SQL Performance
Execution Plan, Parameter Sniffing, SQL Server, SQL Statistics, SQL Variable

Understand local variable estimates with skewed data, density calculations, parameter comparisons, and targeted OPTION RECOMPILE tests.

Read More
Gouache painting of a wooden loom with many pale threads and one vermilion thread through the middle

Optimal Value for Max Worker Threads in SQL Server

June 15, 2018
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Server

The optimal value for Max Worker Threads is the default, 0, which tells SQL Server to calculate the limit from the number of logical processors. This post shows how to read the real limit, how the formula works, and which wait and queue counters prove a thread shortage before you change anything.

Read More
SQL SERVER - Performance Comparison IN vs OR

SQL SERVER – Performance Comparison IN vs OR

June 13, 2018
Pinal Dave
SQL Performance
SQL Function, SQL Operator, SQL Server

Which query runs faster, one with IN or one with OR? Here is my performance comparison IN vs OR on AdventureWorks, and both turn out equal.

Read More
Illustrated cover: Implicit Conversion

SQL SERVER – How to Fix CONVERT_IMPLICIT Warnings?

June 11, 2018
Pinal Dave
SQL Performance
SQL Function, SQL Scripts, SQL Server

CONVERT_IMPLICIT warnings are one of the most common performance issues I find in health checks. Here is how to find them in your queries and how to fix them.

Read More
Previous 1 … 48 49 50 51 52 53 54 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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