Missing Data
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
NULL
2017-09-11
1,237 reads
2016-09-26
1,419 reads
2016-02-17
1,662 reads
2015-05-01
1,777 reads
Database Design Follies: NULL vs. NOT NULL
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.
2016-02-26 (first published: 2014-10-30)
17,954 reads
2014-03-27
2,337 reads
2013-06-05
2,429 reads
2013-05-10
2,238 reads
2012-05-11
3,335 reads
Blogs
SQLSaturday Automatic Messages
By Andy Warren
For those who haven’t used the admin tools for SQLSaturday when an event is...
Using the Announcement/News Part of SQLSaturday
By Andy Warren
One of the interesting but not often used features of the SQLSaturday tools is...
SQLSaturday Orlando 2019 Begins
By Andy Warren
We’ll be event number 911, set for September 28th at our usual location at...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Transaction was deadlocked on lock | communication buffer resources with another
I have a table that contains case numbers. The following stored procedure assigns a...
Microsoft and Oracle Cloud Partnership
Comments posted to this topic are about the item Microsoft and Oracle Cloud Partnership
Ask SSC