Paula,

1. After you generate the scripts ( FOR ALL OBJECTS ) from EM, make sure to replace the Collate Statements to the NEW collation. 

2. Create a new database on the...

... switching either the filegroup or the database to read only would give a performance benefit?

For Sure! No locking will be involved and less resources will be utilized for those...

you should enhance the script with "dbcc opentran" for each of the spids if you want to warn the spids involved, and retry those after a predefined timeout period but you...

I am not saying that you remove referential integrity. This  could very well be a design issue

ex:

1.Resources (ResourceId (PK), ResourceName)

2.Connectors(ConnectorId(Pk), ConnectorName)

3.Connections (ConnectorId1(PK), ConnectorId2(PK), ResourceID(PK))

I really don't know enough about your...

There are several aproaches to do what you want.

What I usually do in these cases is to disallow DML directly to tables and perform the logic eather on specially created stored procedures...

SELECT DISTINCT BuyListingID, SellListingID, ProductID 

FROM BuyListings INNER JOIN SellListings ON BuyListings.ProductID=SellListings.ProductID

HTH

"...believe you need Enterprise edition to use indexed views.. "

That is not correct either you can use standard edition too just remember to use the  (NOEXPAND) hint on the...

SQL SERVER DO HAVE Something like the materialized view in Oracle they are call INDEXED  VIEWS instead. There are a lot of restrictions to make them work but for many many...

"Same problem. Chances are very slim"

Yes but,

 1. the simplicity of the query

 2. the speed and

3. the generality  

are a lot better that the proposed solution

As you said

"... The only danger with this solution, even though the chances are very slim, is that the different original values might produce the same hash and result...

OR

SELECT A.*

FROM vwMatched A left join tblExclude E on E.userId = A.userId

AND E.jobId = A.jobId

WHERE  E.userId  is Null

declare @total int

set @total = 100

select @total = @total + count (*) from Northwind..Orders -- 830 rows

select @total

AND After you run the above script run

sp_change_users_login (See BOL for info on how to use it)

to Synch the DB with the master just in case you have other...

create table ttt(col_a decimal(9,4))

insert into ttt( col_a )  values (1.2345)

insert into ttt( col_a )  values (2.3456)

insert into ttt( col_a )  values (3.4567)

--- Check before and after

select  col_a Before ,...

Both above look good But It is my experience that at some point you may want to get rid of an employee and guess what will happen?

You CAN'T because it...