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

20,296 reads

Blogs

Daily Coping 4 Jun 2020

By

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

SQL Homework – June 2020 – DML Triggers

By

Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are...

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

By

We have seen how we can export and save the results to a folder...

Read the latest Blogs

Forums

How can I get my money back from Cash app?

By oliviajmaes123

Hey, get my money back from Cash app is possible via making a request...

How can I get my money back from Cash app?

By oliviajmaes123

Hey, get my money back from Cash app is possible via making a request on that...

Getting error when delete the able donot have data

By asrinu13

Hi I have one doubt in ssis I want delete the data in the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers