The Difference Between UNION and UNION ALL
Twice in the last six months, I have had to get involved in the resolution of an incident...
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...
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...
Understanding of SQL Server UPPER Function
There are many cases of SQL lowercase that we need to change for our purposes. For instance, we have keywords or strings of characters in...
SQL Server TRIM, LTRIM, and RTRIM Functions
The TRIM function of SQL Server is designed to remove leading and trailing whitespaces from a character string. A leading space is...
Basics of SQL Server Transaction Log
What is a Transaction Log? There is a requirement in relational database systems that transactions...
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 provides it for educational purposes as...
Moving SQL Server Table to Different Filegroup
Introduction A table is a logical structure. When you create a table, you typically would not care...