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...
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...
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...
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 other two. If one is hit, the other two take...
Using Indexes in SQL Server Memory-Optimized Tables
Introduction In this article, we will discuss how different types of indexes in SQL Server...
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 introductory article — SQL Server In-Memory OLTP,...
SQL Server In-Memory OLTP: The Basics
This is the first article in a series of articles about In-Memory OLTP. It helps you to understand...