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