A very common question, I keep on getting is how to get column names for a particular column. Well, it is pretty straightforward and easy to do.
SQL SERVER – Script to Find All Columns with a Specific Name in Database
Recently, one of the clients asked me if I have a Script to Find All Columns with a Specific Name in Database. Yes, of course, I do have it.
SQL SERVER – List All the Nullable Columns in Database
Recently during the consulting engagement, I needed to create a query that Lists All the Nullable Columns in Database, which I am sharing.
SQL SERVER – Find All Tables Containing Specific Column Name
During the recent Comprehensive Database Performance Health Check, I was asked if I know any trick to identify column with a Specific Name in the database.
SQL SERVER – Swap Column Values In Table
Here is a question asked to me during Comprehensive Database Performance Health Check. The question was about how to swap column values in a table.
SQL SERVER – Measuring the Length of VARCHAR and NVARCHAR Columns with COL_LENGTH
I love my job because I get to help people learn new technology as well as help them clear their confusion about the older technology. Recently during SQL Server Performance Tuning Practical Workshop, I was asked a very simple but interesting question by an attendee about NVARCHAR column.Â
SQL SERVER – How to Count a Particular Value Across All Columns?
This question came up in the recent SQL Server Performance Tuning Practical Workshop. During the workshop, I have answer questions of users during lunch break. One of the users had a very interesting scenario where he had to change one of their employee’s email address for technical reasons but before he changes that he needed to count in every single place where the email exists. I have simulated the same situation in this blog post and we will see how we can count a particular value across all the columns of the table.