Here we go again, guys. Lets take care of our indexes this time. Fragmentation occurs in case of large number of DML Statements on a table which has indexes. When any record is deleted from the table which has any index, it creates a memory gap(empty space) which causes internal fragmentation.Fragmentation can also be caused […]
I’m going to discuss one important job of Database administrators, that is Disaster management and recovery. This is a critical aspect of the life of a database because there are lot of things that can cause a database to cease to exist. For example, a hacker can inject a SQL code into your front end […]
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 […]
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 […]