We are going to discuss Troubleshooting High CPU in SQL Server. This is why many hire me for Comprehensive Database Performance Health Check.
Generate Script of SQL Server Objects – SQL in Sixty Seconds #184
Today we will see the same concept translating in the video. Let us learn about Generate Script of SQL Server Objects in video format.
SQL SERVER – NOLOCK with DMVs
Is it alright to use NOLOCK with DMVs? I was recently asked about this by a client during the Comprehensive Database Performance Health Check.
Idera Live Virtual Conference 2021 – The Data Debate
A virtual event with 10 hours of informative sessions delivered across 2 days. The theme of the conference is The Data Debate.Â
SQL SERVER – Get Last Restore Date
Let us learn how to get the last restore date for the backup in SQL Server. Here is a very simple script for the same. Let me know your feedback.
SQL SERVER – When to Use DBCC CLEANTABLE?
Recently a client of mine asked me – When to Use DBCC CLEANTABLE? A question to be discussed in Comprehensive Database Performance Health Check.
SQL SERVER – Easiest Way to Copy All Stored Procedure Definitions
What is the easiest way to copy all stored procedure definitions for your database? Well, let us quickly learn that today.