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

Nice coding reduces misunderstandings and misreadings

IF NOT (@TempVal) IS NULL

Begin

   IF @TempVal < @RetVal

   begin

      SET @RetVal = @TempVal

     end

end

PRINT @RetVal

or

if isnull(@TempVal,...

Hey, Back online.

I hope everything went just as smooth as you planned it.

Seems good over here.

Nice...

Aaarch ... you've told her ...

.... Now you'r under pressure And you have a deadline .., or "suitcases at the door"-line .

Thanks for all the replies.

"Helas" all our central servers are already migrated to W2k or W2k3 .

indeed.

I guess there are other reg-keys which store the info in HEX and get a nice guid-like reg-key.