Aim: To adjust the size of the SQL Agent job history log to retain more or less history as required. On some SQL Servers with…
Tag: Performance
Recently I came across a situation where a view took an excessive amount of time to return results when “SELECT TOP …” was applied to…
Some time ago I learned that the clustered index (CI) key is implicitly included in all non-clustered indexes (NCIs). This means that if I am creating…
I recently found out that when tuning stored procedures (e.g. for parameter sniffing), you shouldn’t try to tune the queries separately using local variables, e.g.…
Another performance issue identified was the use of Cursors when applying Table-Valued Functions to large datasets, whereby the TVF was applied to each individual record…
I recently worked with a team on a project to improve performance of a legacy system and one of the issues we encountered was low…