Recently during consulting engagement, we had to Find High Frequency Queries in SQL Server, let us learn that today. Let us learn today.
SQL SERVER – Execution Time of Stored Procedures
How to measure the execution time of the stored procedure when it contains lots of statement inside of it. Let us learn today about Stored Procedures
MySQL Performance – 5 Parameters from Config File
I got lots of emails where people wanted to know more about such parameters. Let us discuss 5 Parameters from Config File which can help MySQL Performance.Â
MySQL Performance – Slow Query and innodb_buffer_pool_size
I have helped my clients with MySQL Performance when I know the solution. Let us discuss Slow Query and innodb_buffer_pool_size.Â
SQL SERVER – Using NOEXPAND with Indexed View
I was helping one of my clients with tuning a view (my personal opinion, I do not like views), when I used NOEXPAND with the Indexed view…
SQL SERVER – Parameter Sniffing and Bad Plan
Another day and another interesting question by a client Do we still get a bad plan after disabling Parameter Sniffing? Yes!
SQL SERVER – Parallelism in Express Edition
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.