Turns out, the DB itself did not have arithabort set to true, but it was set during the session where I created the indexed view. Once set on the database itself, bcp worked wonderfully.

Oracle has a similar feature called Materialized Views. Indexed Views were introduced in SQL Server 2000 as an Enterprise Edition feature. The confusion arose in SQL Server 2005 when it appeared that ...

Ok, so I'm reading about Indexed Views and I see that another feature of Enterprise edition is that it can substitute them into a standard query when the query optimizer runs the query if it so ...

SQL Server 2012 is a large, complex product that represents Microsoft's vision of where data is headed. If that vision were to be summed up in one word, that word would be: big. To meet the challenges ...

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.