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
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
2017-09-11
1,258 reads
2016-09-26
1,420 reads
2016-02-17
1,669 reads
2015-05-01
1,781 reads
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)
22,227 reads
2014-03-27
2,337 reads
2013-06-05
2,429 reads
2013-05-10
2,242 reads
2012-05-11
3,340 reads
By Steve Jones
This series looks at the Advent of Code challenges. As one of my goals,...
After the Professional Association of SQL Server (PASS) unceremoniously closed down in January this...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
I am using SQL Server 2008 R2 Express edition. I have already set Maximum...
Hi Experts, Is there any difference between Developer & Enterprise Edition of SQL Server...
Hello, It's weird that suddenly I can't access to my sql server database (it...