SQL Server

SQL Server In-Memory OLTP Overview. In-Memory OLTP can provide great performance gains, for the right workloads …

SQL Server In-Memory OLTP Overview. In-Memory OLTP can provide great performance gains, for the right workloads …

SQL Server Cardinality Estimation. The SQL Server Query Optimizer is a cost-based Query Optimizer. This means that it selects query plans that have the lowest …

SQL Server Automatic tuning. Automatic tuning is a database feature that provides insight into potential query performance …

SQL Server Statistics. The Query Optimizer uses statistics to create query plans that improve query performance. For most queries …

SQL Server Resource Governor is a feature that you can use to manage SQL Server workload and system resource consumption. Resource Governor enables …

Upgrading Databases using Query Tuning Assistant. The starting point of QTA assumes that a database from a previous …

Using SQL Server Management Studio. Follow the steps in this procedure to create one or more filegroups, corresponding files, and a table …

Partitioned Tables and Indexes. The data of partitioned tables and indexes is divided into units that may optionally be spread across more than one filegroup …

SQL Server Execution Plans. To be able to execute queries, the SQL Server Database Engine must analyze the statement to determine …

Database Engine Tuning Advisor. The Microsoft Database Engine Tuning Advisor (DTA) analyzes databases and makes recommendations that you can use to optimize ….

Configuring Storage Spaces with a NVDIMM. Windows Server 2016 supports NVDIMM-N devices that allow for extremely fast …