Tag Archives for " DMV "

Aug 23

Using sys.sql_expression_dependencies as a Single Source to Find Referenced and Referencing Objects

By Lori Brown | Dependencies , Object Information , SQL Administration , SQL Development , SQL Server

I thought I would continue to expand on ways to view dependencies.  This post will give you an alternate way to find things referencing tables and finding things that are referenced by a stored procedure or view after my previous posts on the subject.  See these (https://www.sqlrx.com/finding_things_sql_that_reference_a_table/ & https://www.sqlrx.com/how-to-find-the-objects-and-columns-a-stored-procedure-or-view-uses/ ) A different way to find […]

Continue reading
Dec 14

Rx for Demystifying Index Tuning Decisions – Part 8

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

Review Due to the holiday week, this part will be shorter than usual. In Parts 1 through 7 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, […]

Continue reading
Dec 07

Rx for Demystifying Index Tuning Decisions – Part 7

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

Review In Parts 1 through 6 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, singleton lookups, and range scans Why index tuning should begin with […]

Continue reading
Nov 30

Rx for Demystifying Index Tuning Decisions – Part 6

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

Review In Parts 1 through 5 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID lookups, singleton lookups, and range scans Why index tuning should begin with […]

Continue reading
Nov 30

Rx for Demystifying Index Tuning Decisions – Part 5

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

Review Due to the holiday week, this part will be shorter than usual. In Parts 1 through 4 of this blog series the author discussed various aspects of SQL Server indices such as: Types of indices and their variations, e.g., clustered, nonclustered, filtered, and covering Physical versus logical index access methods, e.g., seeks, scans, key/RID […]

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 19

SQL 2017 Is On The Way!!

By Lori Brown | CTP , SQL 2017 , SQL Server

–By Lori Brown  @SQLSupahStah SQL Server 2017 is rolling our way like a big ole train. And, with the new features that are going to be available there may be quite a few shops that want to jump onboard. As of this writing SQL Server 2017 CTP 2.1 is available for download and testing. (https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2017-ctp/ […]

Continue reading
1 2 3
>