Update: Please read the summary post of all the 11 Limitation of the view SQL SERVER – The Limitations of the Views – Eleven and more… Let us learn about Index Created on View not Used Often.
SQL SERVER – Few Notes on Fast Track Data Warehouse
I recently delivered fast track data warehouse training. This training was very challenging as this training requires very specific hardware and extremely different way of looking at data warehousing. While training I have made few notes and I will now share the same notes with you. Please note that this…
Read MoreSQLAuthority News – Social Media Confusion – Twitter, FaceBook, LinkedIn and Me
No story today – I am sure all of you know what I want to talk today. I am indeed not happy with how social media is evolving. There was a time when every social media has its own style and concept. Today wherever I go, I see the same…
Read MoreSQL SERVER – Soft Delete – IsDelete Column – Your Opinion
Just a day ago, I was reading the blog post of Michale J Swart. If you are a regular reader of this blog, I am sure you will be familiar with him. He is a very interesting blogger for sure. He recently wrote an article about Ten Things I hate…
Read MoreSQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server
In my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically…
Read MoreSQLAuthority News – Fathers and Daughters
Today I am very happy as my daughter is one year old. I have no words to explain how lucky I am to be father of daughter. She is everything to me and my wife have (sweet) complain that I stopped paying attention to her since our daughter has arrived.…
Read More
SQLAuthority News – A Monthly Roundups of SQLAuthority Blog Posts – Updated 2019
Monthly roundups are very refreshing as it gives me a chance to go back and see what did I do last month. Let us learn in this blog post.
SQLAuthority News – SQL Server Performance Optimization – Seminar Series
I am very glad that I will be presenting my very first seminar training series worldwide. This event is called the Solid Quality DIRECTIONS Seminar Series. I am very fortunate that I am given this opportunity to work under prestigious organizations. I have been with Solid Quality Mentors for more…
Read MoreSQLAuthority News – Download – SQL Server Monitoring Management Pack
The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1 and R2 to discover SQL Server 2005, 2008, and 2008 R2. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. The monitoring provided by this management pack includes performance, availability, and…
Read More
SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script
I had a very interesting situation at my recent performance tuning project. I realize that the developers there were running very large dataset queries on their production server randomly. I got alarmed so I suggested their developer not to do that on the production server; instead, they could create some alternate scenarios where they could synchronize database and query on the same server. The production server should not be used for development work. It should be queried with proper methods (queries, Stored Procedures, etc.), supporting production application.