The In-Memory database and caching wars: how SQL Server 2014 In-Memory OLTP compares with SafePeak caching, and when each one fits best.
SQL SERVER – Keeping MSDB System Database Lean and Fit – Notes from the Field #033
The MSDB database is one of the most ignored on any server. Tim shares his tricks to keep the MSDB system database lean, fit and at its best settings.
SQL SERVER – SQL Server High Availability Options – Notes from the Field #032
Not sure which of the High Availability options fits your organization? Tim Radney explains the SQL Server choices in very simple words.
SQL SERVER – Iridium I/O – SQL Server Deduplication that Shrinks Databases and Improves Performance
Iridium I/O uses SQL Server deduplication to shrink databases and improve performance, even when a query is already tuned or the app cannot be changed.
SQL SERVER – Faster SQL Server Databases and Applications – Power and Control with SafePeak Caching Options
A closer look at SafePeak caching options, the advanced data caching settings and tools that can speed up SQL Server databases and applications.
Memory-Optimized Table Variables
Memory-optimized table variables can avoid tempdb work, but they need a filegroup, indexed table type, memory budget, and workload tests.
Index Usage Stats Reset: Reading Them Without Being Fooled
Use index usage stats reset in SQL Server with practical examples, clear checks, and the limits you need before changing your database.