The way to do that is to avoid Start and End columns. Just have Start, or just End. Then set a Unique index on the code and the...

Make sure SQL Server Browser service is running correctly.

Have you verified that there are rows that should show no-join to that table?

Data on installing SQL Server on a cluster is here: http://technet.microsoft.com/en-us/library/hh231721(v=SQL.110).aspx

Honestly, setting up clusters in Windows Server and SQL Server is specialized knowledge. I recommend getting someone to do...

You can add as many indexes as you have disk space for, pretty much. But don't count on that improving performance. Add the indexes you need, and no...

Are you trying to move all your indexes to another filegroup? What about clustered indexes? Move those too?

Yes. You need to have all copies of SQL Server licensed properly. Contact Microsoft if you have questions about specific details of the licensing requirements. I recommend...

Can't help much without knowing what your tables look like (create scripts would be best).

Assuming you have a table with the valid lookup values, you can query that.

Might be a...

What/where are you connecting from? Management Studio? Linked servers? Something in your application(s)?

Second the motion on sending the e-mail outside the trigger.

If your application can't send the e-mail directly, then I recommend having the trigger insert data into a queue, and have...

It's saying it can't find the specific table or view. You'll need to look at the connection (data source) and see what table/view it's looking for.

You can avoid the XML characters problem in the For XML Path version by using the value() method on the XML.

IF OBJECT_ID(N'tempdb..#T') IS NOT NULL

DROP...

All those (and more) come under the heading of "DBA" in most job listings. The BI duties are sometimes listed as "Business Intelligence" instead of DBA, but it's about...

Not really enough here to help you out. At the very least, I'd need to see the definition of your split string function, and probably the table definitions.

I agree. Time to escalate this one to MS.