Following on from my previous post about Instant Initialization of database files, SQL Server 2016 and above allows you to set this up as part…
Category: SQL Server Performance
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.…
Aim: Grant the relevant permissions to the SQL Server service account to allow for Instant Initialization of database files. Instant Initialization allows space to be…
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…