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

using cmdshell it will work if you have the authority.

exec  xp_cmdshell 'date ....'

did the hyperlinks bring any light in the darkness ?

Search the KB, there were more articles where you can find "bpool" ..

First things we do is add the windows SQLserver-administrators-group as login and add it to the sysadmins serverrole.

Then we always remove builtin\administrators from the sqlserver-logins !

Our SQLservers all run using a windows...

Keep in mind you can only start jobs you own !

To avoid overauthorising users so they can start jobs, I use an alert which starts the job, so they only raise...

Windows version ?

SQLServer version ?

AWE enabled ?

(check

 -  http://support.microsoft.com/default.aspx?scid=kb;en-us;319477&Product=sql2k 

- http://support.microsoft.com/default.aspx?scid=kb;en-us;323212&Product=sql2k

Jonathan

SQL7 -> no cascading deletes through DRI. That must be done using triggers.

Dan,

The DRI-checking will be done by sqlserver, so provide FK-indexes to support it.

If those indexes hurt performance to...