Blocking and deadlock on SQL Server

If I use "select * from sysprocesses where blocked >0' I see a record setup. Does it mean this task is blocked some resource on the server ? In addition, what is meaning for 'AWAITING COMMAND' under column 'cmd'

Try the way in this
http://stackoverflow.com/questions/12422986/sql-query-to-get-the-deadlocks-in-sql-server-2008 (http://stackoverflow.com/questions/12422986/sql-query-to-get-the-deadlocks-in-sql-server-2008)

Long way back, we had to take help from third party tools in order to encrypt and decrypt data. Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…

You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes.
Assigning simple products to configurable: We assigned simple products…