Out of the blue my server started to have the sqlservr.exe process take a huge chunk of my memory. It's taking 31 out of 32 gb. We only have a couple very small databases, why in the world out of the blue would it start taking so much memory? It's causing our server to freeze up.
After stopping the process it goes back down to normal. But I need to fix it so we can run it again.
If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.