Category Archives for "SQL Server"

Jul 20

Handling Multiple Missing Index Recommendations for the Same Table

By Jeffry Schwartz | Expert , Missing Indexes , Performance Tuning , Query Tuning , SQL Development , SQL Server

The Problem Many articles concerning SQL Server missing index recommendations demonstrate the mechanics for obtaining them and often highlight whether the suggested key columns are used in equality or inequality relationships. Most of these examples emphasize a single index that can be implemented to improve performance. However, real-life situations often involve multiple or many suggested […]

Continue reading
Jun 08

Get a List of Tables That Are Compressed

By SQLRx Admin | Beginner , Helpful Scripts , SQL Administration , SQL Server , Tip of the Month

Find out if any of your tables are compressed in your database using the query below. Compressed tables can save space and make queries run faster. — Compressed Tables select distinct AS CompressedTables from sys.partitions p inner join sys.tables t on p.object_id = t.object_id where p.data_compression > 0 If you don’t have any tables […]

Continue reading
Jun 02

Query Tuning and Missing Index Recommendations

By Jeffry Schwartz | Missing Indexes , Performance Tuning , Query Tuning , SQL Development , SQL Server

Overview Most analysts are familiar with missing index recommendations provided by SQL Server when query plans are displayed within SSMS or reported by various missing index DMVs. Several questions arise concerning these recommendations: What determines whether a column becomes a key or included in the new index? Where does the ordering of the included columns […]

Continue reading
May 25

AlwaysOn 2016 – Encrypted Databases in an AG

By Ginger Daniel | Encryption , SQL 2016 , SQL Administration , SQL Server

In the AlwaysOn 2016 release, there are several enhancements that have improved manageability, scalability, and availability. One of the enhancements is the ability to add encrypted databases to an AlwaysOn group. Encrypted databases were allowed in earlier versions of AlwaysOn, however they could not be accessed if there was a failover to a secondary replica […]

Continue reading
1 5 6 7 8 9 21