OBIEE — MSSQL server anomalies Part I

OBIEE — MSSQL server anomalies:

In a recent project I had a chance to work extensively with integrating OBIEE with MS SQL Server.
Details:
MS SQL Server – 2008 R2
OBIEE – 11.1.1.6 BP1 on Windows 64 Bit, Oracle Linux
We had several issues with this combination and would like to document some here in this forum:
OBIEE comes bundled with the following ODBC drivers: DataDirect 6.0 SQL Server Native Wire Protocol (On Windows)
This is the

Sachin
JainSys