you need only one windows cluster.

if size of database is small then take full backup and restore.

try to use script task

i think add 2-3 more files to tempdb and then run the query.

Msg 22022, Level 16, State 1, Line 0

SQLServerAgent Error: Request to run job TestJob (from User TestDomain\testuser) refused because the job is already running from a request by User TestDomain\testuser.

I think check linkserver properties on old server vs new server.

declare @dt datetime

set @dt = '2013-03-01 18:40:24.000'

select convert(varchar(10), @dt, 101 )

if pkg deployed using 32 bit machine then need to use 32 bit exe to run the pkg

1. any query uses group by , order by etc.. uses tempdb.

so if view contains that tempdb will use

2. no of physical cpu = no of tempdb files.

I don't think dtc needed in cluster for server c

Can anyone tell what's missing in this?

-------------------------------------------------------

$reportServerName = "SSRS01"

$currentPath ="/Marketing/test1"

$reportServerUri = "http://{0}/ReportServer/ReportService2010.asmx" -f $reportServerName

$proxy = New-WebServiceProxy -Uri $reportServerUri -Namespace SSRS.ReportingService2010 -UseDefaultCredential

$type =$proxy.GetType().Namespace

$dataSourceArrayType = ($type +...

Execute following ---

use dbname

go

exec sp_updatestats

(this sp will detect and automatically update only require)

64 bit needed

pk - non-clustered?

ya go-ahead and create INT IDENTITY column and see?

by the way .. what you see when select queries runs? any wait-type? table scan?

who hired you as intern? ask him .. he will give all these info.