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 spring balancer supporting a linked guide between two fabric rolls

DATE_CORRELATION_OPTIMIZATION: Helping Joins on Related Dates

June 12, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Joins, SQL Server

SQL Server can learn that an order date and a ship date move together. Here is a small demo of the read savings and the trade you accept.

Read More
A hand dropping bolts through a brass ring gauge, one oversized bolt caught on the rim

Linting T-SQL: Rules Worth Automating in a Build

June 4, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, DevOps, SQL Coding Standards, SQL Server

Use linting T-SQL to flag repeatable code risks, review catalog-based candidates, and automate confirmed rules without false certainty.

Read More
A fastened linen cuff beside a loose matching cufflink with its hinged bar open

ENCRYPTBYPASSPHRASE: Simple Encryption and Its Weak Spot

April 27, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Server, SQL Server Encryption

One function in, one function out, and then the real question: where does the passphrase live? A short tour with demos you can run.

Read More
A brass umbrella stand of identical cream umbrellas, one marked only by a small red tassel.

The sp_ Prefix: Finding Stored Procedures Named the Risky Way

January 11, 2018
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Coding Standards, SQL Server, SQL Stored Procedure

Find user procedures with the sp_ prefix across databases, understand the lookup risk, and move callers through a synonym safely.

Read More
A small wooden drawer rests beside a larger matching drawer in a sunlit workshop.

Moving From Express to Standard Without Reinstalling

December 22, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Server, SQL Server Installation

Plan how to upgrade SQL Server edition from Express to Standard, preserve the instance, and verify databases and applications after setup.

Read More
Loose cords entering a cable comb and leaving with consistent spacing

Collapsing Repeated Spaces and Line Breaks With REGEXP_REPLACE

November 29, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, Command Line, SQL Server

Tabs, line breaks and a sneaky character 160 can all hide in a name that looks fine. Here is how to clean them on purpose.

Read More
An active lucet making cord beside an idle lucet with its feed yarn knotted

CPU-Bound Queries: Comparing worker_time to elapsed_time

October 26, 2017
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL CPU, SQL Server

Is a slow query working or waiting? Compare its two clocks and you will know what to fix before anyone buys more CPU.

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

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