did you also perform sp_updatestats, dbcc updateusage and dbcc freeproccache (so newly generate plans come in).

Maybe it's time to use profiler to capture load and analyze it to check if...

imo the only difference for the "dbo-login" is that (s)he does not have to qualify schema DBO when creating objects. Members of the db-owner db-group always have to specify the...

This is how I'd solve it : (be aware of collation conflicts !)

print 'Fillocations of DB'

print '------------------'

declare @SelStmt as varchar(7000)

declare @DbNaam as varchar(125)

declare...

yep, basic rule No 1 for programming is still : "learn copy/paste"

That should be no problem because the new domain will use the old sid from the users sid-history.

The only "issue" you'll have is...

... parameter-table and proc set to manage sequences ...

This way you could emulate identity

This is just a simple representation :

create table t_mySequenceParameters (

TableName...

you could add the old domain's user-SID to the new domain-user's sid-history.

As you can imagine, this is a windows-ad-operation, and not a sqlserver operation....

you may want to check out IDENTITY and scope_identity if you can live with gaps in your numberings.

we always set it to the max available blocksize and let sql handle it internaly.

Can't DTS help ?

(check out Enterprise manager, database, tables, rightclick and choose import data. The wizard will guide you )

In addition to sa24's advice, you can also use this delete-batch.It will take a while, but since transaction are kept small, interferance should...

CREATE TRIGGER Itr_T_Current
            ON T_Current
FOR INSERT
AS 

insert into T_History
select * from inserted

GO

maybe these resources can help :

- http://www.sqlservercentral.com/columnists/jsack/aweadventures.asp

- http://support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;319942

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

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

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

Keep in mind filegroup-files are balanced within a group, so your maxcapacity is the size of the smallest file * the number of files in the filegroup.

Is this what you're looking for ?

this query uses native sqlserver systemtables . 

SELECT  FG.groupid AS GroupID

, SUBSTRING(FG.groupname,1,30) AS FilegroupName

, SUBSTRING(O.name,1,30) AS ObjectName

,...