Thanks Gail. This descision was made prior to my arrival here, however, we are just starting the consolidation and there may be time to stil persuade some folks here. Virtualization...

Thanks Jason. I actually found a link that basically says what you are saying. Essentially the Named instance that I'm trying to install is its on separate cluster(i.e. which is...

Yes the named instance will be on my cluster active/passive box

Thanks

Thanks for your prompt reply. I'm absolutely confident that you know more than I about this matter.

Here is the link that I used:

http://www.conetrix.com/Blog/post/Best-Practices-for-Memory-Management-of-Multiple-Instances-of-SQL-Server-2008-R2.aspxhttp://www.conetrix.com/Blog/post/Best-Practices-for-Memory-Management-of-Multiple-Instances-of-SQL-Server-2008-R2.aspx

Given the fact that I...

thanks for your help. I'm sure you are correct.

Yep. Well thanks for your help.

Thanks, actually I'm using redgate virtual restore because our current QA/DEV Environment does not have the disk space.

Really great tool. I really don't understand why the wouldn't

want a mirror...

thank you that's what I was thinking.

Thanks, I thought that was the case but I couldn't find any info but I could have tried it out. But thanks for this information.

Thanks a million

Sure, first of all the database was initially setup by developers who have had no data modeling experience, so the database vary flat. The main table is approximately 8 million...

Thanks for you input

Thanks a milliion

here is the error that I'm getting

Conversion failed when converting the varchar value '*' to data type int. (Source: MSSQLServer, Error number: 245)

now prior to this error message I got...