Sunday, March 16, 2008

SQL SERVER update @@LOCK_TIMEOUT

After installation the default value of @@LOCK_TIMEOUT is -1. Even if the Connection properties window shows 15 sec.

So if you have a time consuming SQL statement to update something like I had to do today:

UPDATE WorldCitiesPopulation
SET Population = '-1'WHERE (Population = '')

It updated quite a lot of rows: 2652350 row(s) affected; so the default value of 15 sec. is not enough on my machine. To update Timeout you simply execute the following:

SELECT @@LOCK_TIMEOUT
SET LOCK_TIMEOUT 180000
SELECT @@LOCK_TIMEOUT

No comments:

Shared Cache - .Net Caching made easy

All information about Shared Cache is available here: http://www.sharedcache.com/. Its free and easy to use, we provide all sources at codeplex.

Facebook Badge