Blog

SQL Server Cardinality Estimation

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

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

SQL Server Statistics

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

SQL Server Resource Governor

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

Using SQL Server Management Studio

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

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

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

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