Itzik Ben-Gan adds another post to his series on T-SQL pitfalls and best practices, treating complications and limitations of the PIVOT and UNPIVOT operators.
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.
Itzik Ben-Gan describes nested window functions and how they could simplify some tedious query scenarios. He asks for your help voting for these to be included in SQL Server.
