By the way (should a hardware guy appear and suggest this). Multi-instancing doesn't require extra licenses if you're NOT running multiple virtual instance of the server. Meaning -...

Also - the 2 seconds disappear if you change the index to

CREATE INDEX IX_Temp ON #Temp (Expiration) INCLUDE (eMail)

Both then represent 50% of the execution plan, and BOTH take...

You can use a CLR function to scrub that out using regular expressions. You would have to enable CLR, publish this to the server, etc...

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports...

From what I've been seeing, the difference between putting it in the main index field list versus including it is in how you're using the fields in the query you're...

True - but the overhead of the union balances the two processes out....

On a million records, the table scan matches the union (within .2 seconds. )

Peso's - 7743

Jason's - 7540

Now...

Of course, the optimizer "likes" table scans when you're using every field in a table in a query....might be a little different with the other fields a "real" table might...

Also - in case you're doing a large amount of splits (on big table, etc...) - the CLR version is about 3 times faster. (15 secs vs 49 secs on...

or - you SKIP the loop and do it in one shot...

select

convert(varchar, timeofcode, 112) avgdate,

sum(case when a.npa = 'Metro' then 1 else 0 end) total416,

sum(case when b.attempted = 'on' and...

The T-SQL above would have given you a split of the data into even chunks, using a random sort. distributing would have been simple (xp_sendmail, a report, etc...)

The requirement...

Since it sounds like the number of supervisors is a variable from week to week, try something like this:

declare @active_supers as int

set @active_supers=10 --just picking a number for illustration

select...

Alen - since you're in sql2005, try using the new CROSS APPLY predicate. First, though, you need a table-valued function to give you the splits.

alter function split(@val as varchar(max),...

well - let's get some specifics before we go diving into weeks and weeks of back and forth (well - probably will happen anyway.....:D)

Jeff Moden took a running start at...

It might be easier to "recache" the data AFTER the big maintenance is over. So - let the server do what it needs with all of the RAM it...

The one gotcha you might need to think about is that there's no handling of NULL. So - if one of the name fields were NULL - you wouldn't...

your best bet would likely be to put your data or a sampling in a code block. in the create reply screen, click on IFCODE up top, and pick...