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.
SQL SERVER – Adding Values Containing NULLs
Today we will see a very simple blog post about Adding Values Containing NULLs. During the consulting engagement of Health Check.
SQL SERVER – NULL Values and CONCAT Function
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.
SQL Puzzle – Solution to Strange Results – IN and IS NOT NULL –
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.
SQL SERVER – Adding Default Value to Existing Table
While my primary focus is on SQL Server Performance Tuning, we will see questions related to adding default value to the existing table.
SQL Puzzle – IN and IS NOT NULL – Strange Results
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.
SQL SERVER – Count NULL Values From Column
I have received a very simple but interesting question by one of my earlier clients about how to count NULL values from the column.