I use perfmon to monitor PLE.

Lock pages in memory is advised only in cases where it proves to improve performance, experiment! In theory the setting should not be required.

Dan

I'd set max memory to 14GB leaving 2GB for the OS.

Monitor PLE (page life expectancy) before and after changes to determine if additional memory may be beneficial.

Create a linkedserver and use brackets [] around the ip address.

Dan

You can use dynamic sql. I wouldn't recommend it though.

Dynamic sql opens your solution up to sql injection and hinders your ability to tune performance. My preference is to create...