Indexed views. In SQL Server 2000 and 2005, you have the ability to add indexes to views. But, if a view is just a stored query definition in the database with no data of its own until it is run, ...

I'm using bcp to dump large quantities of data into a table that has several indexed views built on top of it. It seems to work fine for a while, but on random rows it will die with this error:<BR ...

SQL Server 2012 includes a lot of new and exciting features. One feature that has caught the imagination of many in the user community is the high-performance feature called Columnstore Indexes.