I ususally monitor the counter of sec/read and sec/write in perf monitor, and the IO stall by ::fn_virtualfilestats in SQL server.

They are really helpful to identify IO bottlenecks.

If you created the second file in the same file group, you can set up the max limit for the first file with no autogrow.

If you created second file in...

If "identity" is the main reason for you to separate the master database, you don't need to to do it at all.

In import/export, you do not need to drop the...

Though the transfering of data will be easier by separating the master tables in a new db, it may cause the following problems:

1) data integrity. FK definition is not allowed cross dbs....

Did you really try my script?

Your code gives the following error on my machine:

Server: Msg 7321, Level 16, State 2, Line 1

An error occurred while preparing a query for execution...

The syntax works for me. If you can do it by linked server, you should be able to use OPENROWSET.

Check the sheet name in your Excel file;

Try to use 'Excel...

As far as I know, you must be a member of sysadmin to use profiler in SQL 2000.

1) Did you check both the log and data file settings? Do they all have auto grow with no limit?

2) You can try to Manually increase the data/log file sizes in...

You can try the following trick:

DECLARE @N int

SET @N=1

-- Instead of 1000, assign a reasonal value to compare.

WHILE @N<1000

BEGIN

exec sp_xml_removedocument  @N

SET @N=@N+1

END

Forget to ask, what edition you are using?

I tried without PK and index in two ways:

1) remove PK and index in sql 2000, backup and restore to sk5, add the identity and unique key

2) remove the pk...

Yes. In SQL 2k5, you can use sql profiler if you have ALTER TRACE permission.

try:

SELECT * FROM OPENROWSET(

'Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=c:\access\RCApptCardevent.xls',

    'Select * from [sheet1$]')

I did the same thing as you to a table with 185

,380,901 rows, it completed with no errors. The table has...

To explicitly assign a value for an identity column, run:

SET IDENTITY_INSERT YourTable ON

To turn it to automatically asign value, run:

SET IDENTITY_INSERT YourTable OFF