Team - Friday night is turning bad for me...
One of my SPs was taking forever and after a long haul I have nailed it down to one table "TransactionLog" in my db.
Even the statement below is taking forever:
select COUNT(*) from TransactionLog
Just not ending... Can anyone tell what could be the reason??
I ran a dbcc check:
DBCC CHECKTABLE ("dbo.TransactionLog")
The output was:
DBCC results for 'TransactionLog'.
How To Post
There are 67632 rows in 531 pages for object "TransactionLog".
DBCC execution completed. If DBCC printed error messages, contact your system administrator.