I have a server running SQL Server 2000 Enterprise Edition with a large database (350GB). The server has 4GB of RAM. I monitor this server with a 3rd party performance monitoring tool. Very often I notice that Windows is paging and there is still free memory (about 1.6GB). I thought that Windows would not start paging until it ran out of Physical Memory, but yet it does so quite consistently when there is still plenty of memory left on the server. Can anyone give me reasons why this would be happening?
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …
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.