Stored Procedure to Get Server Storage Information in Server
As popular as the cloud services are nowadays, there’s still a good chunk of on-premises...
Workplace Encounters: Reclaiming Space from an Oversized Database
INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on a production database between 22nd...
In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples
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...
Workplace Encounters: Reclaiming Space from an Oversized Database
INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on...
Implementing Paging Using OFFSET FETCH NEXT in SQL Server
A database can have hundreds of thousands of records. It is easy to insert and select these records via database management systems like...
Planning of Disk Space for Databases
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,...
Understanding the Importance of Memory Setting in SQL Server
Memory is one among the resources forming the performance triangle—CPU and storage being the...
Using Indexes in SQL Server Memory-Optimized Tables
Introduction In this article, we will discuss how different types of indexes in SQL Server memory-optimized tables affect performance. We...
In Search of Fast Local Storage
Recently, I was involved in the development of the functionality that required a fast and frequent transfer of large volumes of data to...
Creating and Accessing In-Memory OLTP Databases and Tables
This is the second article in a series of articles about SQL Server In-Memory OLTP. The...
