In early 2011 Jes Borland invited us to write about aggregations: I want to hear how you solved business problems with aggregate functions. I want… Read More »T-SQL Tuesday Retrospective #015: Aggregations
Last week, I posted this statement on Twitter, along with a screen capture of the official Microsoft documentation: Reminder: Max Server Memory is *not* just… Read More »What you need to know about memory limits on SQL Server
(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
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