We will see a very simple script where we will take advantage of the Common Table Expression and list all dates between two dates (Start and End Date).
Count Table in Cache – SQL in Sixty Seconds #149
Earlier I had written a blog post about SQL SERVER – Find Count of Table Used in Query From Cache. Today we will see a video for the same.
SQL SERVER – Compression Delay for Columnstore Index
Today we will talk about the Compression Delay for Columnstore Index which I got the first-hand experience with my client of Performance Health Check.
SQL SERVER – Remove Unused Cache MARK_IN_USE_FOR_REMOVAL
Today’s topic is very unique and one should not try it out without the proper consultation of an expert. How to Remove Unused Cache MARK_IN_USE_FOR_REMOVAL.Â
SQL SERVER – Columnstore Index and Fragementation
One of the questions I had received from a client was about how to find out fragmentation in columnstore index. Let us discuss it today.Â
SQL SERVER – Database Giving Error While Setting Single_User Mode
Let us see a quick workaround in this blog post about an error related to Database Giving Error While Setting Single_User Mode.
SQL SERVER – Checking Traceflag Status with TRACESTATUS
one of the first things which I check is if any specific trace flag is enabled on the server or not. Let us learn how we can do that with TRACESTATUS.
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.