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
Differential backups flowchart.

SQL SERVER – Msg 3136, Level 16 – This Differential Backup Cannot be Restored Because the Database has not Been Restored to the Correct Earlier State

April 5, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server

I was trying to teach copy-only backups to my students and encountered below error related to differential backup.

Read More
Seven wooden measuring spoons arranged by size with the middle spoon highlighted

How to Find Median in SQL Server? – Interview Question of the Week #116

April 2, 2017
Pinal Dave
SQL Interview Questions and Answers
Ranking Functions, SQL Scripts, SQL Server

There is no MEDIAN function in T-SQL. Here is an easy way to find median values in SQL Server 2012 and later, plus what median really means.

Read More
A padlocked iron gate across a loading bay lit by one amber wall lamp

SQL SERVER – Error 33222, Level 16 – Audit ‘MyAudit’ Failed to Start

March 31, 2017
Pinal Dave
SQL Tips and Tricks
SQL Audit, SQL Error Messages, SQL Scripts, SQL Server

Error 33222 says only that the audit failed to start. Reproduced on SQL Server 2025: where the real reason hides, and why CREATE succeeded.

Read More
SQL SERVER - Huge Size of Table catalog.execution_component_phases in SSISDB

SQL SERVER – Huge Size of Table catalog.execution_component_phases in SSISDB

March 28, 2017
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SSIS

SSISDB was huge, and the biggest table was catalog.execution_component_phases. Here is what fills it, like retention period and logging level.

Read More
Gouache painting of two nearly identical jigsaw puzzle pieces on a table that look alike but do not interlock, one cream and one vermilion

Error 468: Could Not Use View sysdac_instances Because of Binding Errors

March 25, 2017
Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Error Messages, SQL Scripts, System Database

Error 468 appeared as soon as we right clicked a database in SQL Server Management Studio. The view msdb.dbo.sysdac_instances could not be used because of binding errors. A collation mismatch between master and msdb caused it, and rebuilding the system databases fixed it.

Read More
Results window showing SELECT * FROM MyTable.

SQL SERVER – Jump in Identity Column After Restart

March 24, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Identity, SQL Scripts, SQL Server, SQL Server Configuration, TraceFlags

A change in SQL Server 2012 can cause a jump in identity column values after a restart. Here are the steps to reproduce it and what you can do about it.

Read More
Gouache painting of a worker moving blocks beside a temporary storage tank with a colored space gauge

Work Table Page Could Not Be Moved: DBCC SHRINKFILE on TempDB

March 21, 2017
Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Scripts, SQL Server DBCC, SQL TempDB

A work table page can stop DBCC SHRINKFILE from reaching the size you asked for in tempdb. This post shows tested queries that compare configured and current file sizes, split tempdb space by object type and find the sessions that hold it. The original client case needed a planned restart to reset the file sizes.

Read More
Previous 1 … 130 131 132 133 134 135 136 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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