(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
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
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
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?
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