Memory Optimization

Get Your SQL Server Database Size with Ease: Stored Procedures in Action

Database administration, Memory Optimization

As popular as the cloud services are nowadays, there’s still a good chunk of on-premises...
Read More

Workplace Encounters: Reclaiming Space from an Oversized Database

Database administration, Memory Optimization

INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd...
Read More

In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples

Database administration, Memory Optimization, SQL Server • 2 Comments

What if 1 second of a transaction process is too long? You can tune your queries. But what if it’s not enough, can you still step up...
Read More

Workplace Encounters: Reclaiming Space from an Oversized Database

Database administration, Memory Optimization

INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on...
Read More

Implementing Paging Using OFFSET FETCH NEXT in SQL Server

Database administration, Memory Optimization

A database can have hundreds of thousands of records. It is easy to insert and select these records via database management systems like...
Read More

Planning of Disk Space for Databases

Database administration, Memory Optimization

Do you think about something when you create a new database? I guess that most of you would say no, since we all use default parameters,...
Read More

Understanding the Importance of Memory Setting in SQL Server

Database administration, Memory Optimization

Memory is one among the resources forming the performance triangle—CPU and storage being the...
Read More

Using Indexes in SQL Server Memory-Optimized Tables

Database administration, Database development, Indexes, Memory Optimization, Performance Tuning

Introduction In this article, we will discuss how different types of indexes in SQL Server memory-optimized tables affect performance. We...
Read More

In Search of Fast Local Storage

Database administration, Memory Optimization • One Comment

Recently, I was involved in the development of the functionality that required a fast and frequent transfer of large volumes of data to...
Read More

Creating and Accessing In-Memory OLTP Databases and Tables

Database administration, Memory Optimization

This is the second article in a series of articles about SQL Server In-Memory OLTP. The...
Read More
Close