There are a lot of basic questions I get that inquires about being an MVP.
SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4
Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more…
SQL SERVER – Disabled Index and Index Levels and B-Tree
This blog post is written in response to T-SQL Tuesday hosted by Michael J. Swart. Recently, I presented a session at the Microsoft Bangalore office. Everybody eagerly wanted to learn more, to the extent that they wanted a mentor to train each of them in order to move on to…
Read MoreSQL SERVER – What are Wait Types, Wait Stats and its Importance
Earlier last month Solid Quality India announced SQL Server Health Check Service and since then, it has got very good response from the industry. However, the only question we are be asked all the time is: “What is “SQL Server Resource Wait Stats Analysis” and how can it be useful?”What…
Read MoreSQL SERVER – Soft Delete Conversation – Your Opinion Needed
Last Week I wrote article about SQL SERVER – Soft Delete – IsDelete Column – Your Opinion and this article has got excellent community response. There have been some very interesting feedback on both the side. There are few opinions where expert have explained the conversation very balanced way. I…
Read MoreSQLAuthority News – Download – Microsoft SQL Server 2008 R2 Best Practices Analyzer Whitepaper
I had previously written article on SQL SERVER – Introduction to Best Practices Analyzer – Quick Tutorial. Microsoft has come up with white paper regarding same Best Practice Analyzer. In the new R2 version the SQL BPA introduces advanced capabilities in conjunction with the PowerShell architecture and also raises the…
Read MoreSQL SERVER – Find Automatically Created Statistics – T-SQL
Earlier, I wrote about my experience at an organization here: SQL SERVER – Plan Cache – Retrieve and Remove – A Simple Script. This blog post briefly narrates another experience I had at the same organization. When I was there, I also looked at the statistics and found something that…
Read More
SQL SERVER – Quickly Upgrade Your SQL Server
In this blog post, I will talk about how you can use Docker to quickly upgrade your SQL Server. I discuss docker in this blog post.
SQL SERVER – Find Row Count in Table – Find Largest Table in Database – Part 2
Last Year I wrote article on the subject SQL SERVER – Find Row Count in Table – Find Largest Table in Database – T-SQL. It is very good to see excellent participation there. In my script I had not taken care of table schema. SQL Server Expert Ameena has modified…
Read MoreSQL SERVER – Index Levels and Delete Operations – Page Level Observation
I wrote an article before on SQL SERVER – Index Levels, Page Count, Record Count and DMV – sys.dm_db_index_physical_stats. In that article, I promised that I would give a follow up post with a few more interesting details. I suggest that you go over the earlier article first to understand…
Read More