Aim: Determine which SQL Server Features are installed and configuration settings. To determine which features are installed on a server, run the Discovery Report which…
Tag: T-SQL
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…
Aim: Test speed of memory optimized tables & natively-compiled stored procedures against disk-based tables & stored procedures. There are a couple of examples available from…