Have you tried bulk insert or bcp? These are non logged inserts so might be even quicker.

Jeremy

The obvious checks are whether you have got the indexes and statistics on the tables. Depending on how you scripted the database, you can sometimes leave behind the indexes.

This...

No - the backup deletes old backups after it has successfully completed the current backup. If it didn't, you could end up with the situation where you don't have...

When you say 'the date a table was last modified', do you mean the last change to the schema of the tables (new or changed column, new index etc) or...

I suspect that the problem in on the AS400.

Two things come to mind:

1. Updating did not meet the schema requirements - could this be that the rows you are...

Are you using char or varchar?

SQL will pad a char field with spaces upto the max length.

Jeremy

A couple of ways:

select *

from products

where not exits (select productId from InvoicePos

where products.productId = invoices.productID)

or

select *

from products a

where 0 =

(select count(*)

from InvoicePos b

where a.productID = b.productID)

The first...

One way you could do this is to put the countries into a temporary table, with an idenitity column, in the order in which you want them ordered by and...

One way is:

declare @count tinyint, @days tinyint

select @days = days

from service

where cds = 1

set @count = 1

while @count <= <number of days> begin

/* Insert statements in here...

use charindex(' ',<email_address>). Returns non zero if a space or zero if no space.

Jeremy

Edited by - Jeremy Kemp on 04/10/2003 07:11:42 AM

ShrinkDB will shrink the whole database, shrinkfile (where available) shrinks a single file within a database.

ShrinkDB is probably what you need.

Jeremy

Use DBCC SHRINKFILE(<file_name>,<size in MB>)

Jeremy

Triggers are 'in process' commands - they execute within the same process as the command that invokes them. Adding a delay into a trigger will add a delay, and...

Can you give me some tips as to where to look for memory leaks?

In my app, I create a lot of temporary tables, dynamic SQL and cursors. I may...

In clause vs join. I converted the in clause to a multi table join and I was surprised that the table join performed significantly better than the in clause....