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 ladder against one big haystack in a field, a red pitchfork starting the search.

An Index Seek That Reads Millions of Rows: Residual Predicates

August 24, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Index, SQL Performance, SQL Server

Diagnose an index seek that reads far more rows than it returns by checking residual predicates, Actual Rows Read and index key order.

Read More
Three interlocking gears on a pale board, two wooden and one gray, the middle gear with a red center.

Joining Three Tables: Following the Keys Step by Step

August 23, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Constraint and Keys, SQL Joins, SQL Scripts

Joining three tables is easier when you add one join at a time and check the row count after each step. This post builds a small bookshop query from Customers, Orders and OrderLines, adds the book titles, and shows how a missing join condition multiplies rows.

Read More
A blank sheet of paper pinned to a wooden door with a red wax seal, a small brass bell hanging in the hallway.

The Messages Tab in SSMS: Row Counts, Errors and Warnings

August 22, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Error Messages, SQL Scripts, SQL Server Management Studio

The Messages tab in SSMS shows what a query did, not what it returned. This post reads row counts, PRINT output, warnings and errors line by line, and explains what SET NOCOUNT ON changes.

Read More
A wooden seed tray seen from above with rows and columns of small green seedlings, one cell marked with a red stick.

Rows, Columns and Tables: How a Database Holds Information

August 21, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Column, SQL Constraint and Keys, SQL Data Storage, SQL Table Operation

Rows, Columns and Tables are the three ideas behind every relational database. A table holds one kind of thing, a column describes one fact about it, and a row records one item. This post builds a small Books table in SQL Server and reads it back by row and by column.

Read More
A portion scoop beside a mound and equal portions of the same mixture

Readable File Sizes: Converting Bytes to KB, MB and GB

August 20, 2013
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Datatype, SQL Server

Turn raw bytes into friendly sizes without losing accuracy. Includes the overflow trap and the 500 GB drive that shows as 465.7.

Read More
A hand picking a single small star-shaped shell out of a long tideline of scattered shells on a beach.

Escaping Wildcards in LIKE: Searching for % and _ Literally

August 19, 2013
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL Server, SQL String

Handle escaping wildcards in SQL Server LIKE searches with brackets, ESCAPE, and a reusable function that preserves literal input.

Read More
Hands pressing clay into a wooden brick mold beside a row of identical fresh bricks drying

Keeping Admin Scripts One Click Away in SSMS Template Explorer

August 18, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio, SQL Shortcut, SQL Utility

Organize SSMS Template Explorer scripts, fill reusable parameters, review a copy-only backup, and preserve custom templates on disk.

Read More
Equal lengths of plank stacked neatly, a large leftover piece dropped in a red scrap bin.

Integer Division in T-SQL: Why Your Percentages Come Out Zero

August 17, 2013
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Datatype, SQL Server

Fix integer division in T-SQL percentages from COUNT, SUM and window calculations with decimal types and rounding at the right step.

Read More
A tall metal garden gate with a key hanging on a red tassel beside it, and a quiet courtyard of doors beyond.

Logins and Users in SQL Server: Who Gets In and What They Can Do

August 16, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Login, SQL Scripts, SQL Server Security

Logins and users are two different things in SQL Server. A login gets a person or an application into the server, and a user gets them into one database. This post explains Windows and SQL authentication, how a login maps to a user, and how to check the mapping with a query.

Read More
Two wall shelves of glass jars, each jar holding a different grain, lentil or bean, one jar with a red lid.

What Are Filegroups in SQL Server and When to Use Them

August 15, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Data Storage, SQL Scripts, SQL Server Architecture

What are filegroups in SQL Server? A filegroup is a named container for data files, and an ordinary table or index lives in exactly one. This post builds a small demo, shows where a table lands, and gives honest advice on when extra filegroups help and when they only add work.

Read More
Previous 1 … 330 331 332 333 334 335 336 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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