Virtual log file growth In previous versions of SQL Server, if the next growth is more than 1/8 of the current log size, and the growth is less than 64 MB, four VLFs were created. In SQL Server 2022 (16.x), this behavior is slightly different. Only one VLF is created if the grow...
Has columnstore index enhancements for sorting and Always On Availability Group support. New security features: Always Encrypted: When enabled, only the application that has the encryption key can access the encrypted sensitive data in the SQL Server 2016 database. The key is never passed to SQL...
OPTIMIZE_FOR_SEQUENTIAL_KEY Turns on an optimization within the SQL Server Database Engine that helps improve throughput for high-concurrency inserts into the index. This option is intended for indexes that are prone to last-page insert contention, which is typically seen with indexes that have a...
Has columnstore index enhancements for sorting and Always On Availability Group support. New security features: Always Encrypted: When enabled, only the application that has the encryption key can access the encrypted sensitive data in the SQL Server 2016 database. The key is never passed to SQL...
This property setting is already available for Azure Analysis Services. The Power BI service caches dashboard tile data and report data for initial load of Live Connect report, causing an excessive number of cache queries being submitted to the engine, and in extreme cases overload the server. ...
This property setting is already available for Azure Analysis Services. The Power BI service caches dashboard tile data and report data for initial load of Live Connect report, causing an excessive number of cache queries being submitted to the engine, and in extreme cases overload the server. ...
Has columnstore index enhancements for sorting and Always On Availability Group support. New security features: Always Encrypted:When enabled, only the application that has the encryption key can access the encrypted sensitive data in the SQL Server 2016 database. The key is never passed to SQL Se...
This property setting is already available for Azure Analysis Services. The Power BI service caches dashboard tile data and report data for initial load of Live Connect report, causing an excessive number of cache queries being submitted to the engine, and in extreme cases overload the server. ...
SQL Server index fragmentation is an overarching problem arising from an excessive number of alterations in the database.
This is a feature I find very useful in Power BI and PowerPivot, as it gives the query engines (such as Power BI Q&A) additional metadata to index on. Of course, it'd be even better to be able to rename a column/measure without it breaking the downstream reports as ...