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.
SQL SERVER – Fill Factor – Instance Level or Index Level
One of the conversations that keep on coming up at what level one should set the fill factor – Instance Level or Index Level.
List All Sessions – SQL in Sixty Seconds #148
One of the most frequent questions which I receive from my client is about activity going inside SQL Server and how to list all sessions.
SQL SERVER – Attach an In-Memory Database with T-SQL
My client of Health Check sent me an email asking if there is any other method when we have to attach an In-Memory Database with T-SQL.
SQL SERVER – Attach a Database with T-SQL
One of my clients reached out to me asking for help in attaching the database files to the server. Let us see today we can attach a database with T-SQL.
SQL SERVER – Inserting sp_who2 Into a Table
I should also have included the script for method 1 discussed in the blog post. Let us learn a method of inserting sp_who2 into a table.
SQL SERVER – Representing sp_who2 with DMVs
During the recent Performance Check, I had a very interesting situation where my client wanted to capture the details of the sp_who2 in a table with DMVs.
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.