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,266 reads
2016-09-26
1,424 reads
2016-02-17
1,674 reads
2015-05-01
1,785 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)
24,793 reads
2014-03-27
2,340 reads
2013-06-05
2,432 reads
2013-05-10
2,245 reads
2012-05-11
3,344 reads
Blogs
Setting up SQL Server 2022 s3 Object Storage Integration using MinIO with Docker Compose
In this blog post, I’ve implemented two example environments for using SQL Server 2022’s...
Daily Coping 12 Aug 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
My Toolbox - Greenshot
By Zikato
Foreword A picture is worth a thousand words. I use screenshots daily, whether it’s to...
Forums
Help me design a correct simple table
I have a table like Diesel(id, supplier, operator, machine, taken_time, given_time) There are 2...
Error Grafana SQLWATCH
hello , I am looking for a Grafana expert to help me with this...
SQL Standard Confusion
Comments posted to this topic are about the item SQL Standard Confusion
Ask SSC