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,242 reads
2016-09-26
1,419 reads
2016-02-17
1,662 reads
2015-05-01
1,778 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)
18,203 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
A Memory-Optimized Roundup – T-SQL Tuesday #117
By Steve Jones
The summary from my fourth T-SQL Tuesday hosting for #117. This time I was...
How do you debug your spark-dotnet app in visual studio?
By Ed Elliott
When you run an application using spark-dotnet, to launch the application you need to...
More PowerShell Remoting coverage in dbatools
By Cludio-Silva
Starting on dbatools version 1.0.31 we introduced better coverage for commands that make use...
Forums
Sql 2014 sp3 - extra stats created
Has anyone seen Sp3 creating extra unexpected stats on tables after or during application...
Ask SSC