Tag: t-sql

Tips for Read/Write Locks Depending on Transaction Isolation Level in MSSQL

Database administation, Security

Read Uncommitted If data is being changed in one transaction, selection of this data (in other...
Read More

Optimizing Overlapping Queries Part 1: Introduction & Enhanced T-SQL Solution

Database administation, Perfomance Tuning, Statements

Databases that serve business applications should often support temporal data. For example, suppose a contract with a supplier is valid for...
Read More

SQL Server: Useful Tips for Newbies

Database development

In this article, we will discuss typical errors that newbie developers may face with while designing T-SQL code. In addition, we will have...
Read More

Everything you should know about SQL Server JOINS

Database administation, Work with data

The focus of this article is going to be on utilizing JOINs. We will start off by talking a bit...
Read More

CHECK Constraints in SQL Server

Constraints, Database development

In this article, we will talk about CHECK constraints. We will see how to add CHECK constraints to SQL Server table columns and discuss the...
Read More

Pivot Tables in MySQL

Database development, Tables • One Comment

Briefly about Pivot tables This article deals with the transformation of table data from rows to columns. Such transformation is called...
Read More

SQL Server In-Memory OLTP: The Basics

Database administation, Memory Optimization

This is the first article in a series of articles about In-Memory OLTP. It helps you to understand...
Read More

SQL Server 2016: New T-SQL Features

Languages & Coding, T-SQL

In this article, I would like to describe several new T-SQL features available in SQL Server 2016: DROP IF EXISTS, SESSION_CONTEXT, MAXDOP,...
Read More

Database Checkpoints in SQL Server

Database development, Statements

In this article, we will talk about SQL Server Checkpoints. To enhance performance, SQL Server applies modifications to database pages in...
Read More


Database development, Statements

T-SQL provides two keywords that allow you to delete data from a table. They are DELETE...
Read More