Erin Stellato uses a simple example to demonstrate the performance benefits you might expect from enabling memory-optimized tempdb metadata in SQL Server 2019.
Glenn Berry explains why, if given the choice, the next time you purchase hardware to run SQL Server, you should opt for AMD instead of Intel processors.
Tim Radney talks about some of the typical SQL Server mishaps he comes across out in the wild, and resources you can use to avoid them in your own environments.
Glenn Berry provides some details about how compatibility levels and the cardinality estimator have changed over the years, and why modern versions of SQL Server continue to be the better option.
Glenn Berry lays out a convincing argument to upgrade to a modern version of SQL Server – considering not only the platform improvements but also changes to Windows, storage, and hardware.
Glenn Berry (@GlennAlanBerry) explains why you need to be very careful about your physical processor choice when configuring servers to run SQL Server 2016 Standard Edition.
