Workplace Encounters: Reclaiming Space from an Oversized Database
INTRODUCTION This document records steps, scripts, and ideology behind the maintenance performed on...
A Simple Use Case for Indexes on Primary Keys
Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a...
Simple SQL Server Functions to Solve Real-World Problems
Introduction Today’s article comes from a scenario we experienced in practice some time ago. We managed a card transaction system...
SQL Server TRIM, LTRIM, and RTRIM Functions
The TRIM function of SQL Server is designed to remove leading and trailing whitespaces from a...
Basics of SQL Server Transaction Log
What is a Transaction Log? There is a requirement in relational database systems that transactions must be durable. This is “D” in the...
MIN and MAX Aggregate Functions in SQL Server
SQL Server Functions In database systems in general and in SQL Server in particular, functions are pieces of code that take zero or one...
Microsoft SQL Server Express Edition Limitations and Versions
What is SQL Server Express? SQL Server Express Edition is a free edition of SQL Server. Microsoft...
Moving SQL Server Table to Different Filegroup
Introduction A table is a logical structure. When you create a table, you typically would not care which drives it sits on at the storage...
Fundamentals of Managing Datafiles in SQL Server
Introduction Datafiles are physical objects that constitute the most important part of the database system since they contain actual data....
Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables
INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML...