just to be complete :

where indid=0 gives only heaps !

where indid in (0 , 1) gives heaps and clustered...

In addidition to the other replies :

-If you are going to choose the "delete "-path, go for small transactions.

Declare @Counter int

Set @Counter = 1

Declare @TotCounter int

Set @TotCounter...

dynamic ? Think #/## temptb or @ tablevar.

Populate your temp-object with search- and replacementvalues and join it so you get the correct results.

Maybe this gets you on track:

http://www.sqlservercentral.com/scripts/contributions/100.asp

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=32921&SearchTerms=CSV

1) tell the other dba(s) you're going to redo the restore

            so (s)he doesn't  redo the reboot

2) redo the (full/pit) restore !...

just some readingstuff.

http://www.sqlservercentral.com/columnists/awarren/shouldyoubuyasan.asp

http://www.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine_.asp

http://www.sqlservercentral.com/columnists/kpart/scalingout.asp

http://www.sql-server-performance.com/ew_san.asp

and

forum http://www.sqlservercentral.com/forums/messages.aspx?forumid=54

it works fine overhere

what's your sqlserver version an sp /hotfisex ?

or

SELECT A, count(distinct B) as B_Count, count(distinct C) as C_count

 FROM tableABC

GROUP BY A

what's sp_who/sp_who2/sp_lock stating ?

is msdtc  running ?

is SQLAgent running ? (and is it running any jobs ?)

Do you connect using SQL-authentication or...

In addition to the other replies : check your ODBC-settings (clientside). If ODBC-logging is active, everything slows downdramaticaly.

are your problem sqlservers dedicated servers...

CREATE TRIGGER trg_updatedt ON [dbo].[tablename]

FOR UPDATE

AS

UPDATE tablename

set modified = getdate(), modified_user = suser_sname()

from inserted

where tablename.colid = inserted.colid

check out which user you want to store user_name() <> suser_sname()...

So you'll need to copy the parent row first to the target parent-table, then copy the child row to the target-child-table and then delete the child row from the source-child-table....

if your DRP allows you to, you may want to switch the recovery_option of your db to bulk-logged during the time you rebuild the indexes. This will use less...

select distinct a,b,c

from tableABC

-- order by a,b,c

returns the distinct combination of a,b,c in your table.This way "distinct" is applied at row level.

sometimes, one might want to count the...

euh ..

index 0 is the heap. (index 1 is the number for the clustered index, index 255 contains text, lob stuff)

before trying to...

you may want to take a look at "Read a text file from SQL Server query analyzer" http://www.sqlservercentral.com/scripts/contributions/417.asp