Having the IIS seperated will indeed lessen the contention.

Is there another candidated for the clustered index? Datetime and 10 ints seems to be large. Exchanging for a non-clustered index?

Any possibility...

Also try to match the datatypes for index usage. If active_flag is a bit-field use active_flag = convert(bit,1)

You could try to replace the not in   to not exists . With in it has to fetch all records before comparing, with exists it can cease fetching if one...

Most likely splitted. Why sql server would move 10gb tables as a whole because the mdf suddenly got full.

Perhaps you could pass the subheader as a parameter as well.

Is this like

Questionnaire

Header

Header_level2

Header_level3...

?

a wild guess, do both tables have a primary key or unique index?

Any reason why you wouldn't use 10k or 15k rpm drives instead of 7200 rpm's except the cost?

Try using (not) exists instead of (not) in. The exists halts when it finds one record, in requires finding them all before comparision.

Have a look at

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

to setup logshipping.

Replication is supported in the standard edition. Log shipping can also been done by manual implementation.

The only reason so far I would like to upgrade to enterprise is it can...

Perhaps the vendor knows if the systemadministrator rights are required ( or only db_owner rights).

You could also explain this huge risk to the management side.

(Someone changing the password ->...

nr 2.

You can use the inner join. The results for invoice,lineitem will be null if no matching customer is found.

Thanks again, it worked out.

Script:

DECLARE @Tablename nvarchar(128)

DECLARE @UserName nvarchar(128)

DECLARE @ConcatName nvarchar(128)

DECLARE @DatabaseName nvarchar(128)

CREATE TABLE #Databases

(

Databasenaam nvarchar(128)

)

CREATE TABLE #temp2(

 rec_id  int IDENTITY (1, 1),

 username varchar(128),

 table_name varchar(128),

 nbr_of_rows int,

 data_space decimal(15,2),

 index_space decimal(15,2),

 total_size decimal(15,2),

 percent_of_db decimal(15,12),

 db_size  decimal(15,2),

 dbname...

Thanks for the suggestion, I'll try that one out.

The second one could be faster because the server can check its statistics more quickly.

I would suggest using inner join instead of Title T, TitleSearch TS             

Select ...

from title T inner...