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
Hands digging through a huge bin of mixed balls for the red ones, an empty sorted rack standing unused

Foreign Keys Without Indexes: Finding and Fixing Slow Deletes

July 9, 2014
Pinal Dave
SQL Performance
SQL Constraint and Keys, SQL Delete, SQL Index, SQL Performance

Find foreign keys without indexes, inspect parent-delete plans, and choose leading child-table keys that support relationship checks.

Read More
A hand lowering a record player's needle just before a scratch on a spinning record with a red center

Point-in-Time Restore: Getting Back Rows Deleted by Accident

June 9, 2014
Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Delete, Transaction Log

Plan a point-in-time restore after an accidental DELETE, preserve the log chain, recover a separate copy, and return reviewed rows.

Read More
A hand lifts the top glass from a pyramid of stacked glasses, a red napkin at its base.

Walking Foreign Key Chains to Find a Safe Delete Order

November 3, 2012
Pinal Dave
SQL Tips and Tricks
CTE, SQL Constraint and Keys, SQL Delete, SQL Server

Map foreign key chains from a parent table with a recursive catalog query, then list deepest children first and flag cascade rules.

Read More
Previous 1 2
  • Books
  • Testimonials
  • Privacy Policy

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