Here is one of email which I received from one of my clients where he mentioned that he was unable to bring SQL Online.
Pinal,
I need assistance in getting the failed SQL Server resource online on the node named “SQLDBN01” for the Cluster named “DBCLUSTER01 “.
I checked the event log and have all generic messages. Do you have any expert trick?
Thanks!
There are many DBAs who create jobs in SQL Server to recycle ERRORLOG files every midnight. They also increase the files from 6 to a bigger number so that they have data for more than 6 days.
During SQLPass summit, I was asked following question by one of the attendees. The question was about Performance Comparison of Except vs NOT IN. Let us quickly discuss this question.
Question: Which of the operator is better for query performance – EXCEPT or NOT IN?
This was one of the interesting issues I solved in many days. One of my clients contacted me and told that they have scheduled a maintenance plan to take t-log backup at 10 PM but it’s not running. When we look into the job history, it was not showing any history. Some problem statements like these are interesting because they look trivial and simple – yet they are convoluted and not straightforward to solve. Let us learn how to solve Error “Maintenance plan scheduled, but the job is not running as per schedule”
Yesterday I started my day early to get to a gym. I know this was the first day and I had loads of work pending to be completed at work too. This got me busy and I started to drive my car, oblivious of the fact that I had to take a turn which I missed. Just while crossing the junction I realized I had missed it. It was a bad start to the day as I wasted 5 minutes to retrace back to the original route. On second thought, this mistake from my side got me thinking. My mind was tuned to specific routes and this is the same thought process that got me the inspiration to write this post. Let us learn how to configure startup options.
SQL SERVER – Fix: Error: Msg 1904 The statistics on table has 65 columns in the key list. Let us learn how to fix in this blog.
Sometimes you need to know more about permissions on file, service account etc. to fix certain errors. In my recent visit to a customer location, one of the database developers came to me with a problem. He said that when he attaches MDF and LDF file to the SQL instance, attach is successful, but the issue was next to database name it was saying read-only. Let us see how we can FIX Error 5120.