SQL Server internal storage

Sometimes things are not exactly how we think they are. Read the story of the missing default value and learn why.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.93 (42)

You rated this post out of 5. Change rating

2017-03-24 (first published: 2015-12-01)

6,921 reads

Blogs

Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...

Setting page visibility and the active page are often overlooked last steps when publishing...

It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...

Comments posted to this topic are about the item Password Guidance

Comments posted to this topic are about the item Using table variables in T-SQL

I am trying to check out elastic query between two test instances we have...

What happens if you run the following code in SQL Server 2022+?

declare @t1 table (id int);

insert into @t1 (id) values (NULL), (1), (2), (3);

select count(*)
from @t1
where @t1.id is distinct from NULL;