Database Checkpoints in SQL Server
In this article, we will talk about SQL Server Checkpoints. To enhance performance, SQL Server...
SQL Server: DELETE vs TRUNCATE
T-SQL provides two keywords that allow you to delete data from a table. They are DELETE and TRUNCATE. These are alike in what they are...
SQL Server Unit Testing with tSQLt Framework
In this article, we will talk about the tSQLt framework — a free database unit testing framework for Microsoft SQL Server. You...
SQL Server Transaction Log — Part 2
This is the second article in the series dedicated to SQL Server transaction log and its...
ROLLBACK TRUNCATE in SQL Server
Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all data loss. The worst thing is that you...
SQL Server Transaction Log — Part 1
Every SQL Server database contains one or more transaction log files in addition to data files. Log files record all transactions and...
Retrieving SQL Server Metadata with Help of T-SQL
This article contains a list of scripts that mine the SQL Server metadata in the various system...