There are several things in the code that could be leading to the performance problems.

1. Use of functions, as you mentioned, especially in WHERE clauses and JOINS.  Try to get rid...

One more piece of advice if you haven't thought of it already, especially if you are dealing with very large databases.  If you want to minimize down time during the...

I'm curious as to why you would get 100,000,000 rows after the join.  Many to many I suppose.

Otherwise, I'm out of ideas without seeing the structure of the views.

You might want to check out the FileSystemObject and the File objects in VBScript.  There are lots of methods and properties that will give you more options.  And of course...

I just want to emphasize the earlier comment about VERIFY not checking the validity of the data contained in the backup.  More than a few DBAs have been burned by...

Is sql server running on a non-default port?  If so, does your XYZ user's machine have an alias set up for the sql server running on the correct port?

I think you'll need to post the structure of the 2 views to get any solid advice from this forum. 

But... you can look at indexes on join fields and WHERE clauses, both...

Personally, I prefer a rebuilt server to an uninstall.  (I've never had much confidence in an uninstall of any kind).  Of course that depends on your confidence in getting everything...

There are quite a few versions of Block Monitoring out on the web.  Here is one that I found and doctored up a bit.  I have the procedure running in...

Ben,

You mentioned that there are indexes on all join columns, but are there indexes on the fields in the WHERE clause?

The default directories can be set at the server level.

Go to properties, database settings and you will see a place for Database default locations.  This is the same in both...

/* One way is to use the system tables to find the default constraint name if it exists, then use dynamic sql to drop it. 

Of course,...

Just by eyeballing the code:

• NOT IN is usually a performance hog
• May want to replace IN and NOT IN with inner joins and left joins
• May be performance problems with CONTAINS, but...

I prefer to write my own queries off of sysprocesses.  If you have lots of users, applications, or databases, filtering things out in a where clause is the way to...

Not that I am aware of.