Category Archives for "Installation"

Nov 09

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
Nov 09

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
Jun 09

SQL 2016 SSMS Download Location

By SQLRx Admin | Installation , SQL Administration , SQL Server

Now that SQL Server 2016 has been released (https://blog.sqlrx.com/2016/06/01/sql-server-2016-rtm-available/ ), DBA’s are going to notice that the Management Studio tools are not in the list of options to install. Starting in SQL 2016, SSMS is a separate download and install. You can find the download at: https://msdn.microsoft.com/library/mt238290.aspx The install notes say that it can be […]

Continue reading
>