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

22,227 reads

Blogs

2020 Advent of Code–Day 3

By

This series looks at the Advent of Code challenges. As one of my goals,...

Welcome to the Azure Data Community, empowered by Microsoft

By

After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...

Daily Coping 24 Feb 2021

By

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

Read the latest Blogs

Forums

SQL Server maximum Server Memory

By IT researcher

I am using SQL Server 2008 R2  Express  edition. I have already set Maximum...

Developer vs Enterprise

By VastSQL

Hi Experts, Is there any difference between Developer & Enterprise Edition of SQL Server...

"SQL Server Windows NT - 64 bit" in Task Manager: Memory and CPU high

By silbahi

Hello, It's weird that suddenly I can't access to my sql server database (it...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers