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
Cardinality Estimation Model Version.

SQL SERVER – How to Know Cardinality of Executed Query?

September 1, 2014
Pinal Dave
SQL Performance

Which estimator did SQL Server 2014 use? There are two ways to know the cardinality of executed query, starting with the execution plan properties.

Read More
Backup and recovery settings for SQL Server.

SQL SERVER – Backing Up and Recovering the Tail End of a Transaction Log – Notes from the Field #042

August 21, 2014
Pinal Dave
SQL Performance
Notes from the Field

Tail log backup confuses many people, even with the new hints on the restore screen. Learn how to back up and recover the tail end of a transaction log.

Read More
Gouache painting: two jars of dried beans on a market table, one still full and one with its beans counted into small even piles beside it; one vermilion bean in the full jar

New Cardinality Estimation: What Changed Since 2014

August 19, 2014
Pinal Dave
SQL Performance
Compatibility Level, Execution Plan, Query Hint, SQL Statistics

The new cardinality estimation guesses row counts differently from the old one. This post tests both on SQL Server 2025 with one query, shows three switches that choose the model, and gives a safe way to upgrade.

Read More
An archery target with early arrows scattered wide and later ones closer, the newest vermilion arrow near the center.

CE Feedback for Expressions in SQL Server 2025

August 18, 2014
Pinal Dave
SQL Performance
Execution Plan, Query Store, SQL Server, SQL Statistics

Inspect CE feedback for expressions in SQL Server 2025, check compatibility and Query Store, and observe repeated execution evidence.

Read More
A glass pipette above selected potato pieces, one with a blue-black spot, beside untouched carrots and tomatoes

REGEXP_LIKE Performance: Why Pattern Filters Cannot Seek

August 11, 2014
Pinal Dave
SQL Performance
SQL Index, SQL Performance, SQL String

A short pattern can run a long CPU bill. Here is why REGEXP_LIKE scans, and how a plain prefix filter gives the index something to seek.

Read More
Gouache painting of a red basket of fresh bread on a bakery counter with flour sacks far away in the storeroom

In-Memory OLTP in SQL Server: Memory-Optimized Tables Explained

August 8, 2014
Pinal Dave
SQL Performance
In-Memory OLTP, SQL Index, SQL Scripts, SQL Server

In-Memory OLTP stores selected tables in memory and uses row versions instead of locks. This post builds a small demo database, compares a disk table with two memory-optimized tables, and tests a natively compiled procedure. It also covers durability, bucket counts and memory use.

Read More
A butter knife spreading a whole row of toast slices in one long stroke on a wooden board.

Scalar UDF Inlining: When Old Functions Suddenly Get Fast

July 24, 2014
Pinal Dave
SQL Performance
Execution Plan, SQL Function, SQL Performance, SQL Server 2019

Check scalar UDF inlining eligibility, database settings, function options, and execution plans before claiming a performance improvement.

Read More
Previous 1 … 62 63 64 65 66 67 68 … 128 Next
  • Books
  • Testimonials
  • Privacy Policy

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