Wednesday, January 14, 2009

Which Provider provides faster performance while using SSAS 2008?

.NET Framework Data Provider of OLE DB works but the you could use any of the following:

1. Microsoft OLE DB provider for SQL Server
2. SQL Server Native Client
3..NET Data Provider for SQL Server(SqlClient)

The first two provide the fastet performance.

No comments: Protection Status