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 wide reading table with one large ledger open at the centre and reference volumes arranged around it

What Is a Data Warehouse?

September 5, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Business Intelligence, Data Warehousing, Database

A data warehouse is built for questions, not transactions. Facts and dimensions in plain words, why the star schema reads the way people talk, what a date dimension is for, and when you do not need one.

Read More
Several small plain brass locks beside one larger plain lock on a warm wooden tabletop.

What Lock Escalation Is and How to Stop It

September 1, 2011
Pinal Dave
SQL Performance
Best Practices, SQL Index, SQL Performance, SQL Server

Understand lock escalation, confirm it with evidence, and reduce its impact through smaller transactions, better access paths, and modern locking.

Read More
Gouache painting of a stack of blank cards and an open document tray, representing a set of rows.

SQL Server: Use INSERT INTO SELECT Instead of a Cursor

August 10, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts

Replace a row-by-row server inventory copy with INSERT INTO SELECT and test the results, including a loop that fails when IDs have gaps.

Read More
Two boxes joined by an arrow. Phase one, organize, runs SELECT star in three steps that return 4, 7 and 5 rows. Phase two, itemize, swaps the star for a column list and returns the same 5 rows

Build a Query in Two Phases: Organize First, Itemize Second

August 4, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Coding Standards, SQL Joins, SQL Scripts

Build a query in two phases: organize first, itemize second. Phase one gets the tables, joins and filter working with SELECT *, and phase two swaps the star for a column list. This post shows the method on a small branch and staff table, and the three errors it helps you avoid.

Read More
disaster

SQL SERVER – Database Worst Practices

July 12, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices

Let us talk about SQL SERVER – Database Worst Practices. Instead of writing best practices, I am going to write about few of the bad ones.

Read More
A small stream of beans between two wooden bowls with most beans remaining in the first.

Incremental Loads: Moving Only What Changed

July 8, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, Data Warehousing, Database, ETL

Design an incremental load with reliable boundaries, retained change information, delete handling, and a watermark that advances only after success.

Read More
Two loose blue ceramic beads beside six woven pads holding differently colored beads and pebbles.

CROSS JOIN: Duplicate Inputs Multiply the Result

June 28, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Server

CROSS JOIN multiplies row counts, including repeated labels. Keep source identifiers and grouped pair counts visible while checking result grain.

Read More
Previous 1 … 26 27 28 29 30 31 32 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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