In memory Tables (OLTP) in Microsoft SQL Server Databases with Examples
What if 1 second of a transaction process is too long? You can tune your queries. But what if...
9 Best Practices for Writing SQL Queries
If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many...
Virtual Columns and Functional Indexes
Much too often, we see poorly written complex SQL queries running against the database tables. Such queries may take a very short or a very...
Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables
INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML...
DevOps Solutions for Database Development Automation
What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating the development, deployment,...
Create Indexed Views in SQL Server
Introduction You would have already heard about views in databases. We create views for a number of reasons. One of the main reasons for...
Structured Query Language – Importance of learning SQL
Computer programming language is a set of detailed instructions for computers or machines for...
Dynamic SQL vs Stored Procedure
Dynamic SQL and stored procedures are among the most important SQL Server components. Both have advantages and disadvantages. That’s...
SQL Server Index Backward Scan: Understanding and Performance Tuning
Table indexing strategy is one of the most important performance tuning and optimization keys. In SQL Server, the indexes (both, clustered...
Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer
Recently, I came across an application that generated DB queries. I understand that there is...
