Feb 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 FLUSHAUTHCACHE

SQL SERVER – Empty Database Authentication Cache with DBCC FLUSHAUTHCACHE

October 26, 2021
Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Scripts, SQL Server, SQL Server DBCC

A very interesting DBCC command I recently came across and that is DBCC FLUSHAUTHCACHE. DBCC function applies to Azure SQL Database.

Read More
DBCC CLEANTABLE

SQL SERVER – When to Use DBCC CLEANTABLE?

September 9, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server DBCC

Recently a client of mine asked me – When to Use DBCC CLEANTABLE? A question to be discussed in Comprehensive Database Performance Health Check.

Read More
DBCC UPDATEUSAGE

SQL SERVER – Correcting Space Allocation with DBCC UPDATEUSAGE

July 26, 2021
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server DBCC

I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE. 

Read More
suspected pages

SQL SERVER – Quick Look at Suspected Pages

July 12, 2021
Pinal Dave
SQL Tips and Tricks
Database Corruption, SQL Scripts, SQL Server, SQL Server DBCC

Well, let us take a Quick Look at Suspected Pages which contains details about corrupted pages. They have been running DBCC commands regularly.

Read More
DBCC DBREINDEX

SQL SERVER – DBCC DBREINDEX and MAXDOP Not Possible

December 24, 2020
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Server DBCC

Yes, you read it right it is not possible to use DBCC DBREINDEX with MAXDOP hint as far as I know. If there is any method to use it.

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
spinlock

SQL SERVER – What is Spinlock?

September 16, 2020
Pinal Dave
SQL Tips and Tricks
SQL Latch, SQL Memory, SQL Server, SQL Server DBCC, SQL Spinlock

After reading both the blog post, I got another question from my client on What is Spinlock? Let us discuss today What is Spinlock. 

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

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

Go to mobile version