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 divided card storage with reserved gaps beside a channel feeding in additional cards.

Change Fill Factor in SQL Server: SQL in Sixty Seconds #069

June 18, 2014
Pinal Dave
SQL Video
SQL Data Storage, SQL in Sixty Seconds, SQL Index, SQL Scripts

To change fill factor for an index, rebuild it with a new FILLFACTOR value. The tests here measure what 100, 80 and 50 do to page count, scan reads and page splits, and when a lower value is not worth the space.

Read More
Two lakeside cabins built from one plan, one with an added porch and a missing window, one red door

Comparing Two Schemas With sys.columns and a FULL OUTER JOIN

June 16, 2014
Pinal Dave
SQL Tips and Tricks
Schema, SQL Joins, SQL Scripts, SQL System Table

Use read-only queries for comparing two schemas, finding missing columns, checking type details, and reviewing indexes and modules.

Read More
Two cream tickets with matching red circles sit beside one blue parcel in a wooden compartment.

SQL Server: Why Retrying an INSERT Can Create Duplicate Rows

June 15, 2014
Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Scripts, SQL Server

Retrying an INSERT can create duplicate rows even with an identity primary key. These tested examples use a stable request ID to return the original order, reject changed inputs, and preserve unrelated errors.

Read More
Gouache painting of two small trains on parallel tracks with one uncoupled red wagon waiting between them

Attach a Database in SQL Server and Detach It Safely

June 11, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Deprecated Feature, SQL Scripts

To attach a database, use CREATE DATABASE with FOR ATTACH and point it at the data and log files. This post detaches a demo database, attaches it again, shows the error that stops a detach, and compares the old sp_attach_db procedure with the current statement.

Read More
SQL SERVER - Planned and Unplanned Availablity Group Failovers - Notes from the Field #031

SQL SERVER – Planned and Unplanned Availability Group Failovers – Notes from the Field #031

June 5, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL High Availability, SQL Scripts, SQL Server

In Notes from the Field #031, John Sterrett explains Planned and Unplanned Availability Group failovers in AlwaysOn, a topic that confuses many DBAs.

Read More
Gouache painting of a wooden library card catalog with one long drawer pulled open, its cards standing in neat order, one tab in vermilion

Explain a SQL Server Index in Sixty Seconds, Then Prove It

June 4, 2014
Pinal Dave
SQL Interview Questions and Answers
SQL Index, SQL Performance, SQL Scripts

How to explain a SQL Server index in an interview in about a minute, then prove every word with one table. On SQL Server 2025, the same query read 5,737 pages with no index, 133 with a plain index and 3 with a covering index. Three extra indexes doubled the log of 20,000 inserts.

Read More
A hand taking one plate from a spare boxed set to fill the single empty slot in a kitchen plate rack.

Restoring One Table: Restore a Copy and Move the Rows Back

June 3, 2014
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Scripts, SQL Server

Learn restoring one table by restoring a separate database copy, choosing a recovery point, and safely moving reviewed rows back.

Read More
Previous 1 … 174 175 176 177 178 179 180 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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