Why 0 is better than NULL sometimes

Working with big data requires attention to details, testing, retesting, comparing data returned by the stored procedures, views, table valued functions etc. with the expected result. So understanding the core concepts of SQL is a must.

I am currently working for an insurance company and the amount of data they have is huge. One of their main functionality is having reports where they can interpret the data as they need.

While testing something on one of their reports, I found …

attention big big data concepts core data etc functions insurance null sql sqlserver table testing understanding