Once I was in a situation where there was a disaster faced by my client. They lost the drive which was having transaction log file. Since they did not have effective monitoring, they realized that the backup jobs were failing. So essentially they only have MDF files for user databases and they were left with option to rebuild the log. Let us learn about how file activation failure can create an interesting error.
SQL SERVER – Creating Clustered ColumnStore with InMemory OLTP Tables
When SQL Server 2016 was released, there were a number of enhancements that were discussed around how InMemory OLTP removed which were as limitations. I personally saw some real boot to some of the capabilities coming into InMemory OLTP especially around the concept called as Operational Analytics that Microsoft calls in this release. I am going to talk about this concept in my SQLPass session later this month in October but here is a teaser for what I learnt from this concept.
Personal Technology – Expanding to Open Folder Working with Windows 10
We are all hard wired when it comes to doing certain tasks. I have attended tons of sessions at the local SQL Server user group meets and it amazes me every time to what I didn’t know about the tools that I use often. Every time when I attend sessions from my friend Balmukund or others from the community – they show a trick or two using SQL Server Management Studio that makes me rethink how I would be working the very next day using these methods. I think it is part of learning and that is never going to stop. Let us see about tips about Windows 10.
10th Anniversary of SQL Authority – Thank YOU!
10 years ago, today I started to blog, at https://blog.sqlauthority.com – I had no idea where this journey will bring me. I honestly had no idea. Lots of people ask me so many questions about blog so today, let me answer five of the most popular questions, which I keep on receiving. Today is the 10th Anniversary of SQLAuthority.com
SQL SERVER – Unable to Bring SQL Online – DoSQLDataRootApplyACL : Failed to Create Directory Tree at SQLDataRoot
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!
SQL SERVER – Unable to Recycle ERRORLOG Using sp_cycle_errorlog
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.
Performance Comparison EXCEPT vs NOT IN – Interview Question of the Week #095
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?
SQL SERVER – FIX Error: Maintenance plan scheduled but job is not running as per schedule
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”
SQL SERVER – Configuring Startup Options for SQL Server Management Studio
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.
Error: Msg 1904 The statistics on table has 65 columns in key list
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.