The Daily Dose

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

Rx for Demystifying Index Tuning Decisions – Part 4

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

Review In Parts 1 through 3 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

Bob Ward to speak at DFW BI & Analytics Community Meeting on 12/6

By SQLRx Admin | Lunch And Learn , SQL 2017 , SQL Server

Come see Bob Ward from Microsoft speak about “Fast and Furious: SQL 2017” at the DFW BI & Analytics Community Meeting on 12/6, 11:30-1:00 at Noah’s in Irving.  You can register on the “Event” section of the ISI website at www.isi85.com . The DFW Business Intelligence and Analytics Community welcomes Bob Ward of the Microsoft […]

Continue reading

Rx for Demystifying Index Tuning Decisions – Part 3

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

Review In Parts 1 and 2 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

Rx for Demystifying Index Tuning Decisions – Part 2

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

Review In Part 1 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 queries Determining […]

Continue reading

Rx for Demystifying Index Tuning Decisions – Part 1

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

Overview Indices are one of the most troubling and mysterious areas for DBAs and developers. Most understand that adding a badly needed index can yield dramatic query performance improvements, but how does one know what is needed? Many believe more indices are better, regardless of the number. Most fear deleting ANY existing indices, even when […]

Continue reading

Log Connections to SQL Instance

By Ginger Daniel | Helpful Scripts , Miscellaneous , SQL Administration , SQL Server

If you ever have a need to monitor connections to your SQL server, and any related information about the connections such as database, logins, etc., there are some DMVs that can give you tons of information. Previously you might have used the sys.sysprocesses table to derive much of this information, but this is being deprecated […]

Continue reading

Get Index Column Info with Includes for One or Many Tables

By Lori Brown | Helpful Scripts , Missing Indexes , Performance Tuning , Query Tuning , SQL Administration , SQL Development , SQL Server

I was recently working with one of my clients on some low hanging fruit type of query tuning. We had checked the cache for plans with missing index warnings in them and were trying to see if we could tweak and existing index or add a new index to speed things up. If you ever […]

Continue reading

Find Tables That Have Special Features Enabled

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

Find out if any of tables in your database have special features enabled using the queries below.  These features need to be understood and carefully managed. — CDC Enabled Tables select distinct t.name AS CDCTables from sys.tables t where t.is_tracked_by_cdc = 1   — File Tables — SQL 2012 + select distinct t.name AS FileTables from […]

Continue reading