Not sure of the cause of this but you could try unselecting the "Customize Service Accounts" checkbox, so that all services use the same account.

Then if the install is successful,...

Lynn,

Beware the typo. You put 365 instead of -365.

snehal.gamaji.career,

Create a clustered index and go with Lynn's suggestion. Your WHERE clause is not SARGable, and will perform a scan...

HOST_NAME() returns the connected host not the physical clustered server.

SERVERPROPERTY('ComputerNamePhysicalNetBIOS') will do what you want.

SQL Server 2008 has the ability to send queries to multiple servers and return the results in one resultset.

Try something like this:

select serverproperty('MachineName'), serverproperty('ProductVersion'), serverproperty('Edition'), serverproperty('ProductLevel')

or this

select serverproperty('MachineName'), name

from sys.databases...

The recommendation applies to the data files, not the log.

So 1 mdf, 7 ndf's and 1 ldf in your case.

Try this. Note, I've updated your join syntax to bring it into the 21st century.

DECLARE @sql VARCHAR(1000)

SET @sql = 'SELECT ''?'', so.name, MAX(si.rows)

FROM sysobjects so

JOIN...

JournalSpace.com wasn't the most recent failure through lack of backups.

http://www.brentozar.com/archive/2009/03/backup-fail-magnolia-goes-under/

If you don't have a hex editor, Tony Rogerson blogged about another way to do it.

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2007/03/10/how-to-create-a-corrupt-database-using-bulk-insert-update-and-bcp-sql-server-as-a-hex-editor.aspx

Another possibility is memory shortage and/or slow I/O. The former will almost certainly cause the latter.

Look in perfmon at the following counters:

SQLServer:Buffer Manager - Page Life Expectancy

Physical Disk (all...

The first course of action when attempting this sort of exercise is

to try and work out what the code is trying to achieve.

In this case your derived table (t1) will...

The DBCC commands mentioned above will clear the cache but won't release memory back to the OS.

Your best option is to limit the memory used by setting "max server memory".

You...

SELECT Patient, Sample, MAX(Test1) Test1, MAX(Test2) Test2, MAX(Test3) Test3

FROM (

SELECT Patient, Sample,

CASE WHEN Test LIKE 'One%' THEN Result ELSE NULL END Test1,

CASE WHEN Test LIKE 'Two%' THEN Result ELSE NULL...

In depth analysis here, if you want more detail:

http://sqlcat.com/whitepapers/archive/2008/02/11/database-snapshot-performance-considerations-under-i-o-intensive-workloads.aspx

Something that queries and records some wait stats (from sys.dm_os_wait_stats) and a couple of counters from master.dbo.sysperfinfo (e.g. page life expectancy) and reports on the hourly differences.

To get a single...

Will there always be exactly one column in the source data with a value? If that is the case you could replace the SUM with MAX.