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...
Database Checkpoints in SQL Server
In this article, we will talk about SQL Server Checkpoints. To enhance performance, SQL Server applies modifications to database pages in...
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...
ROLLBACK TRUNCATE in SQL Server
Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all...