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: )

21,649 reads

Blogs

Basic JSON Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 30 Nov 2020

By

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

Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes

By

A project I’ve been meaning to work on for a while has been to...

Read the latest Blogs

Forums

Performance and usage of system stored procedure sp_columns_100

By webrunner

Hello experts, I'm researching different ways to monitor SQL Server CPU usage by query....

Operand type clash: text is incompatible with datetime2

By AMCiti

Dear Group: I am not sure what is causing this, and having a terrible...

Can I clone a database across servers?

By SQL Guy 1

Hi all, I have a database that resides on server A and I need...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The TUF File

See possible answers