Do you put your system database and user database in the same maintenance plan?

I think you have to separate them into 2 different plans. You can look for this in...

how if we put:

select col005 from [Baseball65K24] a where not exists( select 1 from [Baseball65K50] b where a.col005 = b.col007)

would it run faster?

thanks.

Leo

I guess this is because your procedures are locking each other.

You can try to set the ISOLATION LEVEL or use with(nolock) hint in your select statement.

Leo

i got a simple suggestion here.

first, select all new user into a identity temp table. for example,

create table user_temp(

   key bigint identity(1, 1),

   firstName varchar(50),

   emailAddress varchar(100)

)

insert into user_temp...

Hi,

I am not sure your system is slow in which area.

Have you checked your execution plan for all statements that you are running?

Hm .... did you check whether your indexes...

what if we change from IN to EXISTS?

SELECT     cycleName, framework, toolName, taskName, DATEPART(ww, execDate) AS WW, execDate, execHour,

                      SUM(CAST(StressTime AS decimal) / 3600) AS MachineHours, targetName

FROM         dbo.tbl_execution_time_hourly ETH

WHERE     EXISTS

                         ...

In my opinion, for a 2-tier-architectured application, we should separate the login from your front-tier and end-tier. so, you have different logins for your application.

Reasons are:

1. Increase security control of...

i've learned something today.

thanks a lot.

Leo

i've learned something today.

thank a lot.

Leo

here is the link:

http://www.sqlservercentral.com/columnists/lPeysakhovich/indexcreationguidelines.asp

There is a line of statement as below: