Counting references to a record in a table via Foreign Keys
I have recently needed to solve the task for my own purpose: to calculate the number of external...
Rules for Implementing TDD in Old Project
The article “Sliding Responsibility of the Repository Pattern” raised several questions, which are very difficult to...
Events and Threads in .NET
I’d like to tell you straight off that this article will concern not threads in particular, but events in the context of threads in...
Introducing Common Table Expressions in SQL Server
Common Table Expressions, or CTE for short, is simply a technique to create a temporary set of...
Introduction to Temporary Tables in SQL Server
A temporary table in SQL Server, as the name suggests, is a database table that exists temporarily on the database server. A temporary...
Why Using Unit Tests is a Great Investment into High-Quality Architecture
I have decided to write this article in order to show that unit tests are not only a tool to grapple with regression in the code but is...
Eliminating Duplication of Where Expressions in Application
Assume you have products and categories. A client says that it is necessary to use other business...
Better ALTER than DROP
In this article, I am going to provide a construction for deleting an object before creating it....
What Can Query Plan Tell?
Introduction SQL query describes the expected result, not the way to get the result. The set of specific steps the server must take to...
Optimizing Overlapping Queries Part 1: Introduction & Enhanced T-SQL Solution
Databases that serve business applications should often support temporal data. For example, suppose...
