I have a server with the following configuration and I need help to configure memory allocation on SQL Server 2005:
- Windows 2003 Server Standard Edition
- SQL Server 2005 Standard Edition]
- 4 Gb RAM
- This server will only work as a databse server. I have 2 others servers to the application.
I want to know what is the best configuration for maximum performance. How many memory I need to setup in minimum and maximum options and what about awe option.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes. We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP, Windows Server…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.