News

Learn about monitoring and troubleshooting In-Memory OLTP memory usage, which has different patterns than disk-based tables in SQL Server. [!INCLUDE inmemory-md] consumes memory in different patterns ...
A business I support recently purchased an add on to the pos software they use. It uses .net 3 and sql server express 2005.Their support tech came out and installed some new hardware (not related ...
If screaming speed in data access is the most important thing in your life, SQL Server's durable in-memory, memory-optimized tables are your answer. They were good in SQL Server 2014 and they're even ...
If I have a SQL server process that has been running for some time, are there any methods to determining how much memory it really needs to run? I have a couple of low usage databases and I want ...
In SQL Server 2014, memory-optimized tables do not support cross-database transactions. This means you cannot access another database from the same transaction or the same query that also accesses a ...
In-Memory OLTP, a performance feature in SQL Server since 2014, allows you to speed up transactional workloads up to 30X. SQL Server 2016 and Azure SQL DB have In-Memory OLTP in public preview, and ...
In a move to speed online transaction processing (OLTP), Microsoft is adding in-memory capabilities into its SQL Server relational database management system.
Technical documentation for Microsoft SQL Server, tools such as SQL Server Management Studio (SSMS) , SQL Server Data Tools (SSDT) etc. - MicrosoftDocs/sql-docs ...