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
Oct16

What Is Replication in SQL Server?

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Server
1 Comment

Replication in SQL Server copies chosen tables to other servers and keeps them current. Publisher, distributor and subscriber in plain words, the three kinds, and why replication is not high availability or a backup.

Continue Reading
Oct16

OLTP vs OLAP: Why Transactions and Analytics Need Different Designs

Pinal Dave
SQL Tips and Tricks
ColumnStore Index, Data Warehousing, Database, ETL
4 Comments

OLTP vs OLAP is the difference between recording what’s happening now and studying what’s already happened. This post compares the two designs, tests the same 500,000 orders as a rowstore and a columnstore table on SQL Server 2025, and shows how data moves from one side to the other.

Continue Reading
Oct15

Polymorphic Associations: Why One Column Cannot Point at Many Tables

Pinal Dave
SQL Tips and Tricks
Normalization, Schema, SQL Constraint and Keys
No Comments

One column that points at many tables cannot be enforced by SQL Server. Here is the demo, the orphans it allows, and a design that says no to bad rows.

Continue Reading
Oct15

Bitmap Filters in Parallel Hash Joins: Reading Them in a Plan

Pinal Dave
SQL Performance
Execution Plan, Parallel, SQL Joins, SQL Server
No Comments

Read bitmap filters in parallel hash join plans, compare fact scan output, and distinguish early row rejection from guaranteed savings.

Continue Reading
Oct14

What Is NewSQL? Distributed SQL Databases Explained

Pinal Dave
SQL Tips and Tricks
ACID, Database, SQL High Availability, SQL Transactions
3 Comments

What is NewSQL? It’s the name for relational databases that spread data over many servers and still give you SQL and ACID transactions. This post walks one orders table through key ranges, replicas and a majority vote.

Continue Reading
Oct13

DevReach 2013: Presenting in Sofia, Bulgaria

Pinal Dave
Personal
Conferences, Professional Development, SQLAuthority Author Visit
4 Comments

I presented my Database Worst Practices session at DevReach 2013 in Sofia, Bulgaria, on October 1, 2013. It was my first time presenting in Europe. Here is my recap of the conference and my day in Sofia, with photographs.

Continue Reading
Oct12

OPTION (FORCE ORDER): When a Join Order Hint Helps and Hurts

Pinal Dave
SQL Performance
Execution Plan, Query Hint, Query Store, SQL Joins, SQL Server
No Comments

Test OPTION (FORCE ORDER) against real join plans, see when fixed table order helps or hurts, and apply a reversible Query Store hint.

Continue Reading
Previous 1 … 464 465 466 467 468 469 470 … 847 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

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

Pinal has authored 19 books and 125 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 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.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

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