What version of SQL? I think I had something similar in SQL 2005 with mega users and small autogrowth.

This is interesting. Do you have scripts to create database, populate database...

Of course, that just scratches the surface, but you've got to start somewhere.

I haven't followed a thread like this in a while. It got a little out of hand, but no comments seemed over the line to me.

"Anybody have list of questions...

It was a simplistic statement to see if it was possible that the source databases remained static after you imported the data so that you could do the ETL thing...

Increase the auto growth factor above 1 mb so it doesn't autogrow on every pdf. Get a real version as suggested.

Is it possible to change the recovery model on the database to simple? In other words, is it possible to re-run the imports and processing?

Also, you could put the log...

One needs to be cautious about eliminating or filtering out 'unused' indexes. I think that sys.dm_db_index_usage_stats only shows indexes that were used since the last time SQL server was started....

Wouldn't a best practice be to free or kill the connection prior to app exit?

Peggy

It's really not clear who wants what fixed. That said, I like your idea to 'fix' the environment. That way you'll be able to document and control the new environment.

PROCEED...

Haven't read thru all previous replies yet, but here's my take:

1. Everything was installed and configured properly, database design and layout was optimized for business unit's needs and to prevent...

Cleaning the text format wasn't obvious. I brought it into a hex editor, cleared strange chars and posted it back into SSMS and it ran without errors.

I tried what you suggested and also tried running entire script. Couldn't get either to run. Could you post another script that will?

Thanks guys. I've been away from SQL for a while. This really helped.

I think they have to be linked servers.

Thanks, Chris. That syntax looks good to me.

The link on the bottom of your posts is incorrect. It should be http://www.sqlservercentral.com/articles/Best+Practices/61537/

I finally read it and apologize for my...