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.
SQL Server provides two commonly used functions, ISNULL and COALESCE, to address this requirement. Difference Between ISNULL and COALESCE
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.
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.
While my primary focus is on SQL Server Performance Tuning, we will see questions related to adding default value to the existing table.