slow performance after sql update from access

Hello I ran an update query from access now the server is running slow.
Can re index? what is the procedure/command for this? is it possible to
disable all triggers when i run my update sql scripts? i ran profiler
and saw a few connecting ... messages could this have something to do
with this? thanks.

1. Maybe.  DBCC SHOWCONTIG will tell you if the table is fragmented
2. Look up reindexing in BOL
3. Yes.  Look up triggers in BOL

--
Mike
Mentor
Solid Quality Learning
http://www. solidqualitylearning
.com


<jcharth@hotmail.com> wrote in message
news:1135949796.799593.99250@g14g2000cwa.googlegroups.com...
> Hello I ran an update query from access now the server is running slow.
> Can re index? what is the procedure/command for this? is it possible to
> disable all triggers when i run my update sql scripts? i ran profiler
> and saw a few connecting ... messages could this have something to do
> with this? thanks.
>