Welcome to Sign in | Help

Browse by Tags

All Tags » sql   (RSS)
On a project I’m currently involved with we have to handle a constant influx of audit messages for processing. The messages come from about 50 SQL Express instances located in data centers around the globe, delivered via Service Broker into a processing Read More...
The SMO libraries contain an enum for the DBCC commands: DbccCommand. But there is little explanation in the MSDN documentation what those commands are. I had a recent discussion with a developer who, understandably, expected a little cleaner explanation 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...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/29/lockres-collision-probability-magic-marker-16777215/  @jrowlandjones blogged about a dubious deadlock case. I recommend this article as is correct and presents Read More...
More Posts « Previous page