However, sometimes it is fun to learn new things as well. Let us learn how you can check if a column exists in a table from SQL Server 2016 and onwards.
SQL SERVER – Altering Column – From NULL to NOT NULL
Let us see a very simple script today. It is about Altering Column – From NULL to NOT NULL. Comprehensive Database Performance Health Check
SQL SERVER – Replace Rowstore Clustered Index with Columnstore Clustered Index
Let us learn in this blog post how to Replace Rowstore Clustered Index with Columnstore Clustered Index. Comprehensive Database Performance Health Check
SQL SERVER – Maximum Column Per Index – 32
Well, the answer is you can have 32 Maximum Column Per Index but that does not mean you should have 32 indexes. Let us learn today.
SQL SERVER – Get Column Names
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.