Tag: query performance

Traditional and Natively Compiled Scalar-Valued User-Defined Functions

Languages & Coding, T-SQL

In the software programming world, there are several approaches used by developers that help them...
Read More

Compare Execution Plans in SQL Server

Database administration, Database Optimization & Structure

Database Administrator always makes an effort to tune SQL Server query performance. The first step in tuning query performance is to...
Read More

Exploring SQL Server 2016 Query Store GUI

Database development, Statements

Introduction Query store is a new feature, introduced in SQL Server 2016, that allows database administrators to historically review...
Read More

Performing Data Changes Audit Using Temporal Table

Database administration, Tables, Work with data

SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using normal...
Read More

SQL Server Database Scoped Configurations and Automatic Plan Correction

Automation, Database administration, Performance Tuning

In this article, we will examine Database Scoped Configurations and SQL Server 2017 Automatic Plan Correction. Microsoft added new features...
Read More

SQL Server Table Partitioning and Partitions Tutorial

Database development, Tables

Problem In this article, we will focus on the demonstration of table partitioning. The simplest explanation of table partitioning can be...
Read More

T-SQL BEST Practices

Languages & Coding, T-SQL • 3 Comments

In this article, we will discover some best practices of T-SQL queries. Badly written queries can...
Read More

Real-Time Operational Analytics and Non-Clustered Column Store Index

Database development, Indexes

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

SQL Server Trigger: Understanding and Alternatives

Database development, Triggers

The SQL Server trigger is a special type of stored procedures that is automatically executed when an event occurs in a specific database...
Read More

Example of Improving Query Performance with Indexes

Database administration, Database development, Indexes, Oracle, Performance Tuning

In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle...
Read More