Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER – Move a Table From One Schema to Another Schema

January 14, 2021

My client of Comprehensive Database Performance Health Check wanted to learn the trick to Move a Table From One Schema to Another Schema.

SQL SERVER – List All Dates Between Start and End Date

January 13, 2021

Pinal Dave

SQL Tips and Tricks

CTE, SQL DateTime, SQL Scripts, SQL Server

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

January 12, 2021

Pinal Dave

SQL Video

Execution Plan, SQL Cache, SQL in Sixty Seconds, SQL Scripts, SQL Server

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

January 11, 2021

Pinal Dave

SQL Performance

ColumnStore Index, SQL Index, SQL Scripts, SQL Server

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

January 8, 2021

Pinal Dave

SQL Tips and Tricks

SQL Cache, SQL Memory, SQL Scripts, SQL Server

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.