by Rich Kreider
Microsoft made the following changes in their documentation (see screenshot above) to accurately reflect the memory limits on lower editions of SQL Server.
Edition Information: https://www.microsoft.com/en-us/sql-server/sql-server-editions
Estimate Memory Requirements for Memory-Optimized Tables
Key Points
The limits for In-Memory OLTP data is per database.
The limits for Columnstore segment cache is per SQL Server instance across all the databases in the instance.
Example Scenario
A Continue Reading...
This is a T-SQL that will show all the last access date and time for Select, tables in a database.
Continue Reading...
A sample T-SQL for determining uptime of a Microsoft SQL Server.
Continue Reading...