Optimizing Overlapping Queries Part 1: Introduction & Enhanced T-SQL Solution
Databases that serve business applications should often support temporal data. For example, suppose...
SQL Server: Useful Tips for Newbies
In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
Automating Index Defragmentation in MS SQL Server Database
Preface The World Wide Web offers a bunch of information on SQL Server index defragmentation or SQL Server index rebuild. However,...
Insight into SQL Server Unique Constraints
What are unique key constraints? A unique constraint is a rule that restricts column entries to...
Extended Events for SSAS
Cubes require frequent monitoring since their productivity decreases quite often (slowdowns during query building, processing time...
CHECK Constraints in SQL Server
In this article, we will talk about CHECK constraints. We will see how to add CHECK constraints to SQL Server table columns and discuss the...
Pivot Tables in MySQL
Briefly about Pivot tables This article deals with the transformation of table data from rows to...
Deploying Database from Source Control
These days, development teams start new projects from choosing a version control system. There are many benefits of source control systems...
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...
