Many developers assume that if you have plenty of free VAS in your process VirtualAlloc ( http://msdn.microsoft.com/library/default.asp?url=/library/en-us/memory/base/virtualalloc.asp ) and VirtualAllocEx ( http://msdn.microsoft.com/library/default.asp...

Q: I have teaching a class on Yukon for the Ascend program, and the class had a question I wanted to double check before answering. On an Itanium with 1 TB of RAM, the class’ curiosity asked, “If plan cache is very large “Then how does Plan Cache lookups...

Today, I received following question Q: Slava, I have a question for you. Sql 2000 is documented to support a maximum of 64GB when used with 2000 datacenter edition. I assume this is the limit of 2000 Datacenter, but is it also a limit defined in sql...