using the same script how would i compare 2 identical databases on diffrent servers. I would like to find out if there is any difference in the numbers of tables...

yes. Data will be updated by a job except that no one else will insert any kind of data.

you are right but that is acceptable. we dont update anything directly in production, we only read from production. update will be made only once when we plan on stage...

Any Ideas on how to calculate / estimate exact restore time of a database ?

I am trying to calculate restore time for all prod databases which range from 300gb to 1.4TB. Once i analyse this i want to implement backup restore for my production...

Could some one let me know the diffrence here.

1. Query Time out Expired

2. Execution terminated by the provider because a resource limit was reached.

3. Query Wait time - what happens...

Here is my configuration:

SELECT * FROM sys.configurations

WHERE configuration_id = 1541

Here is a sample view , almost all our views are like this.

ALTER view [dbo].AllRevBudget as

select *

from RevPa rp

where rp.RevID IN ('CA', 'GA')

UNION ALL

select *

from Revpt rt

where REvID IN ('CA',...

does it mean OPENQUERY will use less resource than regular query? what happens when openquery is used with respect to the timeout and using resources.

Usually this us happening when users pull large amounts of data from the views through link servers. I am not sure how to manage these data reads from cross over...

that option is already unchecked, we usually dont check that option.

It was created someitm in mid 2008 and i dont think i will have traces for that long.

I dont have information on who created that account, i just have created date.

I understand that about model but here it is dynamic, users keep on changing, I would like to do in a proc where i can pass database name and logins...

when you say REBUILD clustered index does it means drop constraint and re create it or do we need to use REBULD syntax, if so i know creating index on...