an other 2ct.

The best things about nulls is you don't need to use them.

So only define null alowed when you need null, when it makes sence for your datamodel...

Actualy, I don't consider this to be nitpicking

Your comments do point to brainteaser issues, when one does not keep in mind sqlserver...

please elaborate.

You could take a log-backup and move that from your db-server.

Check recovery-models in BOL.

If your logfiles grow more than you'd expect, or you've performed an operation causing the...

dbo is the default schema SQLserver has implemented.

If a user (lets say User0 )performs "select * from mytable" SQLserver will first search an object...

Should result in 2 rows.

Is this on a multi-processor sqlserver-box ? try queryhint maxdop 1.

In addition to Allen Cui's reply :

' Select into/bulk copy'  will alow non-logged operations.

This will have some recovery disadvantages.

Check SQL7 BOL.

found this in my sql-log :

The Select Into/Bulk Copy option...

 Check these articles http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

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

detatch db ... move files ... attatch db

UPDATE tbldummy SET datefield = convert(char(10), getdate(),121)

nice large index-columns

My guess is your primary file(-group) is autogrowing.

<<A new table is created everyday. >>

If...

- win-permon and sql-profiler can point you in the right direction.

- post the script (DB-(filegroups) + table + indexes + indexed views)

- is the db autogrowing during this load ?...

IMO, create FKsupporting-indexes for all FK-columns or columngroups (exact column-order as PK).

If you want more usable replies, post the DDL and expected stats.

<<searching in the a, b, c, d...

Awaiting new hardware and tackled most of the urgent problems yesterday

This seemd like a nice educational timespender

-- edit post -- is not working ??

also add this at the bottom of the script :

insert into T_SQLServerCentralUsers (uAlias) values('jonathaN')

results in :

Server:...

oops uncommented to much :

--Maybe this will help :

--drop table T_SQLServerCentralUsers

go

create table T_SQLServerCentralUsers(uidnr int identity(1,1) primary key,

uAlias varchar(128)  COLLATE SQL_Latin1_General_CP1_CS_AS not null,

uDtMember datetime...