IF OBJECT_ID('tempdb.dbo.#index_info') IS NOT NULL
    DROP TABLE #index_info;

SELECT TOP (0)
dbschemas.[name] AS schema_name,db_name() AS db_name,
dbtables.[name] AS table_name ,
dbindexes.[name] AS index_name ,

Along similar lines, I've noticed that many brokerage firms use decimal places for fractional stock holdings, although they display only 3 or 4.  Thus, it's often impossible to get an...

I don't think this is really an issue, as a practical matter.  Interest is computed daily, down to the cent (or, worst case, to hundredths of cents), how much the interest is....

UPDATEs can indeed cause page splits, in particular if lengthening the value of a varchar column, which is quite common.  Often the resulting potential page split issues get overlooked in that...

Yes.  Set a control value using sp_set_session_context; you can test it inside the trigger using SESSION_CONTEXT.

As an aside, I suggest you use >= and < for all date/time/datetime comparisons rather than between.  That also gets rid of the need for the "tricky" use of -1...

SET IDENTITY_INSERT [Marketo].[EmailActivity_Temp] ON;
INSERT INTO [Marketo].[EmailActivity_Temp] (
  [id], [leadId], [activityTypeId], [primaryAttributeValueId], [activityDate],
  [DateAdded], [ProcessedInd], [primaryAttributeValue], [CampaignID], [EmailActivityKey],
  [NextPageToken], [LinkClicked], [ProgramName], [Attribute], [AssetName]
 ...

Erwin is a great modeling tool, the best I've used, although it wasn't cheap the last time I was able to use it.

Assuming you have multiple CountyDistrict values, and the table isn't clustered already, try clustering the tables:

CREATE CLUSTERED INDEX DistrictTeachers__CL ON dbo.DistrictTeachers ( CountyDistrict, TeacherId ) WITH ( FILLFACTOR...

For credit card info specifically, you'll need to make sure you follow relevant laws on handling that data.  Just SQL-based encryption methods is not enough, as I understand it, but...