Statements

Eliminating Duplication of Where Expressions in Application

09:46 Database development, Statements

Assume you have products and categories. A client says that it is necessary to use other business...
Read More

Better ALTER than DROP

15:12 Database development, Statements

In this article, I am going to provide a construction for deleting an object before creating it....
Read More

What Can Query Plan Tell?

09:23 Database development, Statements

Introduction SQL query describes the expected result, not the way to get the result. The set of specific steps the server must take to...
Read More

Optimizing Overlapping Queries Part 1: Introduction & Enhanced T-SQL Solution

13:09 Database administation, Perfomance Tuning, Statements

Databases that serve business applications should often support temporal data. For example, suppose...
Read More

Database Checkpoints in SQL Server

08:24 Database development, Statements

In this article, we will talk about SQL Server Checkpoints. To enhance performance, SQL Server applies modifications to database pages in...
Read More

SQL Server: DELETE vs TRUNCATE

07:05 Database development, Statements

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...
Read More

ROLLBACK TRUNCATE in SQL Server

07:00 Database development, Statements

Have you ever accidentally executed the TRUNCATE command on a wrong table? This will lead to all...
Read More
Close