I am experiencing a blocking issue in sql server 2005. An end user executes a query (e.g. select statements) and seems to get into a never-ending blocking until i kill the process e.g. for hours on end .
the end user querys run just fine when I test the. It seems to get into a blocking issue when qanother process tries to truncate and reload a table.
how can I troubleshoot this?