I’m excited to introduce my latest offering, the “SQL Server Functions for Smart Data Handling” course, designed to enhance your skills in advanced data handling techniques.
Functions and Missing Indexes – SQL in Sixty Seconds 204
In this blog post, we will discuss the relationship between Functions and Missing Indexes Hints in SQL Server. Functions can reduce query performance.
3 ChatGPT Tricks to Tune SQL Server – SQL in Sixty Seconds 203
In this blog post, I will share three quick and effective methods to tune your SQL Server using ChatGPT. These tricks can help you optimize.
Function in the WHERE Clause – SQL in Sixty Seconds 201
Few even asked me to build a video on this topic. Hence, I decided to make a Function in the WHERE Clause – SQL in Sixty Seconds 201.
Parameter Sensitive Plan optimization in SQL Server 2022 – SQL in Sixty Seconds #200
SQL Server 2022 introduces Parameter Sensitive Plan Optimization (PSPO), a feature that revolutionizes the performance of parameterized queries.
Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. We will learn that in this video.
Find Database File Latency – SQL in Sixty Seconds #198
Lots of people asked me to create a video on my earlier blog post SQL SERVER – Script to List Database File Latency. Here is the video.