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
One of my clients was trying to automate SQL deployment. While testing they were stuck with an interesting error and then they contacted me. In this blog, I would share my learning about an installation error: System.ArgumentNullException – Value cannot be null.
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
Today, we will see a very interesting puzzle about data types and default values.
You need to answer-
1 The original datatype A and default value B
2 The new datatype C and new default value D
How Default Value and Nullable Column Works? – Interview Question of the Week #129
Question: How Default Value and Nullable Column works together for a single table?
Can We Have NULL Value in Primary Key? – Interview Question of the Week #075
This is a very interesting question. I really do not know why interviews are fascinated with this question. One of the professional services I offer is to help organizations select an ideal employee for their organization and last week, I was on a conference call with a large MNC who was looking for performance tuning expert for their organization. We interviewed around 50 different employees and offered jobs to 2 experts and 1 has so far accepted it. One of the questions which I see my friends from the interview panel asking again and again was about Primary Key. I noticed that most of the candidate got it correct.
What is NOT NULL Constraint? – Interview Question of the Week #073
I am an independent database consultant and I focus on SQL Server Performance Tuning. The other day when I was working with my customer on a large project on performance tuning, we noticed a table which had created performance issues and it contains a huge amount of NULL data. In this blog post we will learn about NOT NULL constraint.