Batch Mode Processing for Row Data in SQL Server 2019
Mar 5,
2019
Batch mode processing was introduced in SQL Server in 2012, the same time as columnstore indexes. The combination of the two prevented SQL Server from needlessly processing column values not needed by a query, as it must do in classic row processing. This processing mode also permits SQL Server to take better advantage of cache […]
UTF-8 Support in SQL Server 2019
Feb 6,
2019
UTF-8 has been the predominant character encoding system for the world-wide web since 2009 and as of October 2018 accounts for over 90% of all web pages. As of October 2018, UTF-8 is not supported by Microsoft SQL Server. SQL Server 2019 will remedy this situation, as current SQL Server community technology previews illustrate. The […]