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 MoreSQL SERVER – A Brief Introduction to DW 2.0
The traditional form of storing digital data has been disk storage. However, the huge advances in technology means that there has been a huge need for data storage to evolve to keep up with the fast-changing times. Microsoft SQL Server has gone through a huge overhaul in order to keep…
Read MoreSQL SERVER – Corrupted Backup File and Unsuccessful Restore
If you are an SQL Server Consultant, there is never a single dull moment in your life. Quite often you are called in for fixing something, but then you always end up fixing something else! I was recently working on an offshore project where I was called in to tune…
Read MoreSQL SERVER – Taking Multiple Backup of Database in Single Command – Mirrored Database Backup
I recently had a very interesting experience. In one of my recent consultancy works, I was told by our client that they are going to take the backup of the database and will also a copy of it at the same time. I expressed that it was surely possible if…
Read MoreSQLAuthority News – SQLAuthority News – Presenting at South East Asia SharePoint Conference – Demo Details
I will be Presenting at South East Asia SharePoint Conference – Maintaining SQL Server at Optimal Performance for Blazing Fast SharePoint Site. I am very excited beuse this is going to be my very first series of presentations at SharePoint Conference. Since I posted details about the event, I have…
Read MoreSQLAuthority News – Book Review – Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners
Beginning SQL Joes 2 Pros: The SQL Hands-On Guide for Beginners Rick A Morelan, Doug Fritz Link to Amazon Short Review: This is one book that provides a solid fundamental to the reader along with hands-on experience and in-depth learning. Right now, an error-free book that is closer to real…
Read MoreSQL SERVER – Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it
I was recently getting following error in my StreamInsight Application. Could not connect to TCP error code 10061: No connection could be made because the target machine actively refused it. The solution was very simple, I had to enable exception of the my port in my windows firewall. The way…
Read More