Experience is nice, but it would be good to see some objective measurements on this. Not saying you're wrong, just would like it to be something other than a guess...

Jeffrey,

Do you have a 64 bit reference? I haven't seen this.

Even on 32-bit machines, with 2GB of RAM, I haven't seen SQL Server starve the OS. OS priority on memory...

Typically there are two places where i've seen this issue.

1. The plans were created on a version of SSMS that is different than the one you are using. This is...

It look like you have no limits on SQL Server memory, which is OK if this is a dedicated SQL Server machine.

you might want to read this blog (http://sqlblog.com/blogs/lara_rubbelke/archive/2008/04/18/memory-pressure-on-64-bit-sql-server-2005.aspx), which...

What is pagefile system? Do you mean the page file set on disk? what are the settings for that?

Please don't do that. It's rather rude and improper. If you need to ask a question, leave it here. Or edit it to explain better, but don't just remove it.

LOL, not me, though I might not be the easiest person to work with all the times. It's stories I hear, or things I've seen at it is work. It...

Also, on the nuclear issue, and even in some manufacturing plants, the code used in IT isn't something you're changing and deploying on a regular basis. Most IT that I've...

I think the point has been missed slightly. I'm not saying that you can't drink at lunch, or have a drink and come back to work for something. I'm noting...

I'm not sure about that. Some bosses...

I think it makes sense to spend some time learning some of these, especially the ones that you use on a regular basis. Those you ought to have a lot...

kevin77 (3/3/2010)

---

Steve, does the forum software limit the length of the post at all? I don't run a technical site, but we limit our forum posts to 7,000 bytes...

Tom,

unfortunately I think it is much harder than that to fire someone. At least on a first offense. I agree with you, but I wonder if most of the companies...

This hibernate? https://www.hibernate.org/

That's from Red HAT, not Red Gate. Red Gate doesn't have a product to do this, AFAIK (http://www.red-gate.com/products/index.htm)

As far as which is faster, it depends on what...

You would setup clustering first. Install SQL on node 1 as first part of clustered node. Separate selection in setup. Then go to setup on the second box and select...