TSQL Tutorial 22: Partition

Hello world, welcome to another important tutorial on database programming using TSQL. Today, we are going to talk about Partition. This is a very important concept and the main purpose of partitioning is to either speed up the performance of your operations or the ability to direct data to be stored on different storage locations […]

Read More

TSQL Tutorial 21: Triggers

Ok, here we go again guys/girls, lets try to learn something smart together. In this tutorial, I’m focusing on triggers. So What are triggers?  I like to keep things simple and stupid sometimes so l’ll say triggers are pre-compiled set of T-SQL statements that are automatically executed on a particular Data Definition Language, Data Manipulation Language […]

Read More

TSQL Tutorial 20: Index

In this tutorial, l’ll be discussing one of the most used database objects for optimizing the performance of queries. Indexes are very important and every developer should know when to create it or not. They are DB objects that are used to optimize the performance of T-SQL queries by organizing data in a particular pattern in a […]

Read More

TSQL Tutorial 19:Views

I’ve been a little busy for the past week which made me fall behind most of the things l wanted to write on the Learning Blog. There are more features added to the site because I’m trying to do something bigger and impact the world a little better. In this tutorial, I’m going to discuss […]

Read More