March 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
dbcc reindex

What is the Replacement of DBCC DBREINDEX? – Interview Question of the Week #263

February 9, 2020
Pinal Dave
Personal
Maintenance Plan, SQL Index, SQL Scripts, SQL Server, SQL Server DBCC

Question: What is the Replacement of DBCC DBREINDEX?

Answer: The answer to this question is very simple.

Here is the syntax:

Read More
slow query

SQL SERVER – 5 Important Steps When Query Runs Slow Occasionally

September 7, 2019
Pinal Dave
SQL Performance
Maintenance Plan, SQL FileGroup, SQL Scripts, SQL Server, SQL Server Configuration, SQL Stored Procedure, SQL TempDB, SQL Wait Stats, SSMS

This was a very interesting situation and at the end of we had found the culprit for the slow query and resolved it. Today we will discuss the experience.

Read More
DBCC DBREINDEX

SQL SERVER – Stop Using DBCC DBREINDEX and Use ALTER INDEX

August 26, 2019
Pinal Dave
SQL Performance
Maintenance Plan, SQL Index, SQL Scripts, SQL Server, SQL Server DBCC

It has been over a decade since the comment DBCC DBREINDEX has been deprecated, however, once in a while I still encounter them while working with clients.

Read More

Do Index Reorganization Update Statistics? – Interview Question of the Week #196

October 21, 2018
Pinal Dave
SQL Interview Questions and Answers
Maintenance Plan, SQL Index, SQL Performance, SQL Scripts, SQL Server, SQL Statistics

Question: Do Index Reorganization Update Statistics?

Answer: No. Index Reorganization does not update Statistics of your database.

Read More

SQL SERVER – Unable to Run Maintenance Plan. Error: Integration Services Evaluation Period has Expired

June 6, 2018
Pinal Dave
SQL
Maintenance Plan, SQL Error Messages, SQL Server, SSIS

A few days ago, one of my clients contacted me to fix an error which they were getting while using maintenance plan – Integration Services evaluation period has expired. Here is the complete error message which was taken from job history.

Read More

SQL SERVER – The SaveToSQLServer Method Has Encountered OLE DB Error Code 0x80004005

December 27, 2017
Pinal Dave
SQL
Computer Network, Maintenance Plan, SQL Error Messages, SQL Server

While saving maintenance plan on my lab server, I encountered below error in SQL Server Management Studio. Let us see how to solve the error related to OLE DB Error. 

Read More

SQL SERVER – Execution Failed. See the Maintenance Plan and SQL Server Agent Job History Logs for Details

December 1, 2017
Pinal Dave
SQL
Maintenance Plan, SQL Error Messages, SQL Server

While doing my consulting, I created a maintenance plan for my client to take full and log backups on a regular basis. The client was a little impatient, and he wanted to test everything before I get off the call. So, they tried to execute the maintenance plan which I created. It failed like below

Read More
1 2 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

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

Go to mobile version