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 person seen from behind in the doorway of an old boathouse, oars and a covered boat inside, a closed red toolbox nearby

First Queries to Run on an Unfamiliar SQL Server

October 2, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Inspect an unfamiliar SQL Server with read-only queries for version, uptime, database size, waits, backup history, and settings.

Read More
A fitted drill chuck and bit with the hand drill drive disengaged

Checking Optional Features Installed on an Instance From T-SQL

September 29, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

A 1 in SERVERPROPERTY does not mean the feature runs. Here is how I line up the flag, the setting and the service in one query.

Read More
Heavy and light tool aprons supported by suspenders with visibly different loads

Wide Covering Indexes: The Cost of INCLUDE Everything

September 7, 2018
Pinal Dave
SQL Performance
Best Practices, SQL Performance, SQL Server

Adding every column with INCLUDE feels like a free speed-up. Here is a small demo of the space, reads and writes you pay for.

Read More
A candle snuffer positioned over one lit candle among several unlit candles

Finding Hard-Coded Passwords in Stored Procedures

August 21, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Server, SQL Stored Procedure

A short regular expression can list the procedures that hide a password, without printing it. Here is the scan, its false alarms and its blind spots.

Read More
Several rows of clay discs waiting for the single working position of an arbor press

Serial Zones in Parallel Plans: Where One Thread Does the Work

July 12, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, Parallel, SQL Server

A parallel plan can still leave one core busy. See a harmless serial zone, a costly one, and how to read per-thread rows from the plan.

Read More
A capped nut driver beside several visibly connected mechanical components

Listing Server Credentials and Where They Are Used

July 6, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Credentials hide their secrets but still tell you who depends on them. Build a small demo and follow a credential to its login, proxy and job step.

Read More
Two differently colored shoes fitting the same adjustable shoe stretcher

Names That Differ Only by Case: Finding Them With COLLATE

June 20, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL CASE, SQL Server

A case-insensitive target can turn two rows into one. This walk-through finds the colliding names first, including the ones with trailing spaces.

Read More
Previous 1 … 6 7 8 9 10 11 12 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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