Can a single column and single row result do an entire table scan? I recently got this question in my Comprehensive Database Performance Health Check.
Dirty Read with NOLOCK – SQL in Sixty Seconds #110
Recently I noticed that my client has been using the WITH NOLOCK hint with their queries and expecting that it will improve the queries performance.
Undo Human Errors in SQL Server – SQL in Sixty Seconds #109 – Point in Time Restore
In this blog post, we are going to talk about how to undo human errors in SQL Server with the help of Point in Time Recovery. Let us learn today.
Solve Puzzle about Data type – SQL in Sixty Seconds #108
A very interesting puzzle, where you see the data type conversion in action. I have previously blogged about this puzzle and had received amazing feedback.
How to Insert Multiple Values into Multiple Tables in a Single Statement? – Interview Question of the Week #290
Question: How to Insert Multiple Values into Multiple Tables in a Single Statement? One of the most popular questions, I often receive from my client.
Move TempDB for Performance – SQL in Sixty Seconds #107
we figured out that they had slow overall performance because they had TempDB located on the slow drive. Today we will learn how we can move TempDB.
Do MAX(col) Scan Table? – SQL in Sixty Seconds #106
While working on working on a Comprehensive Database Performance Health Check my client asked me – Do MAX(col) Scan Table? Let us learn about that today.
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.