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: two wooden ladders leaning on one orchard wall, a short one beside a tall one with identical lower rungs, one vermilion rung on the short ladder

Redundant Indexes: Index on Col1, Col2 vs Col1, Col2, Col3

January 4, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL DMV, SQL Index, SQL Scripts

Redundant indexes cost space and slow every write, but not every one can go. This post measures an index on Col1, Col2 next to an index on Col1, Col2, Col3 on SQL Server 2025: size, plan, reads and log bytes. It ends with a safe way to remove one.

Read More
SQL SERVER - Creating Database with Different Collation on Server

SQL SERVER – Creating Database with Different Collation on Server

December 27, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server

A client ran two instances on every server just for case sensitivity. Here is how to create a database with a different collation on the same server instead.

Read More
Gouache painting of a finished blue vase beside an identical twin packed safely in a crate with red cloth

Take a Database Backup in SSMS: Step by Step

December 26, 2012
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server Management Studio

To take a database backup in SSMS, right-click the database, choose Tasks, then Back Up, and pick the backup type. This post walks through the dialog, shows the T-SQL that does the same work, explains the log backup error people meet first, and checks the files afterwards.

Read More
A combined glass-cutting tool beside separate scoring and breaking tools

MERGE Performance for Large Upserts: UPDATE Then INSERT Instead

December 21, 2012
Pinal Dave
SQL Performance
SQL Performance, SQL Scripts, SQL Server

Is MERGE really slow, or did the rewrite just run on a quiet night? Here is a fair test you can run yourself.

Read More
A knitted cardigan buttoned neatly, a hand at the hem showing every button is one hole off.

Writing T-SQL With an AI Assistant: What to Check Before You Run It

December 17, 2012
Pinal Dave
SQL Tips and Tricks
AI, Best Practices, SQL Scripts, SQL Server

Review T-SQL from an AI assistant for real columns, safe writes, index access, date boundaries, isolation, and rollback tests.

Read More
A ringing brass alarm clock on a bedside table beside a neatly made, empty bed and untouched slippers.

SQL Server Agent Basics

December 10, 2012
Pinal Dave
SQL Tips and Tricks
DBA, SQL Scripts, SQL Server, SQL Server Agent

SQL Server Agent basics covers jobs, steps, schedules, proxies, and history so a first useful job runs with a clear owner and failure path.

Read More
A wall key rack with five keys, two empty hooks and one hook tied with a red ribbon

A Calendar Table With Holidays for Date Math

December 6, 2012
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

Build a calendar table with weekdays, fiscal months, and American holiday flags, then count working days and find useful date boundaries.

Read More
Previous 1 … 194 195 196 197 198 199 200 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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