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 selected compartmented drawer is inspected with a brass measuring tool while other drawers stay closed.

SQL Server – How to Get Column Names From a Specific Table?

June 29, 2017
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL System Table

I get column names from schema-qualified table metadata. Catalog views help when I also need SQL Server-specific details.

Read More
SQL SERVER - Puzzle - Incorrect Results with Decimal

SQL SERVER – Puzzle – Incorrect Results with Decimal

June 28, 2017
Pinal Dave
SQL Puzzle
SQL Datatype, SQL Function, SQL Scripts, SQL Server

A new puzzle: a simple table with price and discount returns Incorrect Results with DECIMAL. Can you work out why without running the code in SSMS?

Read More
SQL SERVER - FIX: Msg 3009, Level 16 - Could not Insert a Backup or Restore History Detail Record in the msdb Database

SQL SERVER – FIX: Msg 3009, Level 16 – Could not Insert a Backup or Restore History Detail Record in the msdb Database

June 26, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server

A slow restore that my client cancelled led to Msg 3009: could not insert a backup or restore history record in msdb. Here is what I learned about a trace flag.

Read More
Two connected trunks remain linked while a separate satchel sits apart

What is Copy Only Backup in SQL Server? – Interview Question of the Week #128

June 25, 2017
Pinal Dave
SQL Interview Questions and Answers
SQL Backup and Restore, SQL Function, SQL Scripts, SQL Server

Copy Only Backup is an independent backup that does not break the LSN chain or disturb your regular backup plan. Here is the short answer and a longer one.

Read More
Change job owner.

SQL SERVER – FIX: Msg 15170, Level 16, This login is the Owner of 1 Job(s). You Must Delete or Reassign these Jobs Before the Login can be Dropped

June 21, 2017
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Scripts, SQL Server, SQL Server Security

Msg 15170: this login is the owner of 1 job(s) and cannot be dropped. Here is how to find those jobs and reassign them first.

Read More
A man in red shoes falling.

SQL SERVER – Upgrade Failure – The Cluster Resource is Not Online. Bring the Analysis Services Server Online Before Starting the Upgrade Process

June 20, 2017
Pinal Dave
SQL Tips and Tricks
SQL Analysis Services, SQL Error Messages, SQL Scripts, SQL Server, Starting SQL

Upgrade and one need to evaluate them before making a final choice. Let us see an error related to Upgrade Failure. Let us learn today.

Read More
Intact archive cases are set aside for inspection while the retained collection remains secure.

SQL SERVER – Previewing Old Azure Backup Blobs Before Removal with PowerShell

June 19, 2017
Pinal Dave
SQL Tips and Tricks
PowerShell, SQL Azure, SQL Data Storage, SQL Scripts, SQL Server

Backup Files From Azure Storage need a retention review before removal. I list the candidates before approving any cleanup.

Read More
Previous 1 … 124 125 126 127 128 129 130 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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