Are nulls stored in a nonclustered index?
When you index a nullable field, are the rows with nulls stored in the index? It’s easy enough to find out by creating a table with a nullable field, and then creating an index on it.
2019-03-29
When you index a nullable field, are the rows with nulls stored in the index? It’s easy enough to find out by creating a table with a nullable field, and then creating an index on it.
2019-03-29
2019-01-04
972 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-11-21
792 reads
2017-09-11
1,271 reads
2017-01-09
1,768 reads
2016-09-26
1,424 reads
2016-02-17
1,676 reads
NULLs in SQL are a mixed blessing. The Three-Valued Logic of SQL has its uses but can cause difficulties to anyone who assumes that NULL has a 'value'. It can make reports go horribly wrong in a number of alarming ways, as Robert Sheldon explains.
2015-07-14
8,842 reads
2015-07-06
2,019 reads
By Steve Jones
Today’s coping tip is to focus on what’s good, even if today feels tough....
Introduction Purity is the operating environment that runs Pure Storage products like FlashArray and...
By Steve Jones
SQL Data Compare (SDC) is a great way to sync data among tables. It’s...
Hi everyone, In below code I am creating a table and inserting some english...
backup log to int run every hour. If a log init backup is run...