Other features include a new version of PolyBase (SQL Server's big data connectivity solution) that uses REST APIs to connect to data lakes in addition to using the ODBC drivers - on which the last version of PolyBase was premised. SQL Server 2022 also sports scalability for large memory servers and high concurrency scenarios. Another feature, called Parameter Sensitive Plan Optimization, automatically enables the generation of multiple active cached query plans for a single parameterized statement, accommodating different data sizes based on provided runtime parameter values. This facilitates SQL Server Query Store's enablement of query hints for the multiple replicas, improving performance without requiring a rewrite of Transact SQL (T-SQL) code. On the performance side, SQL Server 2022 adds support for multi-write replication, creating corresponding multiple read replicas.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |