May 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • 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
nullable

SQL SERVER – Unique Indexes on Nullable Columns

August 17, 2023
Pinal Dave
SQL Tips and Tricks
SQL Index, SQL NULL

As the server allows only one null value in a column if a unique constraint is applied. Let us learn about Unique Indexes on Nullable Columns.

Read More
ISNULL and COALESCE

SQL SERVER – Difference Between ISNULL and COALESCE

June 15, 2023
Pinal Dave
SQL Tips and Tricks
COALESCE, SQL NULL, SQL Server

SQL Server provides two commonly used functions, ISNULL and COALESCE, to address this requirement. Difference Between ISNULL and COALESCE

Read More
date null

SQL SERVER – CONVERT Empty String To Null DateTime

May 6, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL NULL, SQL Scripts, SQL Server, SQL String

Let us learn today how to CONVERT Empty String To Null DateTime. While I focus on SQL Server Performance Health Check, let us learn about it today.

Read More
adding values

SQL SERVER – Adding Values Containing NULLs

October 19, 2020
Pinal Dave
SQL Tips and Tricks
SQL NULL, SQL Operator, SQL Scripts, SQL Server

Today we will see a very simple blog post about Adding Values Containing NULLs. During the consulting engagement of Health Check.

Read More
NULL Values

SQL SERVER – NULL Values and CONCAT Function

September 11, 2020
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL NULL, SQL String

A lot of SQL in the Sixty Seconds video recently, we will be looking at a very interesting T-SQL CONCAT function and how it works with the NULL Values.

Read More
strange results

SQL Puzzle – Solution to Strange Results – IN and IS NOT NULL –

July 10, 2020
Pinal Dave
SQL Puzzle
SQL NULL, SQL Scripts, SQL Server

Earlier I had published a blog post about a puzzle SQL Puzzle – IN and IS NOT NULL – Strange Results. Today we will see a solution to strange results puzzle.

Read More
default value

SQL SERVER – Adding Default Value to Existing Table

June 27, 2020
Pinal Dave
SQL Tips and Tricks
SQL NULL, SQL Scripts, SQL Server

While my primary focus is on SQL Server Performance Tuning, we will see questions related to adding default value to the existing table. 

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

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

Go to mobile version