Hello, I’m briefly going to discuss one topic that can easily throw you under the bridge if you did not take the time to actually practice it. Pivot and unpivot is not your regular every day TSQL term but its good to know it and use it when needed. We are going to take baby steps […]
Hello world, l hope everyone is having peace where ever you are. This week has been a tough one for the United States, I’m talking in regards of the Theater shooting in Colorado. It’s the craziest thing to happen and I extend my my prayers and condolence to the bereaved families and prayers to those […]
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 […]
