MS SQL Server - slow performance after sql update from access

Author

slow performance after sql update from access

jcharth@hotmail.com

2005-12-30, 9:23 am

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.

Michael Hotek

2005-12-30, 11:23 am

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.
>

Sponsored Links