I find it odd there is no bootstrap log. There is nothing in the event logs either?

As for 2.5, there's a chance that an install of that will help resolve...

Try putting in an alias...I believe that it only looks for items on the default ports

There should be a bootstrap log for every attempt at performing an installation.

You have attempted a reinstallation of .NET 3.5 SP1?

Do you also have .NET 2.5 installed?

You are looking at the same bootstrap, there should be a newer one than this.

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081215_162055\SystemConfigurationCheck_Report.htm

Look for the newest folder under C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ (bear...

What does the most current bootstrap log look like? Or system check file

ritesh.saluja (12/22/2008)

---

Rule Name: VSShellInstalledRule

Description : Checks for previous releases of Microsoft Visual Studio 2008

Result : Failed

Corrective action : A previous release of Microsoft Visual Studio 2008 is...

What's in the SQL bootstrap log?

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20081215_162055\SystemConfigurationCheck_Report.htm

Look at waitstats on the query.

If you are querying 700K records from a local client against a server you could be running into serious network slowness while it tries to...

Try uninstalling the 3.5 SP1 framework and reinstalling it.

If you use a linked server to query data it seems that it pulls all of the data back locally to the calling machine and then filters from there, as...

I believe that this is an installation bug.

On the SQL 2008 installation media there is a version of .NET 3.5 SP1, however this doesn't work if you don't have .NET...

You know, that might not be a bad idea at all. I've used it for a resource and have found it vastly superior to previous versions.

There are areas in which...

How much memory on the server? As a rule you would set the max memory 1 - 2GB less than the total memory on the machine.

Don't put any switches in...

If you have SQL installed and have had it running then they exist. Try looking for your SQL installation folder and drill through there you are looking for a file...

Is there anything in the SQL logs? or within that directory on the server some dump files?