I will be presenting a day-long pre-conference at SQLPASS on the topic – 21 Essential Scripts: Jump-Start Performance Tuning for Accidental DBAs and regular session as well. Lots of people are asking me what I will be covering in the session, so I have decided to give sneak preview about it on the blog of PASS.
Do Index Reorganization Update Statistics? – Interview Question of the Week #196
Question: Do Index Reorganization Update Statistics?
Answer: No. Index Reorganization does not update Statistics of your database.
How to Find Queries Using an Index From SQL Server Plan Cache? – Interview Question of the Week #195
Question: How to Find Queries Using an Index From SQL Server Plan Cache?
SQL SERVER – Rebuild Index Job Failed – Error: 9002 – The Transaction Log for Database ‘PinalDB’ is Full Due to ‘LOG_BACKUP’
Sometimes we have an error in SQL Server job history which are not very accurate to find the cause of an issue. In this blog we would explore a situation where rebuild index job was failing with error 9002 – The transaction log for database ‘PinalDB’ is full due to ‘LOG_BACKUP’.
How to Find Cardinality or Uniqueness for any Column? – Interview Question of the Week #177
Question: How to Find Cardinality or Uniqueness for any Column?
SQL Authority News – Brent Ozar Unlimited Office Hours 2018/4/4 – Fun Experience
It was my pleasure and honor that I was invited to the Brent Ozar Unlimited Office Hours. During the office hours, we received quite a few interesting questions, some were very complicated and some were super fun. However, the best part of attending the office hours was the company. I was fortunate to have Brent, Richie, and Tara along with me in this office hours. Please note that the questions which we discussed during the session were asked live.
Practical Real World Performance Tuning – Frequently Asked Questions
Earlier this month, I announced my very first online live training course Practical Real World Performance Tuning along with Brent Ozar. As soon as the course was announced we received your overwhelming response. I am truly thankful to you to fill up the available seats very quickly. While I am writing this blog posts, we have very few limited seats are available. One the seats are filled up, we will have to close the registration. If you miss this opportunity this year, do not worry, you can always register in the future when we return again in 2019 or 2020.