SQLAuthority News – Monthly Roundup of SQLAuthority Blog Posts

Since I started the monthly round up of the blog post, I have received many positive feedback. I plan to continue doing this month refresher every month now. This rounds ups are my mirror and informs me what I have been doing whole month. Here is quick look at the last month.

The month started very interesting with my daughter’s birthday SQLAuthority News – Fathers and Daughters. As this was very first birthday it was very special for me. I had great time enjoying with her quality time and it was all fun. I am an MVP and I am one proud one. I think MVP demonstrates community dedication and extreme passionate for community, I explained my understanding in the article SQLAuthority News – What is an MVP? – How to become an MVP?.

There was very interesting conversation on the subject of Soft-Delete SQL SERVER – Soft Delete – IsDelete Column – Your Opinion and really think community participated very well on the subject. I am also involved in training very unique fast track data ware house course and I have made few notes over here SQL SERVER – Few Notes on Fast Track Data Warehouse.

Not everything was as great as I expected during the whole month, I was really abused by Indian Airlines Spicejet I finally wrote about their harassment over SQLAuthority News – Spicejet Complaint – Update – No Outcome.If you want to read complete story, you can read my earlier article on the same subject SQLAuthority News – Spicejet Complain – Do Not Fly with Spicejet.

All DBA face common problems when their log file grow too big, I tried to answer the question in article SQL SERVER – How to Stop Growing Log File Too Big.

How can I not write on my favorite subject of indexing in any month.

• SQL SERVER – Index Created on View not Used Often – Limitation of the View 3
• SQL SERVER – Index Levels and Delete Operations – Page Level Observation
• SQL SERVER – Find Automatically Created Statistics – T-SQL
• SQL SERVER – Disabled Index and Index Levels and B-Tree

I have also written series of limitation of the view. Here is the complete series.

• SQL SERVER – ORDER BY Does Not Work – Limitation of the View 1
• SQL SERVER – Adding Column is Expensive by Joining Table Outside View – Limitation of the View 2
• SQL SERVER – Index Created on View not Used Often – Limitation of the View 3
• SQL SERVER – SELECT * and Adding Column Issue in View – Limitation of the View 4
• SQL SERVER – COUNT(*) Not Allowed but COUNT_BIG(*) Allowed – Limitation of the View 5
• SQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6
• SQL SERVER – Cross Database Queries Not Allowed in Indexed View – Limitation of the View 7
• SQL SERVER – Outer Join Not Allowed in Indexed Views – Limitation of the View 8
• SQL SERVER – SELF JOIN Not Allowed in Indexed View – Limitation of the View 9
• SQL SERVER – Keywords View Definition Must Not Contain for Indexed View – Limitation of the View 10
• SQL SERVER – View Over the View Not Possible with Index View – Limitations of the View 11

I would like to request your feedback on the limitation of the view blog post series.

Reference: Pinal Dave (https://blog.sqlauthority.com)