Enabling Growth Through Performance
Enabling Growth Through Performance

Posts by Vroom Performance

SQL Server Memory-Optimized Tables

RAM (Memory)

Leveraging In-Memory Technology for Improved Performance Introduction SQL Server’s memory-optimized tables, introduced in SQL Server 2014, are designed to significantly improve performance by leveraging in-memory technology. These tables store data directly in memory, enabling faster access and reducing the need for disk-based storage. In this article, we will explore memory-optimized tables, their benefits, and how…

Read More

VPS Change Log 1.11.8

Major additions No major changes with this release. Enhancements No notable enhancements with this release. Bug fixes Computer tag fixes. No longer shows tags for inactive computers. Fixed crash when clicking “clear selection” on empty tag list. Report modifications, additions and bug fix. Added announcement group ribbon icon. Changed licence dates to UTC. Removed bad…

Read More

VSSD Change Log 1.0.1.5

Major additions n/a Enhancements Added full support for HierarchyId. Added full support for all custom data types. Now shows project wizard when existing project is closed. Bug fixes Canceling a scripting operation is now quick. Resolved issues when foreign-keys contain circular references.

Read More

VSSG Change Log 1.0.3.0

Major additions Data exports can now be split into multiple files for easier execution. All automation scripts are now YAML instead of json. Implemented set-based data operations for much faster merges. Enhancements Data export memory foot print reduced by orders of magnitude. Exported data is now 10-times smaller than before. Added ability to include NOCOUNT…

Read More

VSSG Change Log 1.0.2.1

Major additions Added ability to modify existing views, procs, functions and triggers. Updated UI and added easier output options. Added async with cancel to database loading. Enhancements Renamed example json so better reflect its purpose. Updated to latest SQL Management Objects. Bug fixes Excluded computed columns from generation.

Read More