Ybol

the first question has to be

What virtualisation platform do you intend to use?

It is not uncommon to have a physical node (active) and a virtual node (passive).

If using something...

are you planning physical or virtual machines

what does the input file contain

why? what is their reason for choosing this over ESX?

i would have thought judging by your avatar you would say

"i find your...

once the instance is installed you register it by using

servername\instancename

so if you created an instance call "Instance1" on SQL server "London" then register using

London1\Instance1

To register a default instance you...

we have around 8 SQL VM's all running fine. Our storage is SAN based which helps. Which virtualisation platform do you intend to use?

I would go clean install for SQL2005...

we have around 8 SQL VM's all running fine. Our storage is SAN based which helps. Which virtualisation platform do you intend to use?

I would go clean install for SQL2005...

Tom Brown (8/5/2008)

---

Your NOT IN clause would mean checking against every single value to make sure there is no match.

Check the execution plan for the query, then try

AND NOT...

Allison Stresing (8/5/2008)

---

I just installed Office 2007 and now I am having this same problem. Has anyone found a fix yet?

When trying to save a maintenance plan on my...

SQLCMD is the preferred command line connector for SQL2005

SQL server has a set of services that install to the host machine as well as specific program files, etc, so a virtual cd drive will not help i'm afraid

i would go the SQL2005 route first, by that time SQL2008 will be stable and become a viable upgrade platform

Michael Valentine Jones (8/5/2008)

---

Are you really sure about the size of this database? Maybe it is really 400 GB?

400 TB would make it one of the world’s largest databases...

both SQL 2005 Std and Ent address RAM up to the OS limit.

Lee Hart...