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 row of pebbles, a notched stick, a clay pot and a small red cabinet of drawers on a table

Relational, Document, Graph and Vector: Choosing the Right Data Model

November 1, 2011
Pinal Dave
SQL Tips and Tricks
Database, JSON, NoSQL, SQL Scripts

Choosing the Right Data Model means matching the shape of your data to the questions you ask. This post stores one bookshop four ways in SQL Server 2025, with relational tables, JSON documents, graph tables and a vector column, and runs the question each one answers best. It ends with a rule for choosing.

Read More
A leather splitter beside a finished thin strap and a new thick strap waiting at its rollers

Why SQL Server Has No Result Cache: Buffer Pool and Plan Cache

October 31, 2011
Pinal Dave
SQL Tips and Tricks
SQL Performance, SQL Scripts, SQL Server

A second run is faster, but SQL Server did not remember your answer. A tiny demo shows what really gets reused: pages and plans.

Read More
SQL SERVER - Fundamentals of Columnstore Index

SQL SERVER – Fundamentals of Columnstore Index

October 29, 2011
Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Server 2012

Row store vs column store, explained simply. A Columnstore Index can make searches much faster, but it is not for every table. Learn where each one fits.

Read More
A cake tester with damp crumbs beside several small cakes from one batch

Searching Every Error Log for Slow I/O Warnings

October 28, 2011
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server

The warning you need may be in an archived log. Here is a short loop that searches every retained error log and tells you which ones it could not read.

Read More
A small flashlight beside a closed notebook and plain ceramic mug on a dim wooden desk.

What to Check When You Are Woken at Three in the Morning

October 26, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Use a DBA on call checklist to establish impact, inspect blocking and disk space, review failed jobs, and choose a safe next step during incidents.

Read More
SQL SERVER - DATEDIFF - Accuracy of Various Dateparts

SQL SERVER – DATEDIFF – Accuracy of Various Dateparts

October 21, 2011
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts

Why does DATEDIFF say 1 minute between two times only 3 seconds apart? It is not a bug. Here is how DATEDIFF counts datepart boundaries.

Read More
Results window in sql server management studio.

SQL SERVER – A Simple Quiz – T-SQL Brain Trick

October 19, 2011
Pinal Dave
SQL Puzzle
SQL Scripts

A T-SQL brain trick: three SELECT statements are separated by lines of underscores, and running one of those lines alone gives Msg 2812. Can you explain why?

Read More
Previous 1 … 215 216 217 218 219 220 221 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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