Here is the quick script I use find last backup time for all the database in my server instance.
SQL SERVER – Fix: Error: MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode.
I recently got email from blog reader with following error. MS Jet OLEDB 4.0 cannot be used for distributed queries because the provider is used to run in apartment mode. The fix of the same is very easy. Fix/Workaround/Resolution: sp_configure 'show advanced options', 1; GO RECONFIGURE; GO sp_configure 'Ad Hoc…
Read MoreSQL SERVER – Are you a Database Administrator or a Database Developer?
This blog post is written in response to T-SQL Tuesday hosted by Paul Randal. I think following questions has been always very interesting question for everybody who is working with SQL Server. Are you a Database Administrator or Database Developer? The answer of this question varies from organizations to organizations…
Read MoreSQLAuthority News – 4th Birthday of Blog – 20 Million Views – Blog Anniversary – A Milestone
Today is Nov 1, 2010. Four years ago, on the same day of the year 2006, Â I wrote my first blog without thinking or even understanding where this blog was going to. The reason I started blogging was very simple- I just wanted to keep a note of what I…
Read MoreSQLAuthority News – New Banner of Blog
As this blog is approaching 4th anniversary, I have decided to change few things in this blog. I have finally decided to change the blog banner and I have created internal poll for the blog banner. I have uploaded the winning banner as the title of the blog and I…
Read MoreSQL SERVER – Minimum Maximum Memory – Server Memory Options
I was recently reading about SQL Server Memory Options over here. While reading this one line really caught my attention is minimum value allowed for maximum memory options. The default setting for min server memory is 0, and the default setting for max server memory is 2147483647. The minimum amount…
Read More
SQL SERVER – List of all the Views from Database
My earlier article SQL SERVER – The Limitations of the Views – Eleven and more… has lots of popularity and I have been asked many questions on the view. Many emails I received suggesting that they have hundreds of the view and now have no clue what is going on and how many of them have indexes and how many does not have an index. Some even asked me if there is any way they can get a list of the views with the property of Index along with it.
SQLAuthority News – Blog of Nupur Dave on Windows Live
Blog are way to express ourselves; Blogs are bookmarks of my learning process and blogs reflects us. My Wife Nupur, an avid user of Windows Live, has decided to start blogging on the subject. There was lots of discussion between us regarding if she really wants to blog or keep her…
Read MoreSQL SERVER – SQL Challenge – SQL Puzzle – Query Creating Most TempDB IO Usage
Recently, there have been a lot of interesting concepts in various challenges. My friend Jacob Sebastian is running the SQLQuiz for the entire month, and it has been very popular and going just great. So here I thought I would put something very similar to the quiz bee. The award…
Read MoreSQLAuthority News – Database Performance for SharePoint Sites – Session Tomorrow in Singapore
I am all excited to present my very first session on Database Performance for SharePoint Sites. Here is the details for my session which is planned for tomorrow. Grand Copthorne Waterfront Hotel Singapore 392 Havelock Road Singapore 169663 My Sessions details: Maintaining SQL Server at Optimal Performance for Blazing Fast…
Read More