Automatic Data Collection of Database Schema Changes in MS SQL Server
Introduction Have you ever faced a situation when you need to make changes in a stored procedure or...
Automatic Data Collection about Completed Tasks in MS SQL Server
Introduction It is important for a database administrator to know what tasks and how have they been completed. To simplify this process, it...
Optimizing Overlapping Queries Part 1: Introduction & Enhanced T-SQL Solution
Databases that serve business applications should often support temporal data. For example, suppose a contract with a supplier is valid for...
Automatic Deletion of Stuck Processes in MS SQL Server
Introduction There are situations when applications keep the database connection for a long period...
Comparing Objects by Value. Part 6: Structure Equality Implementation
We have already analyzed peculiarities of structs of the .NET framework that represent Value Types when comparing objects by value –...
Troubleshooting long running queries in MS SQL Server
Preface There is an information system that I administer. The system consists of the following components: 1. MS SQL Server database 2....
Implementing SQL Server Performance Indicator for Queries, Stored Procedures and Triggers
Preface Sooner or later, a DB administrator would like to have a performance indicator for SQL...
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...
XML performance tips
Parsing data from XML using XQuery is a routine practice. In order to do this most effectively, little effort is required. Suppose we need...
Everything you should know about SQL Server JOINS
The focus of this article is going to be on utilizing JOINs. We will start off by talking a bit...
