Recently a client reached out to me with a very interesting question, why is he not able to see the parallelism in Express Edition. Let us discuss today.
SQL SERVER – Dirty Pages vs Clean Pages in Memory
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.
SQL SERVER – Logs are Full and Can’t Switch Recovery Models
His question was about their database Logs, which were Full and they Can’t Switch Recovery Models. Let us discuss this problem today.
[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.
SQL SERVER – Query Cost 100%
How to tune a T-SQL with Query Cost 100%?
This is indeed an interesting question and I have received during Comprehensive Database Performance Health Check.
Experience – My Very First YouTube Live
Today I am going to share my experience with my very first YouTube Live. I realized that there is a lot of improvement required in my efforts, and I also need to bring some more fineness in my presentation. Let us discuss that in detail.