The views are very tricky. Sometimes they help performance and sometimes they negatively impact performance. Recently, during Comprehensive Database Performance Health Check, I realized that one of the view was the real performance killer. The challenge was to identify column used in a view. We decided to open the view and list all the columns but that was very cumbersome tasks. Finally, we decided to write a script which can help identify columns used in a view.
SQL SERVER – Invalid Object Name ‘master.dbo.spt_values’ in Management Studio
One of my clients contacted me for On Demand (55 minutes) as they believed that this was a simple issue. John was honest enough to confess the mistake which he has done, which lead to error related to invalid object name.
SQL SERVER – Interesting Observation – Count of Temporary Table Re-generations
The best part of my SQL Server Performance Tuning Practical Workshop is that at the end of the workshop we spend quite a good amount of time to solve the issues users have in their production system. During one of the recent workshop, I was asked a very interesting question about temporary tables.
SQL SERVER – How to See Scripts Executing in sp_executesql?
Question: How to See Scripts Executing in sp_executesql?
SQL SERVER – How to Pass Parameters to the Stored Procedure?
After so many years of existence of the stored procedures, I still see developers struggling to execute the stored procedure. Every other day I receive a question in an email asking how to pass parameters to the stored procedure.
SQL SERVER – Running CHECKDB with Minimum Repair Level
“How do I run CHECKDB with Minimum Repair Level?”
SQL SERVER – ALTER Column from INT to BIGINT – Error and Solutions
Sometime ago I wrote a blog on identity column value jump issue, you can read it from here SQL SERVER – Jump in Identity column after restart! In this blog post we will learn how to resolve the error when we alter column from int to bigint.