Frequent SQL Server Errors

For the last few days, I've been getting an error when trying to load some pages in PA...

------
Microsoft SQL Server Native Client 11.0 error '80004005'

Transaction (Process ID 139) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

/artist.asp, line 13
------

It usually happens when I click a link to a band page or a specific album.  I have to try 2 or 3 times to reload before the page comes up.

What's going on?

Ex database administrator here (admittedly on Oracle, not SQL Server, same principle).

This is a temporary error which should resolve itself given time. Basically, a query to a database table has failed, the table data (ie the page, a comment, whatever) ends up locked. This means that SQL Server thinks it's been looked at or updated at the moment, so the data is locked until the (supposed) update finishes. Actually, it never will as the data update has failed. 

Anyway, after a certain period there's a background process which resolves the lock. OR in nasty cases, it can stay locked until the next reboot. Nothing you can do about it, the database for the site won't be monitored by the ISP. Just wait.