SQL Server Settings Optimization Tips:
You can increase the ‘min memory per query’ option to improve the performance of queries that use hashing or sorting operations, if your SQL Server has a lot of memory available and there are many queries running concurrently on the server.
The SQL Server will automatically allocate, at a minimum, the [...]
Filed under: SQL Optimization | Tagged: Advance SQL tips and tricks, Database Optimization Tips, Microsoft SQL server, MSSQL, MSSQL server, SQL Database Optimization Tricks, SQL Database Settings Optimization Tips, SQL help, SQL Optimization, SQL Optimization Tips, SQL Server, SQL server tips, SQL Tips, SQL tips for programmer, sqlhelp | 1 Comment »
