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 worn footpath cutting diagonally across a park lawn between two paved paths, a distant figure walking on it.

SSMS Keyboard Shortcuts Worth Learning

February 2, 2014
Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Server, SQL Server Management Studio, SQL Shortcut

SSMS keyboard shortcuts for execution, comments, results, and Object Explorer remove repeated clicks while keeping query context visible.

Read More
Could not drop object dialog.

MYSQL – Could not Drop Object [Content] (‘Cannot delete or update a parent row: a foreign key constraint fails’, 1217) DROP DATABASE DatabaseName

February 1, 2014
Pinal Dave
SQL Tips and Tricks
MySQL, SQL Error Messages

Cannot drop a MySQL table or database because a foreign key constraint fails with error 1217? Turn off FOREIGN_KEY_CHECKS, drop it, then turn checks back on.

Read More
A hand pressing a crossing button again, its small red wait lamp already glowing, a bicycle at the curb

Idempotent Deployment Scripts: Safe to Run Twice

January 31, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, DevOps, SQL Scripts, SQL Server, SQL Transactions

Build idempotent deployment scripts with guarded schema changes, versioned data fixes, and repeat-run checks for the intended state.

Read More
SQL SERVER - Virtualized SQL Server Performance and Storage System - Notes from the Field #013

SQL SERVER – Virtualized SQL Server Performance and Storage System – Notes from the Field #013

January 30, 2014
Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server, Virtualization

Tuned everything in a VM and still slow? In Notes from the Field #013, David Klee explains Virtualized SQL Server Performance and the storage behind it.

Read More
Two pearl strands side by side on velvet, matched bead for bead, one pearl in the second strand a warmer shade.

Comparing Data Between Two Tables

January 29, 2014
Pinal Dave
SQL Tips and Tricks
Duplicate Records, SQL Joins, SQL NULL, SQL Scripts, SQL Server

Comparing data between two tables uses EXCEPT, full joins, and hashes, with explicit NULL and duplicate rules for trustworthy results.

Read More
A finger pressing an already glowing lift call button a second time beside a closed brass lift door.

Stopping Duplicate API Requests With an Idempotency Key Table

January 28, 2014
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Constraint and Keys, SQL Server, SQL Transactions

Store an idempotency key with its order in one transaction, return the committed result on retries, and define key reuse and expiry rules.

Read More
Four irons heating beside one small handkerchief on an ironing board, a hand unplugging the spare ones.

DOP Feedback: Letting SQL Server Lower Parallelism by Itself

January 27, 2014
Pinal Dave
SQL Performance
MAXDOP, Parallel, Query Store, SQL Performance, SQL Server 2022

Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.

Read More
EXEC sys.sp_rename 'old_name', 'new_name' WITH OLD_NAME.

SQL SERVER – Rename a Table Name Containing [ or ] Identifier in the Name – Part 2

January 26, 2014
Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio

Part 2 shows another way to rename a table name that contains [ or ] identifiers, after sp_rename fails with a Msg 15253 syntax error.

Read More
SQL SERVER - Rename a Table Name Containing [ or ] in the Name - Identifier in the Table Name

SQL SERVER – Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name

January 25, 2014
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server Management Studio

My colleague renamed a table to [] by accident and sp_rename failed. Here is how to rename a table name containing [ or ] characters.

Read More
Matching brass iris rings have wide and narrow openings with different light patches behind them

Case-Insensitive and Multiline Regex Flags in SQL Server 2025

January 24, 2014
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL String, Testing

Your pattern passed the test string and then missed rows in the table. The flags and the line endings are the usual reason.

Read More
Previous 1 … 313 314 315 316 317 318 319 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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