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.
SQL SERVER – Reducing CXPACKET Wait Stats for High Transactional Database
While engaging in a performance tuning consultation for a client, a situation occurred where they were facing a lot of CXPACKET Waits Stats. The client asked me if I could help them reduce this huge number of wait stats. I usually receive this kind of request from other client as…
Read MoreSQL SERVER – Get All the Information of Database using sys.databases
Earlier I wrote blog article SQL SERVER – Finding Last Backup Time for All Database. In the response of this article I have received very interesting script from SQL Server Expert Matteo as a comment in the blog. He has written script using sys.databases which provides plenty of the information…
Read MoreSQLAuthority News – SQL Server Denali CTP1 – Release Date November 9, 2010
I am very excited as I was about to witness SQL Server 2011 – Code Named “Denali” is released on November 11, 2010 at SQLPASS. I will write a detail report for the same in future. You can download CTP1 right away right now and install on your machine. The…
Read MoreSQL SERVER – Get Database Backup History for a Single Database
I recently wrote article SQL SERVER – Finding Last Backup Time for All Database and requested blog readers to respond with their own script which they use it Database Backup. Here is the script suggested by SQL Expert aasim abdullah, who has written excellent script which goes back and retrieves…
Read MoreSQL SERVER – Recycle Error Log – Create New Log file without Server Restart
The job of a consultant is always interesting – sometimes one becomes very busy and at times, over busy. I have been overwhelmed with recent performance tuning engagements. In one of the recent engagements, a large number of errors were found in the server. I noticed that their error log filled up very quickly. I also noticed a very interesting action by their DBA. I observed that after we make some changes in the server to avoid the errors, the DBA restarted the server. I asked him the reason for doing so. He explained every time that when he restarts the server, a new error log file is created. The current log file is renamed as errorlog.1; errorlog.1 becomes errorlog.2, and in a similar way, it continues. This way, after making some change, we can watch the error file from the beginning.
SQLAuthority News – Why I am Going to Attend PASS Summit Unite 2010 – Seattle
I am once again attending SQLPASS this year.When I told this to my friend that I am going to SQL PASS again, he has the same question, which quite often many people ask. WHY? I had earlier wrote article on this subject. I am writing it again the same. The…
Read More
Is your SQL Server running slow and you want to speed it up without sharing server credentials? In my Comprehensive Database Performance Health Check, we can work together remotely and resolve your biggest performance troublemakers in less than 4 hours.
Once you learn my business secrets, you will fix the majority of problems in the future.
Have you ever opened any PowerPoint deck when you face SQL Server Performance Tuning emergencies? SQL Server Performance Tuning Practical Workshop is my MOST popular training with no PowerPoint presentations and 100% practical demonstrations.
Essentially I share my business secrets to optimize SQL Server performance.