MSSQLTips: Tip #46 – Safely Dropping Unused SQL Server Indexes

There are many resources online about finding and dropping unused SQL Server indexes, but there a number of issues related to unused indexes removal. How can we make sure that we are dropping unused SQL Server indexes safely? What are the potential issues?

Some DBAs probably have an unused indexes review as part of their routine. Experienced DBAs understand the consequences of index removal and the potential issues. In this tip, we will review some of these potential issues and we will provide you with a couple of examples when you should just leave the indexes as is (even if they are unused).

Please read the latest MSSQLTips post: “Safely Dropping Unused SQL Server Indexes“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #24 – SQL Server 2016 Query Store Queries

What are some practical applications of using the Query Store? What queries can be run against the Query Store? What sort of questions can I get answered?

Please read my latest MSSQL Tip: “SQL Server 2016 Query Store Queries“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #23 – SQL Server 2016 Query Store Example

New tip with example on how to use SQL Server 2016 Query Store, how to track multiple execution plans and how to force an efficient plan.

Please read the latest MSSQL Tip: “SQL Server 2016 Query Store Example“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #21 – SQL Server 2016 Query Store Introduction

As promised here is the first tip about SQL Server 2016 Query Store.

Please read the MSSQL Tip here: “SQL Server 2016 Query Store Introduction“. Stay tuned for more tips about the Query Store.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/

SQL Server 2016 CTP 2.2 is now available

SQL Server 2016 CTP 2.1 became available on June 24th 2015 about one month after Microsoft made public SQL Server 2016 CTP 2.0.

Today CTP 2.2 is available for download. Among all of the new Database Engine features Query Store stands out as a great addition to the performance tuning tools currently available out of the box.

Stay tuned for the MSSQLTips articles about SQL Server 2016 Query Store.

MSSQL Tips: Tip #16 – Several Methods to collect SQL Server Stored Procedure Execution History

In this tip you can learn about stored procedures execution history monitoring.

Please read the latest MSSQL Tip: “Several Methods to collect SQL Server Stored Procedure Execution History“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #15 – Automated collection of SQL Server database connections for monitoring

Here is a tip about automated monitoring of the high number of SQL Server connections.

Please read my latest MSSQL Tip: “Automated collection of SQL Server database connections for monitoring“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #13 – Monitor SQL Server Database File Growth with WMI Alerts

In this tip you can find another example of WMI alerts use.

Please read the latest MSSQL Tip: “Monitor SQL Server Database File Growth with WMI Alerts“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #10 – Different Ways to Find SQL Server Object Dependencies

In my 10th MSSQLTips tip you will learn about different ways to display objects dependencies and you will learn how to use provided scripts in your day-to-day work.

Please read the latest MSSQL Tip: “Different Ways to Find SQL Server Object Dependencies“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.