Jan 2023 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
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
strange results

SQL Puzzle – IN and IS NOT NULL – Strange Results

June 17, 2020
Pinal Dave
SQL Puzzle
SQL NULL, SQL Scripts, SQL Server

Today, let us see a very simple puzzle where we are getting strange results when using NOT IN and IS NULL in a T-SQL query.

Read More
count null

SQL SERVER – Count NULL Values From Column

March 5, 2020
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL NULL, SQL Scripts, SQL Server

I have received a very simple but interesting question by one of my earlier clients about how to count NULL values from the column.

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

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

Go to mobile version