What i noticed was that when the tempdb was to small you get an performance drop when sql trys to increase the size. Now i have made the size large...

One question is the sqlagent service acount also the outlook account?

For the delay of 10 minutes did you check the refressing setting on the lotes notes server? Also you have...

Hi, in an other thread(cris hedga) i found a way to set a database in single user mode even if there are active connections in it.

ALTER DATABASE kjtest

SET SINGLE_USER

WITH...

In sql 2000 the simple recovery model is comparable with truncate log on checkpoint.

In enterprice manager:

right click the database, select properties goto the options tab.

What you could do is move to windows authentification so that you do not need a password.

You could also do everting in code (make the connection create the passtrough...

Hi Greg great article, i think it will save a lot of time. I like the concept of first building the sql before executing. I think it would be nice...

Hi did you check the datatype for the column WO_c_amt ?. I think you could just use

if c_amt > 0 then . In vb script all variables are variant.

...

Hi,

When using ado you could do something like this:

dim con as adodb.connection

dim strSql as string

strSql = "XExportBCP" 

con.execute(strSql)

set con = nothing

strSql=""





Make sure that the vb...

Hi, Robert Marda has written a great article wherein he explanes how executation plans works.

http://www.sqlservercentral.com/columnists/rmarda/understandingexecutionplans.asp

Hi Andy great article. I use hungarian notation when coding in vb or access or in stored procedures, but not for column and table names. Column and table names represent...

Hi, i would use the execution plan in query analyser to optimise an sp. Or you can use the index wizzard.

check also the following link:

http://www.sql-server-performance.com/

And you can use windows authentification for the sysadmins so that you know who is doing something.

Hi, for safety, if you use sp_configure 'allow update',1

go

and you are finished updating system tables you must

run

sp_configure 'allow update',0

go

so that updating system tables is not possible.

...

Hi see my last edit

Hi , if part has always 6 positions you could try something like this.

insert into temp_possible_masters (part)

select part

from temp_non_masters NM

inner join temp_all_masters AM on

ltrim(rtrim(AM.part)) = left(NM.part,6)

If the number of...