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
Leather beveler applying a repeated trim to one selected edge

Find and Replace With Regular Expressions in SSMS

August 3, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

A regex replace can turn forty column names into ISNULL expressions in seconds. Here is the pattern, the safety habits, and the trap of a zero default.

Read More
Added felt layer spreading tightly packed padding above an intact bed spring

The Row Version Tag: Page Splits After Turning On RCSI

July 11, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Turn on RCSI and every row you update gets a little bigger. On packed pages that means page splits, and I show the numbers on a small demo table.

Read More
An unfinished wooden model bridge and separate approach piece sit on a sunlit workbench.

What You May and May Not Do With SQL Server Developer Edition

June 1, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Understand Developer Edition rights, identify the installed SQL Server edition, and keep shared test systems separate from production work.

Read More
Two small glass jars with uneven amounts of beans beside a short row of scattered beans.

Generating Test Data That Behaves Like the Real Thing

March 9, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Make test data generation reflect skew, row width, missing values, and key relationships so your SQL Server experiments expose realistic plan risks.

Read More
A small closed wooden storage box beside a brass key and a plain hourglass on a table.

Automating Backups With SQL Agent and Checking They Worked

March 2, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Backup and Restore, SQL Server

Plan to automate SQL Server backup with Agent scheduling, checksum verification, tested failure notifications, and retention that preserves recovery.

Read More
A row of music stands at the same height and angle, a hand straightening the one out of line

A T-SQL Formatting Style Guide for Teams

February 24, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Coding Standards, SQL Scripts, SQL Server

Adopt a short T-SQL formatting style with clear columns, joins, aliases, semicolons and comments, and keep review focused on query behavior.

Read More
Espresso tamper beside shallow loose and compacted grounds in underfilled bowls

COMPRESS_ALL_ROW_GROUPS: Forcing Delta Rowgroups Into Columnstore

February 19, 2016
Pinal Dave
SQL Tips and Tricks
Best Practices, ColumnStore Index, SQL Server

One command turns an open delta rowgroup into compressed storage. Here is what it leaves behind, and why not to run it after every small load.

Read More
Previous 1 … 10 11 12 13 14 15 16 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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