SQL Index Archives - Page 28 of 47 - SQL Authority with Pinal Dave

SQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6

September 22, 2010

SQL Index, SQL Scripts, SQL Union clause, SQL View

Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… If you want to create an Indexed View, you ought to know that UNION Operation is not allowed in Indexed View. It is quite surprising…

SQL SERVER – COUNT() Not Allowed but COUNT_BIG() Allowed – Limitation of the View 5

September 21, 2010

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts, SQL View

Update: Please read the summary post of all the 11 Limitations of the view SQL SERVER – The Limitations of the Views – Eleven and more… One of the most prominent limitations of the View it is that it does not support COUNT(*); however, it can support COUNT_BIG(*) operator. In…

SQL SERVER – Disabled Index and Index Levels and B-Tree

September 14, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

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…

SQL SERVER – Index Levels and Delete Operations – Page Level Observation

September 7, 2010

Pinal Dave

SQL, SQL Interview Questions and Answers, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

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…

SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server

September 2, 2010

Pinal Dave

Personal, SQL, SQL Performance, SQL Server, SQL Tips and Tricks, SQLAuthority News

Best Practices, Database, SQL Index, SQL Scripts, SQL Training

In my earlier article SQLAuthority News – Training and Consultancy and Travel – Story of Last 30 Days I had mentioned that I prefer to do 50% consultation and 50% training. Since then I often receive what do I do consultation for and what is my expertise. I am basically…

SQLAuthority News – A Monthly Roundups of SQLAuthority Blog Posts – Updated 2019

August 31, 2010

Pinal Dave

SQLAuthority News

SQL Index, SQL Server

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

August 22, 2010

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Index, SQL Scripts

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 –…

SQL SERVER – UNION Not Allowed but OR Allowed in Index View – Limitation of the View 6

SQL SERVER – COUNT(*) Not Allowed but COUNT_BIG(*) Allowed – Limitation of the View 5

SQL SERVER – Disabled Index and Index Levels and B-Tree

SQL SERVER – Index Levels and Delete Operations – Page Level Observation

SQLAuthority News – SQL Server Health Check Service – Speed UP SQL Server

SQLAuthority News – A Monthly Roundups of SQLAuthority Blog Posts – Updated 2019

SQL SERVER – Computed Columns – Index and Performance

SQL SERVER – COUNT() Not Allowed but COUNT_BIG() Allowed – Limitation of the View 5