August 2022 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
  • Training
swap columns

Swap Columns – SQL in Sixty Seconds #199

August 2, 2022
Pinal Dave
SQL Video
SQL Column, SQL in Sixty Seconds

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.

Read More
column exists

SQL SERVER – Check If a Column Exists 2016 Onwards

September 3, 2021
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server

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. 

Read More
Altering Column

SQL SERVER – Altering Column – From NULL to NOT NULL

July 13, 2021
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server

Let us see a very simple script today. It is about Altering Column – From NULL to NOT NULL. Comprehensive Database Performance Health Check

Read More
Replace Rowstore

SQL SERVER – Replace Rowstore Clustered Index with Columnstore Clustered Index

May 28, 2021
Pinal Dave
SQL Performance
ColumnStore Index, SQL Column, SQL Scripts, SQL Server

Let us learn in this blog post how to Replace Rowstore Clustered Index with Columnstore Clustered Index. Comprehensive Database Performance Health Check

Read More
maximum column

SQL SERVER – Maximum Column Per Index – 32

March 22, 2021
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Index, SQL Scripts, SQL Server, SQL Statistics

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.

Read More
getcolnames

SQL SERVER – Get Column Names

February 25, 2021
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server, SQL Stored Procedure

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.

Read More
all columns

SQL SERVER – Script to Find All Columns with a Specific Name in Database

January 22, 2020
Pinal Dave
SQL Tips and Tricks
SQL Column, SQL Scripts, SQL Server

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.

Read More
1 2 3 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2022 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version