Skip to content

SQL Server

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 ….