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 wall of small wooden cubbyholes, each holding one object such as a spool, a cup or a stone, beside a thick folder stuffed with loose papers and tabs, with one cubby holding a vermilion spool.

Key-Value and Document Databases: When Each One Fits

October 17, 2013
Pinal Dave
SQL Tips and Tricks
Database, JSON, NoSQL, SQL Datatype

Key-Value and Document Databases are two NoSQL models. One finds a value by its key, the other stores a whole JSON document you can query by any field. This post shows when each one fits and builds both patterns in SQL Server 2025 with a key-value table and the json data type.

Read More
A print shop bench with one original sheet and three identical fresh prints laid out beside it to dry.

What Is Replication in SQL Server?

October 16, 2013
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Server

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.

Read More
Gouache painting of a room split in two: on the left a busy shop counter with a small wooden cash box, a vermilion bell and a stack of paper bags, on the right a quiet study corner with a large table covered in charts drawn as plain colored shapes under a reading lamp.

OLTP vs OLAP: Why Transactions and Analytics Need Different Designs

October 16, 2013
Pinal Dave
SQL Tips and Tricks
ColumnStore Index, Data Warehousing, Database, ETL

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.

Read More
A steel connector joins one cream cord to an eyelet while a second cord remains unattached

Polymorphic Associations: Why One Column Cannot Point at Many Tables

October 15, 2013
Pinal Dave
SQL Tips and Tricks
Normalization, Schema, SQL Constraint and Keys

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.

Read More
A tall van stopped at a hanging height bar at a car park entrance while small cars pass under

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

October 15, 2013
Pinal Dave
SQL Performance
Execution Plan, Parallel, SQL Joins, SQL Server

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

Read More
Gouache painting of four identical small lighthouses on four islands along a calm coast, joined by thin wooden footbridges, all four lights glowing the same color, one lighthouse with a vermilion roof, in soft evening light.

What Is NewSQL? Distributed SQL Databases Explained

October 14, 2013
Pinal Dave
SQL Tips and Tricks
ACID, Database, SQL High Availability, SQL Transactions

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.

Read More
Gouache painting: an empty lectern on a bright stage, a tall window behind it showing red-tiled roofs and a mountain, a vermilion cloth draped on the lectern

DevReach 2013: Presenting in Sofia, Bulgaria

October 13, 2013
Pinal Dave
Personal
Conferences, Professional Development, SQLAuthority Author Visit

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.

Read More
Queue barriers with red ropes zigzagging across an empty hall toward a nearby door.

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

October 12, 2013
Pinal Dave
SQL Performance
Execution Plan, Query Hint, Query Store, SQL Joins, SQL Server

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

Read More
Gouache painting of a sturdy old wooden table at the center of a busy workshop, with thin ropes running from the table to baskets, crates and jars around the room, one rope in vermilion, in soft warm light.

Relational Database in Big Data: Still at the Center

October 11, 2013
Pinal Dave
SQL Tips and Tricks
ACID, Change Data Capture, Database, JSON

The relational database in big data projects is still the system of record, and most analytics platforms copy their core business data from it. This post shows what a relational database does well, where it sits in a modern platform, and how the SQL Server 2025 json type adds a flexible schema next to ordinary tables.

Read More
Gouache painting of two boxes of colored pencils side by side, one wide box with all colors mixed together in rows and the other with the same pencils standing in tall separate cups, one color to a cup, with one vermilion cup.

Columnar File Formats: Why Parquet Changed Big Data

October 10, 2013
Pinal Dave
SQL Tips and Tricks
ColumnStore Index, Compression, Data Warehousing, File format

Columnar file formats store a table one column at a time, so a report reads and compresses only the columns it needs. This post compares rows and columns on a tiny table, explains how a Parquet file is laid out, and measures the size difference in SQL Server 2025.

Read More
Previous 1 … 324 325 326 327 328 329 330 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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