>Is this problem when you click on the Profile to get messages? I got a long delay there today.
This is the query to get the online and offline users. The delay is caused by the search engine. We are offloading the search engine to another server this weekend. So, whenever a hit will be done on the search, it will not affect the Web site.
>In SQL Server 2008 you can use date field, but I don't know if this is going to solve the problem. You can use DATETIMEOFFSET as well.
I am not sure what you recommend here. Could you elaborate a little bit more?