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)
1 Comment. Leave new
Hi,
Today, I check the series of Limitations in View.
I am not much knowledge in SQL Server.
I know just using a view to write a query and then
“SELECT * FROM VIEWNAME”
But, after reading your blog with View Limitations.
I will know many of the things in View.. Its more useful.
Really, ” Limitations in View has Limitless ”
I understood that much from your blog..