So, like, what is a byte?
A friend of mine in the filmmaking business, who is exceedingly bright but has never worked with SQL Server before, was reading through the first… Read More »So, like, what is a byte?
Home » Storage Engine »
Storage Engine
Max Server Memory and SQL Server 2016 Service Pack 1
(This post was last updated on 1 August 2022.) Everything changed for SQL Server Standard Edition on 16 November 2016, and how memory limits work.… Read More »Max Server Memory and SQL Server 2016 Service Pack 1
Temporal Tables and Hidden Period Columns
In my November 2015 post, An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean, I wrote: The HIDDEN property is optional and… Read More »Temporal Tables and Hidden Period Columns
My surname is NULL
Last Wednesday on Twitter, Abayomi Obawomiye (@SQLAmerica) wrote: https://twitter.com/SQLAmerica/status/819252286274695168 I just met someone with the last name NULL today. I really want to ask if… Read More »My surname is NULL
Temporal Tables and History Retention
I’m a huge fan of Temporal Tables in SQL Server 2016. I first wrote about them, in a four-part series in November 2015, before SQL… Read More »Temporal Tables and History Retention
Wait For Service Pack 1
Conventional wisdom tells us that when Microsoft releases a new version of any server product, we should wait until Service Pack 1 before deploying it… Read More »Wait For Service Pack 1
Temporal Tables in Azure SQL Database
In the latest Microsoft Azure newsletter I received last week was this most excellent news: Azure SQL Database Temporal Tables generally available Temporal Tables let… Read More »Temporal Tables in Azure SQL Database
On clustered indexes, clustering keys and primary keys
Many smart people have spoken about clustering keys and primary keys before, so here’s a less smart take on the topic. Let’s define some things… Read More »On clustered indexes, clustering keys and primary keys
What is physical storage anyway?
My friend Jason asked me about his MySQL database export file last week, whether it was sufficient to create a new database. I replied saying… Read More »What is physical storage anyway?
Is DBCC SHRINKFILE (filename, EMPTYFILE) fully logged?
Update: Paul Randal told me I had made a mistake in my post. The correction is below. On Wednesday last week, Kenneth Fisher (b |… Read More »Is DBCC SHRINKFILE (filename, EMPTYFILE) fully logged?
Data Efficiency in SQL Server: DECIMAL
This is part two of a short series of posts about how I assign efficient data types when designing a new table or database. Use… Read More »Data Efficiency in SQL Server: DECIMAL
Data Efficiency in SQL Server: DATETIME
This is the first in a short series of posts about how I assign efficient data types when designing a new table or database. Use… Read More »Data Efficiency in SQL Server: DATETIME
Temporal Tables – When To Use Them
Last edited on 18 December 2019. This is the final part of my Temporal Table series. You can read parts one, two and three here.… Read More »Temporal Tables – When To Use Them
Modifying Temporal Tables – A Primer
This is part three of the Temporal Tables series. You can read parts one and two here. Last week I demonstrated how temporal tables in… Read More »Modifying Temporal Tables – A Primer
Temporal Tables Under The Covers
(This is a more technical post than last week. If you are not familiar with SQL Server internals, I will not be upset if you… Read More »Temporal Tables Under The Covers