Traditional and Natively Compiled Scalar-Valued User-Defined Functions
In the software programming world, there are several approaches used by developers that help them...
Compare Execution Plans in SQL Server
Database Administrator always makes an effort to tune SQL Server query performance. The first step in tuning query performance is to...
Exploring SQL Server 2016 Query Store GUI
Introduction Query store is a new feature, introduced in SQL Server 2016, that allows database administrators to historically review...
Performing Data Changes Audit Using Temporal Table
SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using normal...
SQL Server Database Scoped Configurations and Automatic Plan Correction
In this article, we will examine Database Scoped Configurations and SQL Server 2017 Automatic Plan Correction. Microsoft added new features...
SQL Server Table Partitioning and Partitions Tutorial
Problem In this article, we will focus on the demonstration of table partitioning. The simplest explanation of table partitioning can be...
T-SQL BEST Practices
In this article, we will discover some best practices of T-SQL queries. Badly written queries can...
Real-Time Operational Analytics and Non-Clustered Column Store Index
In this article, we will focus on real time operational analytics and how to apply this approach to an OLTP database. When we look at the...
SQL Server Trigger: Understanding and Alternatives
The SQL Server trigger is a special type of stored procedures that is automatically executed when an event occurs in a specific database...
Example of Improving Query Performance with Indexes
In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle...
