I am running the database server with the following configuration.
The SQL Server consumes the hole memory(14 GB) and does not release the memory.
As a result the performance of the database server is reduced.
Please help me to resolve the issue.
IBM System x3650
Windows 2008 server standard 64 bit
HDD:148 GB (RAID 5)
RAM :14 GB
MS SQL Server 2012 64 bit
Current Database Size: 7 GB
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 …