May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • 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

SQL SERVER – Manage Database Size with DBCC SHRINKDATABASE and WAIT_AT_LOW_PRIORITY

September 29, 2023
Pinal Dave
SQL Performance
Shrinking Database, SQL Server DBCC

In this blog post, we will explore the DBCC SHRINKDATABASE command and its options, focusing on the WAIT_AT_LOW_PRIORITY feature.

Read More
shrinklog

SQL SERVER – Reasons – Not Able to Shrink the Transaction Log

August 24, 2022
Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Log, SQL Server, System Database

Recently during consulting engagement Comprehensive Database Performance Health Check, my client asked if I knew why they could not shrink the transaction log.

Read More
Change Database

How to Change Database File Size? – Interview Question of the Week #296

October 4, 2020
Pinal Dave
SQL Interview Questions and Answers
Shrinking Database, SQL Performance, SQL Scripts, SQL Server, SQL Server DBCC

Question: How to Change Database File Size?

Answer: By Shrinking the files. Now, many have a negative opinion about Shrinkfile.

Read More
SHRINKFILE Process

SQL SERVER – Killing DBCC SHRINKFILE Process – Is it Safe?

June 4, 2020
Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Performance, SQL Server, SQL Server DBCC

Shrinking the data file is a very bad thing and you can read it. Now let us learn about if Killing DBCC SHRINKFILE Process is safe or not?

Read More
Inactive VLF

SQL SERVER – Query to List Active and Inactive VLF

March 12, 2020
Pinal Dave
SQL Performance
Shrinking Database, SQL Log, SQL Scripts, SQL Server, SQL Server DBCC, Transaction Log

During the  Comprehensive Database Performance Health Check, I had also helped the client build a query to list active and inactive VLF.

Read More
shrink tempdb

SQL SERVER – How to Shrink tempDB Database?

August 15, 2019
Pinal Dave
SQL Tips and Tricks
Shrinking Database, SQL Scripts, SQL Server, SQL Server DBCC, SQL TempDB

In the email yesterday from the client who earlier hired me for performance tuning had a small question about how to shrink tempdb database.

Read More

SQL SERVER – Msg 2555: Cannot Move All Contents of File to Other Places to Complete the Emptyfile Operation

February 2, 2019
Pinal Dave
SQL
Shrinking Database, SQL Error Messages, SQL Scripts, SQL Server, SQL TempDB, Starting SQL

Once upon a time, I was trying to remove TempDB database additional files, but it was not working. In this blog I would explain the steps needed fix Msg 2555: Cannot move all contents of the file to other places to complete the emptyfile operation.

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

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

Go to mobile version