So i had installed SQL Server 2012 on my machine and i had used it from Visual Studio all worked fine. Till i decided to give access of my database to one of my team mate. When he…
Finding UnUsed Tables in SQL Server
After being given a chance to have a look at the Database of a company for coming up with maintenance plan i had a peek into the DB. And to my astonishment i found over 60% of the table…
UPDATE failed because the following SET options have incorrect settings: ‘ARITHABORT
Today i tried to create a filtered index , i was able to create them alright. However, intrestingly when i tried to update record i got the following error“UPDATE failed because the following SET options have incorrect settings: ‘ARITHABORT’. Verify…
SHOWPLAN permission denied in Database Engine Tuning Advisor
Last week one of my colleagues asked to me to provide ShowPlan rights. Now , all of the developers in our team are part of the group which is sysadmin on the test servers. So i was bit confused as to…