Welcome to Sign in | Help

Browse by Tags

All Tags » sql » tsql   (RSS)
A very common question asked on all programming forums is how to implement queues based on database tables. This is not a trivial question actually. Implementing a queue backed by a table is notoriously difficult, error prone and susceptible to deadlocks. Read More...
Copyright Remus Rusanu 2010. Visit the original article at http://rusanu.com/2010/01/12/what-deprecated-features-am-i-using/   select instance_name as [Deprecated Feature] , cntr_value as [Frequency Used] from sys.dm_os_performance_counters Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/09/13/on-sql-server-boolean-operator-short-circuit/  Recently I had several discussions all circling around the short-circuit of boolean expressions in Transact-SQL Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/06/11/exception-handling-and-nested-transactions/  I wanted to use a template for writing procedures that behave as intuitively as possible in regard to nested Read More...