At my workplace, I have made our SQL Server DRs fairly trivial by scripting the DBMS installs, having standardized backup and restore procedures and a proc to generate all necessary...

Well,...

A couple of other books I would highly recommend are The Data Modeling Handbook, by Reingruber and Gregory and Data Model Patterns by Hay. The first is an excellent...

That makes sense.  I imagine the four that were fired happened before the msdb data files for that instance went offline.  I guess its time to get MOM moved from testing...

I would be very careful in saying that a SAN should outperform an internal disk 99% of the time.  I have worked at several sites where the number of fibre...

Correct me if I'm wrong here, but didn't you say that you have a number of unique keys on the same table?  Does that not then imply multiple candidate keys...

This may be an issue with index maintenance during after each insert statement.

I ran your code as you gave it on against sql 7 and the inserts where finished in...

I have used both approaches and they both have there positives and negatives.  The single table approach is great in keeping your databases from being populated with many code description...

Did you try the sql I originally posted with the mods to change the age and remove the date predicate.  i would have looked something like this:

SELECT CH1.Name

    ...

If you are running multiple instances at Sp3a, you may have to get a hotfix from MS.  We had that problem, which was not good because we use performance alerts...

Lets look at your Question #2 a bit at a time.

The datediff("D",CH1.CallDate,getdate()) was used to come up with the "age" of the call.  If that...

hi,

Do you have a copy of MS's "Full-Text Search Deployment" white paper? ( found here http://support.microsoft.com/default.aspx?scid=kb;en-us;323739&nbsp

It says that you should either modify or...

Did you look at :

http://support.microsoft.com/default.aspx?scid=kb;en-us;298794

http://support.microsoft.com/default.aspx?scid=kb;en-us;303459

Both refer to a specific registry setting.

from the latter:

This problem occurs frequently if the total size of all the catalog files exceeds 256...

I'm not to sure how your "KISS" solution satisfies his requirement.  I would be very interested to see you full SQL solution.

Well, if you are already using a DLL, you can change the architecture slightly to use a COM+ component to access the db.  If you set the initial number of...