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 – 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.