Intermittent problem with querying a table

[aolb]

We have a problem with one of our tables that has started to occur.

The table has about 4500 records and when it is queried select * from xxx it hangs. When we select count(*) from xxx it returns instantly.
When we stop and restart the SQL Service the problem stops only to return the next day.

Does anyone have any idea where the problem may lie?

Thanks

 

[Ambientguitar]

We have had intermittent problems with some tables nad have found that reindexing all tables has helped.

 

[aolb]

thanks, we'll look into it