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
A plain measuring ruler beside two small wooden blocks and a blank notebook on a table.

Reading a Benchmark Somebody Else Published

October 6, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Read a database benchmark by checking workload rules, hardware, durability, latency, pricing scope, and whether the test can be repeated.

Read More
Artichokes grouped into clay pots with uneven numbers and an empty pot

Spreading Rows Into Hash Buckets With CHECKSUM and Modulo

September 14, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Equal row counts do not mean equal work, and patterned keys can pile into one bucket. Here is how to test your buckets before adding workers.

Read More
A hand passing a cut rose stem with one spotted leaf and a pouch of soil across a garden gate

Asking a SQL Question That Gets Answered: The Reproducible Script

August 22, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Server, Starting SQL

Write a reproducible script with minimal tables, synthetic rows, the failing query, expected results, and the exact SQL Server version.

Read More
Saddle stirrups connected to one rail by different leather straps

Finding Which Network Protocol Each Session Uses

July 22, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, Computer Network, SQL Server

Before you switch off a protocol, find out who still uses it. Two short queries show how each session connected, and why the address is not a person.

Read More
Extended trombone slide beside exact-length and shorter supporting cradles

Converting float to Text Without Losing Digits

April 20, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

The default float to text conversion keeps about six digits. Here is the one style that gives your float back exactly, and the traps around it.

Read More
Three intact oboe reeds with one subtly different tip opening

Spotting Definition Drift With HASHBYTES on Module Code

January 20, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Did someone change a production procedure and forget to tell you? Hash the module text, compare it with a baseline, and let SQL Server point at the culprit.

Read More
Gouache painting of an open wooden pencil box with short pencils fitting neatly inside and one long vermilion pencil lying across the top, too long for the lid

Error 2628: Finding the Value That Would Be Truncated

January 17, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Error Messages, SQL Server

A nightly import fails and nobody knows which column is too small. Error 2628 tells you. Here is how to read it and catch every oversized value up front.

Read More
Previous 1 … 8 9 10 11 12 13 14 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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