We fixed quite a lots of things at customer place with regards to TempDB and he finally was able to get “the Flash” fast performance.
SQL SERVER – Increasing Speed of CHECKPOINT and Best Practices
I received this question as a follow up of my earlier blog post which I wrote about SQL SERVER – Impact of CHECKPOINT and DBCC DROPCLEANBUFFERS on Memory.
SQL SERVER – Clean Pages and Dirty Pages Count – Memory Buffer Pools
Recently, while working with the customer who had a Memory issue, we ended up talking about Clean Pages and Dirty Pages Count.
SQL SERVER – Natively Compiled Stored Procedures and Location of Compiler
I recently implemented a Memory Optimized Table solution at one of the large financial organizations while working on Natively Compiled Stored Procedures.
SQL SERVER – 3 Questions: An Index Reduces Performance of SELECT Queries
Lots of people had no idea that even index can also reduce the performance of SELECT queries. In this blog, we discuss 3 follow up questions.
Recorded Class : Buy One Get One – SQL Server Performance Tuning Practical Workshop for EVERYONE
This is a buy one get one to my recorded class SQL Server Performance Tuning Practical Workshop for EVERYONE. Very unique offer for everyone!
SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback
There are many reasons to envy my job as SQL Server Performance Tuning Expert Consultant but the most important reason is that I get to work on quite often the latest version of SQL Server. Just the other day I had an early adopter customer who was using SQL Server 2019 for their environment and they wanted me to help them with the new feature of Accelerated Database Recovery.