I cannot see the benefit of invoking the CLR for such a trivial purpose. The ideas of a single row table/view with the constants as columns is probably best....

You cannot access resultsets past the first one from T-SQL code. It just cannot be done.

However, you could (and I haven't played much with the embedded .NET stuff but...

Noel's most certainly correct (he usually is).

Make sure you place indices on the columns that are being used to

a) Join the tables

b) Perform the grouping

Include in the indices the...

Download the trial edition of SQL Enterprise - it will certainly run for as long as you'll need it.  Alternatively you could purchase SQL Developer as it's SQL Enterprise but licensed...

Use a trigger on the table for inserted values.  In the trigger, put the identity column's value into your newID column. 

Alternatively you could leave newID as null and have...

Your log/diff backups are set to append... Does this mean that Tuesday's log/diff backups are being appended on to the end of Monday's log/diff backups, or are the Monday...

I'm in your camp on this one - I'm sure I do some things in SQL script that could also be done in SSIS.  If it works for you, and...

You might have some databases on which SQL Server is trying to perform recovery steps - the list of databases is being delayed (and thus timing out) because of this.

Do all...

Have you tried running a SQL Profiler trace?  If you watch the commands executing this might shed some light on it.

Also, perhaps you have some extra long transaction occurring that's...

Much desired new feature - should make the CRUD procedures a bit easier

I like the idea floated about flagging records as deleted rather...

The cheating way would be to

1) Use Enterprise Manager / Management Studio (2000 vs 2005) to create a table and FK as per your arrangement

2) Save your work - have...

Also... Make sure you index the joining fields to make the joining efficient

Another reason to split the table is that the max row size in SQL Server is roughly 8000...

I have a medical software background myself You definitely should split the data up...

1. If you are scanning the patient table for...

Minor point... At the end of the article where you say you could set the uniqueID column as a pkey I think you mean to set it as a clustered...

Exactly how are you stopping the service(s) at the moment?  As others have said, they are very much distinct.