The future depends on us. It is up to us to the future of Clarion.
Will this programming language to live long and happy life or dies in oblivion depends on us. If you have to say, do it here in this blog. Welcome!

Read More

Diagnose SQL Server performance issues using sp_lock

Posted April 1st, 2008 by Andrew Popoff

A common misconception among IT pros is that “locks are bad,” and you must do everything possible to ensure database locking doesn’t prevent processes from running. In order to ensure a consistent database environment, the database engine must use a mechanism to acquire exclusive use of a resource when that resource is being modified.
SQL Server [...]

Tags: | No Comments »

Category: SQL

Write your own sp_lock system stored procedure in SQL Server 2005

Posted January 8th, 2008 by Andrew Popoff

The sp_lock system stored procedure is a great tool for checking the amount of locking that occurs on your database system. It returns the number and types of locks that are being held by current active SQL Server sessions. One of my previous articles describes how you can use sp_lock to diagnose problems on your [...]

Tags: | No Comments »

Category: SQL