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
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
A walker seen from behind pauses where a woodland footpath splits into a narrow path and a wider one.

GDR or CU: Choosing Your Update Branch

June 14, 2014
Pinal Dave
SQL Tips and Tricks
Cumulative Update, DBA, SQL Patch, SQL Server, SQL Server Security

Choose GDR or CU for SQL Server by understanding security and cumulative branches, checking the exact build, and testing a branch change.

Read More
SQL Server Agent Scan Settings.

SQL SERVER – How to Get SQL Server Restart Notification?

June 13, 2014
Pinal Dave
SQL Tips and Tricks
SQL Utility

Want a restart notification when SQL Server starts, without buying a tool? Here are the steps to run a stored procedure at startup.

Read More
Sql server high availability options table.

SQL SERVER – SQL Server High Availability Options – Notes from the Field #032

June 12, 2014
Pinal Dave
SQL Performance
Notes from the Field, Shrinking Database

Not sure which of the High Availability options fits your organization? Tim Radney explains the SQL Server choices in very simple words.

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
A hand holding an egg over a small lamp in a dim pantry, the shell glowing, a basket of eggs beside it.

BACKUP WITH CHECKSUM: What It Checks and What It Cannot

June 10, 2014
Pinal Dave
SQL Tips and Tricks
Database Corruption, DBA, SQL Backup and Restore, SQL Server DBCC

Use WITH CHECKSUM for backups, inspect checksum history, verify backup media, and understand why restored CHECKDB tests are still needed.

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
Padded sleeve board supporting a jacket sleeve beside an unsupported sleeve

Column Aliases: Where You Can Use Them and Where You Cannot

June 8, 2014
Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Column, SQL Order By

Why does WHERE say the alias does not exist? Here is the order SQL Server follows, two clean fixes and one quiet trap to avoid.

Read More
MySQL - Introduction to CONCAT and CONCAT_WS functions

MySQL – Introduction to CONCAT and CONCAT_WS functions

June 7, 2014
Pinal Dave
SQL Tips and Tricks
MySQL

MySQL has two concatenation functions, CONCAT and CONCAT_WS. I show how each one works and why CONCAT_WS makes adding a separator easier.

Read More
Previous 1 … 299 300 301 302 303 304 305 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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