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.
SQL SERVER – Computed Columns – Index and Performance
This is the last article in the series of the computed columns I have been writing. Here are previous articles. SQL SERVER – Computed Column – PERSISTED and Storage This article talks about how computed columns are created and why they take more storage space than before. SQL SERVER –…
Read MoreSQL SERVER – Computed Column and Performance – Part 3
I am really enjoying writing about computed column and its effect in terms of performance. Before continuing this article, I suggest you read the earlier articles on the same subject to get the complete context. This is the list of the all the articles in the series of computed column.…
Read MoreSQLAuthority News – SQL Data Camp, Chennai, July 17, 2010 – A Huge Success
I had great pleasure to attend very first SQL Data Camp at Chennai on July 17, 2010. This event was very unique as this was very first one-day SQL Event in whole Indian Subcontinent. The event was blast as there were so many back–to-back SQL Sessions with SQL Server MVPs.…
Read MoreSQLAuthority News – Two SQL Sessions at SQL Data Camp at Chennai – July 17, 2010
I will be presenting two SQL Server advance level sessions at SQL Data Camp @ Chennai. I am very excited for this event as I am going to meet my friends Sugesh, Deepak, Vidhya and Madhivanan at this event. All of them are SQL Server MVPs. I have come to…
Read MoreSQL SERVER – Index Levels, Page Count, Record Count and DMV –Â sys.dm_db_index_physical_stats
In the recent Query Tuning project, one of the developers who were helping me out in the project asked me if there is any way that he could know how many pages are used by any Index, Â and if there is any way I could demonstrate the different levels of…
Read MoreSQL SERVER – Outer Join Not Allowed in Indexed Views
I recently received an email that contains a question from one of my readers. I have already replied the answer to his email, but I would still like to bring it to your attention and ask if you think I could have done any better with the example I gave.…
Read More