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...

just ensure that MSSQLSYTEMRESOURCE and DIST are in the same location as your MASTER database and all should be well

begs the question,

if you're implementing log shipping, why are you truncating the log?

sounds like these guys had the problem as you, give it a shot

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=2968469&SiteID=1

i was involved in an upgrade from a sql2000 instnce to a sql2005 instance early last year. The point raised was how do we get the databases onto the new...

as stated in your case no.

if you were SAN based for instance for your VM storage then you could use different LUNs.

With regards to licensing if you licence your host...

are you experiencing page splits on your server?

SQL server default is 0 which means the same as 100% (you can alos specify when rebuilding an index which overrides the default),...