SQLAuthority News – Download Whitepaper – Understanding and Controlling Parallel Query Processing in SQL Server

My recently article SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database has received many good comments regarding MAXDOP 1 and MAXDOP 0. I really enjoyed reading the comments as the comments are received from industry leaders and gurus. I was further researching on the subject and I end…
Read More

SQL SERVER – FIX ERROR 3702 Cannot drop database “MyDBName” because it is currently in use

I often go to do various seminars and presentations at various organizations. During presentations I often create and drop various databases for the demonstration’s purpose. Recently in one of the presentations, I tried to remove my recently created database, I got following error 3702 which is related to user cannot drop database.

Read More