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
Four ants carrying crumbs, the last one far behind under a huge red crumb

Uneven Parallelism: Spotting Skewed Threads Behind CXPACKET Waits

December 15, 2012
Pinal Dave
SQL Performance
Execution Plan, MAXDOP, Parallel, SQL Wait Stats

Diagnose uneven parallelism by comparing CXPACKET and CXCONSUMER with per-thread row counts in plans and live query profiles.

Read More
A hand holding a bunch of grass stems by a campfire, one short stem with a red tip just drawn out

Picking Random Winners Fairly With NEWID and CRYPT_GEN_RANDOM

December 14, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Random, SQL Server, SQL Transactions

Pick random winners with NEWID or cryptographic randomness, handle weights and unique entrants, and save a draw with its seed and timestamp.

Read More
Shoppers walking toward a red-awninged market stall in its new spot

Moving Databases to a New Server Behind a SQL Server Alias

December 13, 2012
Pinal Dave
SQL Tips and Tricks
DBA, SQL Connection, SQL Migration, SQL Server Configuration

Move databases behind a SQL Server alias or DNS CNAME by planning name redirection, backup and restore, Kerberos SPNs, and connection tests.

Read More
Gouache painting of a wooden ticket inspection station checking outer shape and matching slots in two separate stages.

Validate a Date With Regex in SQL Server 2025: Shape Is Not Enough

December 12, 2012
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Server, SQL String

To validate a date with regex in SQL Server 2025, pair REGEXP_LIKE with TRY_CONVERT. The tests here show impossible dates that pass a strict pattern, spellings that convert but break the format, and how to enforce both checks with a constraint.

Read More
Update and Timestamp Tool Window.

SQL SERVER – Asynchronous Update and Timestamp – Check if Row Values are Changed Since Last Retrieve

December 11, 2012
Pinal Dave
SQL Tips and Tricks

In a bidding system, users must know if a row changed since they read it. Here is how a timestamp column helps with this asynchronous update check.

Read More
A ringing brass alarm clock on a bedside table beside a neatly made, empty bed and untouched slippers.

SQL Server Agent Basics

December 10, 2012
Pinal Dave
SQL Tips and Tricks
DBA, SQL Scripts, SQL Server, SQL Server Agent

SQL Server Agent basics covers jobs, steps, schedules, proxies, and history so a first useful job runs with a clear owner and failure path.

Read More
SQL Authority News - Download SQL Server Data Type Conversion Chart

SQL Authority News – Download SQL Server Data Type Conversion Chart

December 9, 2012
Pinal Dave
SQL Tips and Tricks
SQL Download

Implicit or explicit? Download the SQL Server data type conversion chart to see which conversions happen on their own and which need CAST or CONVERT.

Read More
A row of wooden toy animals with the repeats set aside in a basket below.

Removing Repeated Characters From a String With GENERATE_SERIES

December 8, 2012
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Server, SQL Server 2022, SQL String

Remove repeated characters with GENERATE_SERIES, ROW_NUMBER, and ordered STRING_AGG, then benchmark a SQL Server 2019 fallback.

Read More
Gouache painting: a round wooden storehouse lined with a ring of grain bins, every bin empty and swept ready to refill except one whose small door is held shut by a vermilion latch

log_reuse_wait_desc: Why the Transaction Log Will Not Shrink

December 7, 2012
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Server DBCC, SQL Transactions, Transaction Log

log_reuse_wait_desc tells you why SQL Server cannot reuse its transaction log, so you know why a shrink gives nothing back. This post causes LOG_BACKUP and ACTIVE_TRANSACTION on purpose in a test database on SQL Server 2025, measures the log and fixes each one.

Read More
A wall key rack with five keys, two empty hooks and one hook tied with a red ribbon

A Calendar Table With Holidays for Date Math

December 6, 2012
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server

Build a calendar table with weekdays, fiscal months, and American holiday flags, then count working days and find useful date boundaries.

Read More
Previous 1 … 356 357 358 359 360 361 362 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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