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 plain balance scale with two small wooden blocks on a softly lit wooden worktable.

How to Evaluate a New Database Without Fooling Yourself

September 2, 2012
Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server

Use realistic data and workload tests to evaluate a database, checking correctness, latency, recovery, compatibility, and the full operating cost.

Read More
Gouache painting of three streams of paper cards merging through wooden channels into an organized output tray.

Insert Multiple Rows in SQL Server: SQL in Sixty Seconds #024

August 29, 2012
Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Scripts, SQL Table Operation, SQL Transactions

To insert multiple rows in SQL Server, use separate INSERT statements, UNION ALL or one VALUES list. The tests here compare all three on SQL Server 2025, including failures, the 1,000 row limit and the time for 1,000 rows.

Read More
SQL SERVER - A Brief Note on SET TEXTSIZE

SQL SERVER – A Brief Note on SET TEXTSIZE

August 28, 2012
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Configuration

Is there any difference between the LEFT function and SET TEXTSIZE? A quick script shows how each one trims a long VARCHAR(MAX) value in the results.

Read More
A blank clipboard and small hourglass sit beside neatly arranged tools on a workbench.

What to Collect When SQL Server Is Slow

August 26, 2012
Pinal Dave
SQL Performance
Best Practices, Database, SQL Scripts, SQL Server

Collect SQL Server diagnostic data in a useful order: waits, active requests, blockers, execution plans, and file IO during the slow period.

Read More
Gouache painting of a tray of mixed buttons on a sewing table, with a few matching vermilion buttons set apart in a small dish.

REGEXP_COUNT in SQL Server 2025: Counting Pattern Matches in Text

August 25, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

REGEXP_COUNT counts how many times a pattern matches inside a text value, a job that used to need LEN and REPLACE tricks. This post tests it on SQL Server 2025: start position, flags, NULL and empty text, a data quality check, and where the old trick still fits.

Read More
A row of identical hooks on a wall, each carrying a different coloured enamel tag.

SQL SERVER – Color Coding SQL Server Management Studio Status Bar – SQL in Sixty Seconds #023 – Video

August 22, 2012
Pinal Dave
SQL Video
Database, SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Server Management Studio

Color code the SQL Server Management Studio status bar so you always know which server you are on before you run a script. A quick video.

Read More
Two clean leather shoes beside a dusty shoe being brushed

Non-Updating Updates: Skipping Rows That Would Not Change

August 21, 2012
Pinal Dave
SQL Tips and Tricks
DBA, SQL Scripts, SQL Server

An UPDATE that writes the same value still marks the row as modified. I show how IS DISTINCT FROM skips those rows and keeps NULL changes.

Read More
Previous 1 … 200 201 202 203 204 205 206 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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