Welcome to Sign in | Join | Help

Browse by Tags

All Tags » 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/28/asynchronous-t-sql-at-sql-saturday-26/  The Seattle area PASS group is organizing the SQL Saturday #26 in Redmond on October 2nd. There are many sessions 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/08/18/passing-parameters-to-a-background-procedure/  I have posted previously an example how to invoke a procedure asynchronously using service Broker activation. Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/08/05/asynchronous-procedure-execution/  Recently an user on StackOverflow raised the question Execute a stored procedure from a windows form asynchronously and 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...