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.
SQL SERVER – List All the Nullable Columns in Database
Recently during the consulting engagement, I needed to create a query that Lists All the Nullable Columns in Database, which I am sharing.
SQL SERVER – Installation Error: System.ArgumentNullException – Value Cannot be Null
A client automating SQL Server installs saw random failures: System.ArgumentNullException, Value cannot be null. Here is what Detail.txt showed and the cause.
SQL SERVER – How to Change Column Property From NULL to NOT NULL Value?
A Very popular question I often here whenever I am presenting at the developer conference – How to Change Column Property From NULL to Not NULL Value?
SQL SERVER – Puzzle – Brain Teaser – Changing Data Type is Changing the Default Value
A brain teaser on data types: changing data type is changing the default value of a column. Can you name the original and new datatype and default value?