how recent are your statistics ?

run sp_updatestats and dbcc updateusage ('yourdb') with count_rows.

This may interfere with ongoing operations !

Then check your...

just a wilde shot ...

The hostname is determinde by data from the connection string.

What's the application name that's shown ?

In case of excell...

It might make sence to run sp_updatestats and dbcc updateusage(0) with count_rows manualy. This may interfere with ongoing operations !

Then try your procedure again

If your applications connect using the IP-address there will be no problem.

just be sure to follow this: http://www.databasejournal.com/scripts/article.php/1496451

and...

just my 2ct.

in addition to PW's and Strommy 's replies :

Your cluster-instance must have the new...

take a look at http://www.sqlservercentral.com/scripts/contributions/592.asp

imo if you allocate a drive letter (net use z) , you should also unallocate it (net use z /delete).

Unless offcourse this is an action that would be performed very often.

Then...

who needs a drive when you have UNC ?

\\myserver\myshare 

"Change your recovery option to Simple this will prevent the log from capturing all the data and filling up" ....

Nop.

It will depend on your...

Log files will only shrink up to the last active log chunk.

so it may be needed to run the shrink-file x-times.

-- Shrink_TrxLog.SQL

--INF:...

Maybe you'll find some script a the SSC-scripts section.

Here's one I install by default for dev-support :

-- it uses the msdb-tables and will...

aha, the trigger issue

That's exactly the reason why one should always evaluate if a "procedure" should _always_ be executed when modifying data for...

... I love stuff like this. Maybe you should submit it to the script library! ...

Done

VB.Net support from your SQLServer DBA

select

    sum(BalAmt),   -- sum does not use columns that have a null-status

    sum(BalIntRate)

from   DebtCurrBal   c   with(nolock)

       join DebtBase d   with(nolock)   

on c.DebtBaseKey =...

check your execution plan !

I presume sqlserver in scanning your full table and suffers a bunch of waits !

"RowId is unique index" Is...