HTH

You can lookup

sp_attach_db

and

sp_detach_db

in the books online

have you tried :

SELECT opvw_p.Team,

opvw_p.Consultant,

opvw_p.[Opportunity Type],

opvw_p.[Opportuntiy Create Date],

opvw_p.Milestone,

opvw_p.[Milestone Start Date],

opvw_p.[Projected Revenue],

opvw_p.[Projected Milestone Completion Date],

opvw_p.[Group ID],

opvw_p.Organizaiton,

opvw_p.[Group],

opvw_p.[Opportunity Name],

opvw_p.[Project Name]

FROM opvw_projections_openProj opvw_p

COMPUTE SUM([Projected Revenue])

...

From books online on msdn :

count(*)

Specifies that all rows should be counted to return the total number of rows in a table. COUNT(*) takes no parameters and cannot be...

Create an full text index and index a column with it then run this :

Select * from dbo.YourTable where IndexedCol = 'blabla'

Select * from dbo.YourTable where CONTAINS (IndexedCol, 'blabla')

and...

Actually it's the other way around.. sql won't use full tect search unless you specifically ask it to.

* has the advantage that sql server will determine which is the best way to find the count(*). This will allow the server to do an index seek/scan without...

Good point... but I guess it's more in the billions helped... I can't help to think that some of us on this Earth are not geeks

Hehe... I thaught I was going crazy missing something so simple in that query...

But that still doesn't tell us what's wrong with the delete statement. Any ideas?

Still don't see it...

what did I miss Noeld???

This returns a lot of records for me >>>

Select name, min(id) as AutoID, count(*) from dbo.SysColumns group by name having count(*) > 1

You're better off starting a new thread for this question.. YOu'll get more answer that way.

How many records does this returns??

SELECT MIN(autoID) AS autoID, Email

...

You don't need to create anything.

t1 and t2 are aliases for the table name.

It's the same as doing this :

Select * from dbo.SysObjects O1 inner join dbo.SysObjects O2 on...

t1 and t2 are the same aliased table. The table you want to remove dups from.

Can you check if the execution plans are the same on each server?

Could you also run the profiler to see which querie(s) take the most time to run?