I just want to talk briefly about how we can access sql server instance running either on your personal computer or on a network. Authentication is a big issue for any server because if some successfully passed this gate, they have access to your server and can do lot of things so SQL server provides […]
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 […]