http://support.microsoft.com/kb/224071

Gives steps, troubleshooting hints and some cautions.

What are you doing now?

A few other things to consider:

Differential backups

If a subset of that 2 years of data is read-only, you can archive it off into a separate database, then you only need...

Try this:

UPDATE tt2

SET tt2.idTemp1Update = tt1.id

FROM #TempTable2 AS tt2

INNER JOIN #TempTable3 AS tt3 ON...

To Jack's list, I would add one more consideration: Is the number of possible databases finite and manageable or is there a possibility that it will get beyond reasonable control?

I'm...

Have a look through the Scripts section of this web site. Here's one that I found on a quick search: http://www.sqlservercentral.com/scripts/Administration/72594/

Matt, I had thought that was the case just by parsing the query but hadn't run any tests. Thanks for the confirmation.

Setting multiple values at a time isn't a...

Try this:

create table #test

(

color_names varchar(20)

)

insert #test (color_names) values ('red')

insert #test (color_names) values ('yellow')

insert #test (color_names) values ('blue')

--couldn't figure out a quick way to create a table...

So how do you know which manager to display? What's the criteria around that?

Totally unparsed/unchecked but...

SELECT MIN(FileDate) as StartDate

, MAX(FileDate) as EndDate

, EmployeeId

,EmployeeName

,ManagerId

from TheTable

Where FileDate BETWEEN @beginning and @ending

GROUP BY EmployeeID, EmployeeName, ManagerId

See this:

http://www.sommarskog.se/dynamic_sql.html#OPENQUERY

Ugh, that won't really work due to the nature of the (garbage) data I have to deal with. Rather stick with persistent tables than do that, I think.

But of...

where jobid BETWEEN value1 and value2

Just be aware that triggers can seriously degrade performance so if you can get rid of the dupes that would be best.

Do you need to keep the old dupe values?

If so, about your only solution is to create an on update / insert trigger and manually check.

If not, clean up the...