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
Three mushroom drying strings holding many recent and fewer selected older slices

Grandfather-Father-Son Retention: Choosing Which Backups to Keep

January 21, 2013
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server

Which backups survive when you keep three days, two weeks and two months? A small query answers it, and then you check the real files.

Read More
SQL SERVER - A List of Various SQL Server RTM and Service Pack Number

SQL SERVER – A List of Various SQL Server RTM and Service Pack Number

January 18, 2013
Pinal Dave
SQL Tips and Tricks
Database, SQL Scripts, SQL Server, SQL Service Pack

Which SQL Server version are you running, and is it the latest? My list of RTM and Service Pack Number values to check your production server against.

Read More
SQL SERVER - An Interesting Case of Redundant Indexes - Index on Col1, Col2 and Index on Col1, Col2, Col3 - Part 4

SQL SERVER – An Interesting Case of Redundant Indexes – Index on Col1, Col2 and Index on Col1, Col2, Col3 – Part 4

January 17, 2013
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts

A recap of this case of redundant indexes, from Jon and Mike’s basics to the demos where redundant indexes are useful with small and large result sets.

Read More
SQL SERVER - Introduction of Showplan Warning

SQL SERVER – Introduction of Showplan Warning

January 15, 2013
Pinal Dave
SQL Performance
Execution Plan, SQL Scripts, SQL Server

SQL Server can be your performance tuning teacher. Vinod Kumar explains the Showplan Warning in execution plans and what each warning is telling you.

Read More
Gouache painting: a wooden crate riding on a long luggage trolley through three open stone archways in a row, a small vermilion luggage tag tied to the crate's rope handle

CONTEXT_INFO: Passing a Value Through a Session

January 14, 2013
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Scripts, SQL Trigger

CONTEXT_INFO lets you attach a small value to a session and read it anywhere in that session, even inside a trigger. This post tests SET CONTEXT_INFO on SQL Server 2025, uses it to log who changed a price, and compares it with SESSION_CONTEXT.

Read More
A screwdriver with a red bit in its handle beside an open case of spare bits.

SQLCMD Mode in SSMS: Variables, :CONNECT and :r Includes

January 12, 2013
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Management Studio, sqlcmd

Use SQLCMD mode in SSMS for server and database variables, :CONNECT, :r include files, and an error-stop release script.

Read More
A row of small snowmen along a snowy path, each wearing the same red scarf

Running a Command in Every Database Without sp_MSforeachdb

January 5, 2013
Pinal Dave
SQL Tips and Tricks
DBA, Dynamic SQL, SQL Scripts, SQL Server

Run a checked command in every database with a FAST_FORWARD cursor, AG role filter, QUOTENAME, and per-database error log.

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

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