I was asked what is the difference between Dirty Pages and Clean Pages in SQL Server Buffer Memory and which one is better? Let us quickly discuss.
Recovery Model Changes and the Log Backup Chain
Explain the log backup chain across FULL and SIMPLE changes, inspect recovery LSNs and backup history, and establish a new backup boundary.
[Video] SQL Performance Troubles – Execution Plans – Live 2
I faced another issue that my Camera stopped working. Let us see what today’s video SQL Performance Troubles – Execution Plans – Live 2.
SQL SERVER – MAX Column ID Used in Table
Well, we discussed this during SQL YouTube Live – Performance Troubles – Execution Plans. Let us see MAX Column ID Used in Table.
SQL YouTube Live – Performance Troubles – Execution Plans
I got lots of feedback about my audio setup and the video configurations. I have planned another live session Performance Troubles – Execution Plans.
Tuning Query Cost 100% – SQL in Sixty Seconds #181
After the blog posts, lots of people asked me to build a video so here is the video discussing the topic of Tuning Query Cost 100%.
SQL SERVER – Correcting Space Allocation with DBCC UPDATEUSAGE
I was recently called an interesting scenario by my client. Let us learn today Correcting Space Allocation with DBCC UPDATEUSAGE.