SQL Server

Virtual Columns and Functional Indexes

Database development, Indexes, MySQL, Oracle, PostgreSQL, SQL Server, Tables

Much too often, we see poorly written complex SQL queries running against the database tables. Such...
Read More

Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables

Database development, SQL Server, Statements, Tables

INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML operations based on comparing two tables or...
Read More

DevOps Solutions for Database Development Automation

Programming, SQL Server

What is DevOps? Database DevOps is a philosophy that comprises the following concepts: automating the development, deployment,...
Read More

Create Indexed Views in SQL Server

SQL Server

Introduction You would have already heard about views in databases. We create views for a number of...
Read More

Structured Query Language – Importance of learning SQL

Database administation, Database development, MySQL, Oracle, PostgreSQL, SQL Server • One Comment

Computer programming language is a set of detailed instructions for computers or machines for performing specific actions. Through a...
Read More

Dynamic SQL vs Stored Procedure

SQL Server

Dynamic SQL and stored procedures are among the most important SQL Server components. Both have advantages and disadvantages. That’s...
Read More

SQL Server Index Backward Scan: Understanding and Performance Tuning

SQL Server

Table indexing strategy is one of the most important performance tuning and optimization keys. In...
Read More

Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer

Database administation, Perfomance Tuning, SQL Server

Recently, I came across an application that generated DB queries. I understand that there is nothing new about that, but when application...
Read More

Automatic Data Collection: Database Files and Logical Drives in MS SQL Server

Automation, Database administation, SQL Server

Introduction It is important for a database administrator to know when there is no space on a disk. Thus, it is better to automate the...
Read More
Close