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
Gouache painting of a jammed grain chute in a barn with sacks piled high and the top sack in vermilion

sysxmitqueue in msdb: Why It Grows and How to Clear It

July 6, 2019
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Scripts, SQL Server, System Database

Sysxmitqueue in msdb fills up when Service Broker messages cannot leave the server. A tested demo in its own database shows the pile, the reason, a one conversation cleanup and the NEW_BROKER reset. The msdb steps follow the same order.

Read More
Gouache painting of key-marked folders copied between database cabinets with a duplicate-key warning

SQL SERVER – DBCC CLONEDATABASE Error: Cannot Insert Duplicate Key Row In Object ‘sys.sysschobjs’ With Unique Index ‘clst’.

July 4, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, SQL Server DBCC, SQL System Table, System Database, System Object

Investigate a DBCC CLONEDATABASE sys.sysschobjs error with supported catalog checks, original screenshots and a distinct build-specific fix.

Read More
Gouache painting of a sand timer with vermilion sand between two trays of pears on a wooden table

CHECKPOINT Impact on Memory: Watch Dirty Pages Go to Zero

July 3, 2019
Pinal Dave
SQL Performance
SQL DMV, SQL Memory, SQL Scripts

CHECKPOINT impact on memory is easy to measure. This post counts the dirty and clean pages of one database before and after a checkpoint. Dirty pages drop to zero, the clean pages grow by the same amount, and nothing leaves memory.

Read More
Two bowls hold equal groups of qualifying red beads while green beads remain outside

What is Faster, SUM or COUNT? – Interview Question of the Week #231

June 30, 2019
Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Performance, SQL Scripts, SQL Server

Question: What is Faster, SUM or COUNT? Answer: Both are the same. I was asked this question during my Comprehensive Database Performance Health Check.

Read More
Gouache painting of a wooden seedling tray with rows of small green sprouts and one empty cell holding a single vermilion seed

Transient Error in Automatic Seeding: Availability Database Failed to Seed

June 29, 2019
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Error Messages, SQL High Availability, SQL Scripts

A transient error stopped automatic seeding of an availability database. The ERRORLOG on the secondary showed Msg 4353 about conflicting file relocations. Renaming a logical file let the database seed.

Read More
Gouache painting of two matching picnic baskets, one full and one nearly empty in vermilion

COPY_ONLY Full Backup Size: What Differs Between Always On Replicas

June 27, 2019
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Backup and Restore, SQL High Availability, SQL Scripts

A COPY_ONLY full backup of the same database can have a different size on the primary and the secondary replica of an Always On group. This post reads the log pages in the backup messages, shows them on a standalone database and explains how to compare backups fairly. It also covers what a restore needs.

Read More
Gouache painting of a swept doormat with a pile of old brass keys aside and one vermilion key in the middle

DBCC FLUSHAUTHCACHE: Force Azure SQL to Re-authenticate

June 25, 2019
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Login, SQL Scripts, SQL Server Security

DBCC FLUSHAUTHCACHE clears the authentication cache of an Azure SQL database, so open connections must authenticate again. This post shows what a password change does to open sessions on SQL Server, why Azure SQL needs the extra command and how to list the sessions you want to end. It also covers the cautions that matter.

Read More
Previous 1 … 70 71 72 73 74 75 76 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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