By Jeffry Schwartz | Function , Performance Tuning , Query Tuning , SQL Development , SQL Server
If you are looking for major performance gains, the answer is no. However, if you are using SQL Server 2017 and developing new code, you should consider using the new String_agg function that is available on SQL Server 2017 because code that uses this function is so much more readable and easier to write and […]
Continue readingBy Ginger Daniel | Miscellaneous , Performance Tuning , Query Tuning , SQL Development , SQL Server
Jobs on a SQL server can take milliseconds or minutes to complete depending on the size and complexity of your query and also the SQL environment on which it’s executing. It’s important to have a baseline or at least be familiar with the normal amount of time your SQL jobs take to execute. For a […]
Continue readingBy 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