by XTIVIA | Aug 6, 2012 | Blog, Databases
While creating a linked server from SQL Server 2005 to SQL Server 2000, I got the following error when I tried to query the remote server. OLE DB provider “SQLNCLI10” for linked server “XXXXXX” returned message “The stored procedure...
by XTIVIA | Mar 22, 2012 | Blog, Databases
As a DBMS SQL Server is a powerful, cost-effective, and simple-to-use DBMS able to service the needs of most small-to-medium size businesses right out-of-the-box without professional management by a DBA. In fact, a recent survey reported that 45% of IT personnel...
by XTIVIA | Feb 3, 2012 | Blog, Databases
When we focus on IO performance for SQL Server it is vitally important to understand the architecture of the disk subsystem. Typically, a DBA will focus on Disk Queue Length as the primary measure of IO performance; however, in a Storage Area Network (SAN)...
by XTIVIA | Dec 20, 2011 | Blog, Databases
I’ve read the case files. Have you? Everything you need to find him is there in those pages. – Then tell me how. – First principles, Clarice. Simplicity. Hannibal Lecter’s advice works as well for DBAs as it does for FBI agents. What does...