I hope this helps.

http://www.sql-server-performance.com/2010/dml-triggers-multiple-triggers/

With Thanks,

Satnam

I will upload the execution plan in short while, meanwhile the query is as follows:

Select wooBillingAmount_Cp,worIsBillable,bcoUserValue1,bcoID,sctFullName_Cp,cstAddress1,cstAddress2,cstCity,convert(varchar(4000), worCstComment) as worCstComment,rptCstCountryShortDesc,rptCstCountryId,cstCompanyName,cstNum,rptCstStateShortDesc,rptCstStateId,cstPostCode,convert(datetime,convert(nvarchar, worFoundWhen, 107)) as worFoundWhen,worDiscussed,worEstTimeForRepairQty,dateadd(mi, -(IsNull((select tzlBiasInMinutes from vewShatimezoneLookup where tzlBeginwhen <...

I have fixed this issue. It was because of some useful missing statistics in one of the huge tables and now the report executes successfully in 5 min and 12...

I will do post it. I was wondering it might be due to some constraints been missing on the tables.

One strange thing i have just observed. In the entire block of code in one section there are two conditions seperated by AND operator, if i comment any one of...

What about if i have seperate drives for Tempdb(F) and SQL Backups(H) on a cluster and i want to change their letters to T and B respectively, they dont have...

Just the SQL Application itself.

Thank u all for the response. I have fixed this issue successfully.

With Thanks,

Satnam

By support, do u mean to say product support?

And also Heartiest congratulations to you on clearing it, score is good.

I believe It should be at the top of the page before your description starts.

Cheers,

Satnam

Great article David. Keep up the Good Work going. Many Thanks for sharing with us.

Cheers,

Satnam

what server role does the user have which is connecting to sql server management studio?

cheers,

satnam

If network bandwidth is OK you can continue with backup on network server, just ensure that this process doesn't have an impact on any other processes scheduled on the server.

Cheers,

Satnam

Why not use the Import/Export wizard available in the SQL Server Management Studio.

Satnam