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...

To much luxury is not good

Maybe this will help :

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 not...