NULL

Missing Data

  • Article

Missing data is a difficult and common problem to solve. In this article, Joe Celko explains several approaches to deleting or replacing missing data.

2018-07-04

2,461 reads

Database Design Follies: NULL vs. NOT NULL

  • Article

It sounds simple enough. Either your column will always have a value or it may not. Yet somehow such a seemingly simple decision can become a never-ending debate where database schema begins to resemble superstition and designing effective tables seems more contentious than you expected it to be.

4.38 (78)

2016-02-26 (first published: )

23,000 reads

Blogs

Azure SQL Managed Instance Versions

By

Just a really quick FYI for the readers. If you are using Managed Instances...

A summary of new features in Azure SQL Database

By

It has been some time since I last wrote about Azure SQL Database. Although...

Daily Coping 23 Jun 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

SQL Server 2019 Distributed Availability Groups

By DK

Hello.  I am looking into setting up a Distributed Availability Group between 2 availability...

Server Roles and Permissions

By Atat Rowcount

Hi guys Setting up a new SQL Server on Azure (Managed Instance).  I have...

trying to run an Batch file from a Job

By itmasterw 60042

Hi, I looked on the web and I just found the cod that I...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers