Earlier I had written a blog post SQL SERVER – List Tables with Size and Row Counts. Jason Horner, an SQL Server Expert, improved my query.
MAX Columns Ever Existed in Table – SQL in Sixty Seconds #182
Earlier I wrote about SQL SERVER – MAX Columns ID Used in Table and lots of people asked me to create a video on this topic. Let us see the video.
SQL SERVER – Available Free Space in Data and Log File
Lots of good feedback, I have received on my recent to the point blog posts. Today we will see a script for Available Free Space in Data and Log File.
SQL SERVER – Rename View
There are two different ways one can rename view in SQL Server. Let us see in today’s blog post how to rename view. 1) SSMS 2) T-SQL
SQL SERVER – Find High Frequency Queries
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!