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 glass-bottomed viewing bucket in a shallow sea, showing clear stones and a red crab beneath

SQL SERVER – Full-Text Search Not Working For PDF Documents

February 12, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Search, SQL Server

A client stored PDF files in a VARBINARY(MAX) column, and Full-Text search could not find text in them. Here are all the steps I used in my lab to make it work.

Read More
SQL SERVER - What is Change Pending State of in SQL Server Configuration Manager?

SQL SERVER – What is Change Pending State of in SQL Server Configuration Manager?

February 9, 2018
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Services

During a rushed release, a client stopped SQL Server and the service got stuck. Here is what Change Pending State in Configuration Manager means and what to do.

Read More
SQL SERVER - Create Catalog Error 911: Database 'SSISDB' Does Not Exist. Make Sure That he name is entered correctly

SQL SERVER – Create Catalog Error 911: Database ‘SSISDB’ Does Not Exist. Make Sure That he name is entered correctly

February 6, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Profiler, SQL Scripts, SQL Server

Doing create catalog in SSMS failed with Error 911: database SSISDB does not exist. Here is how SQL Server Profiler showed me the real cause.

Read More
A row of vessels with equal fill heights grouped across a selection boundary

How Does TOP WITH TIES Work in SQL Server? – Interview Question of the Week #159

February 4, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Function, SQL Order By, SQL Scripts, SQL Server

Question: How Does TOP WITH TIES Work in SQL Server?

Answer: This is an ancient question I just encountered in the recent Comprehensive Database Performance Health Check.

Read More
Backup database to disk error.

SQL SERVER – FIX: Msg 3009 – Could Not Insert a Backup or Restore History Detail Record in the MSDB Database

February 1, 2018
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server, SQL System Table, System Database, TraceFlags

A backup finished but raised Msg 3009: could not insert a backup or restore history detail record in msdb. Here is why, with steps to reproduce it.

Read More
Msg 0, Level 11, State 0, Line 10.

SQL SERVER – Incorrect Error: Unable to Add Filegroup – A Severe Error Occurred on the Current Command

January 31, 2018
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Error Messages, SQL Scripts, SQL Server

A client with a huge partitioned database could not add filegroup and got Msg 0, a severe error. Here is how we found the real, much deeper issue.

Read More
Error dialog of query execution.

SQL SERVER – Puzzle – Strange Behavior With Extra Comma in Create Table Statement

January 30, 2018
Pinal Dave
SQL Puzzle
SQL Command, SQL Scripts, SQL Server, SQL Table Operation

My favorite icebreaker puzzle: a strange behavior with an extra comma in CREATE TABLE statement. Why does SQL Server accept it for temp and regular tables?

Read More
Previous 1 … 105 106 107 108 109 110 111 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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