Let us see a script that will help check if a Column Exists in a Table. One of the common tasks that developers deal with when working on database-related projects
SQL SERVER – Scripts to Retrieve Column Names
Understanding how to retrieve column names from a table is one of the fundamental operations you should be familiar with.
Swap Columns – SQL in Sixty Seconds #199
Today we will see a quick video on how to swap columns in SQL Server. It is a widespread request. We will learn that in this video.
SQL SERVER – Check If a Column Exists 2016 Onwards
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.