Query performanceOften the first step you take to improve your SQL Server query performance is to add indexes to tables. This is also usually true for...
Memory-Optimized Tables -- Non-durable v.s. variableIn-Memory OLTP provides the following objects that can be used for memory-optimizing temp tables and table variables: Memory-optimized...
Extreme Transaction Processing (XTP)The SQL Server XTP Databases performance object provides In-Memory OLTP database-specific counters. In other words, the SQL Server XTP...