Grouping Data using the OVER and PARTITION BY Functions
The OVER and PARTITION BY functions are both functions used to portion a results set according to...
Implementing Incremental Load using Change Data Capture in SQL Server
This article will be interesting to those who often have to deal with data integration. Introduction Assume that there is a database where...
Using Indexes in SQL Server Memory-Optimized Tables
Introduction In this article, we will discuss how different types of indexes in SQL Server memory-optimized tables affect performance. We...
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...
Implementing a Common MS SQL Server Performance Indicator
Introduction There is often a need to create a performance indicator that would show database activity related to the previous period or...
Missing Indexes in MS SQL or Optimization in no Time
When executing a query, the SQL Server optimizer tries to find the best query plan based on existing indexes and available latest...
Database Optimization: Indexes
I noticed that very few people understand how indexes work in SQL Server, especially Included...
5 Ways to Update Data with a Subquery in Oracle SQL
A subquery is a powerful way to find the data you want to use for another query. They are often used in SELECT and UPDATE statements to...
Setting Database Access Permissions
Server security mainly depends on how correctly you can configure access permissions on objects. Providing a user with excessive...
Performance of Table Variables in SQL Server
In this article, we are going to touch upon the topic of performance of table variables. In SQL...
