SQL Authority with Pinal Dave - Page 2 of 765 - SQL Server Performance Tuning Expert

Comprehensive Database Performance Health Check | Testimonials

Hire Me Free Learning Videos

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.

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.

An Index Reduces Performance of SELECT Queries (Video)
3 Common Mistakes to Kill SQL Server Performance (Video)
Click here for More Free Videos

For SQL Server Emergency Help, you can reach out to me at pinal@sqlauthority.com with words URGENT in the email subject line for other services mention “Comprehensive Database Performance Health Check“.

Jan18

SQL SERVER – The Monthly Mentor Returns 2021

SQLAuthority News

I will be presenting along with Quest presentations on the monthly mentor series. The sessions contain brand new freshly updated demonstrations.

Jan15

SQL SERVER Management Studio – Grid vs Text Output

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Management Studio, SQL String, SSMS

they asked me questions if I know how to fix it. Well, it is actually very simple and we need to learn about Grid vs Text Output.

Jan14

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

SQL Tips and Tricks

Schema, SQL Scripts, SQL Server

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

Jan13

SQL SERVER – List All Dates Between Start and End Date

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).

Jan12

Count Table in Cache – SQL in Sixty Seconds #149

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.

Jan11

SQL SERVER – Compression Delay for Columnstore Index

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.

Jan8

SQL SERVER – Remove Unused Cache MARK_IN_USE_FOR_REMOVAL

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.

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 12 SQL Server database books, 35 Pluralsight courses and has written over 5400 articles on database technology on his blog at a https://blog.sqlauthority.com. Along with 17+ years of hands-on experience, he holds a Masters of Science degree and a number of database certifications.

For any SQL Server Performance Tuning Issue send an email at pinal@sqlauthority.com .

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).

Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long term multi-channel campaigns to drive leads for their sales pipeline.

Exclusive Newsletter

Menu

Exit mobile version