Welcome to Sign in | Help

Browse by Tags

All Tags » Tutorials » Troubleshooting   (RSS)
The SQL Server transaction log contains the history of every action that modified anything in the database. Reading the log is often the last resort when investigating how certain changes occurred. It is one of the main forensic tools at your disposal Read More...
If you are a developer writing applications that use SQL Server and you are wondering what exactly happens when you ‘run’ a query from your application, I hope this article will help you write better database code and will help you get started Read More...
You probably can easily answer a question like ‘What columns does this table have?’. Whether you use the SSMS object explorer, or sp_help, or you query sys.column, the answer is fairly easy to find. But what is I ask ‘What are the physical Read More...
Certain SQL Server query execution operations are calibrated to perform best by using a (somewhat) large amount of memory as intermediate storage. The Query Optimizer will choose a plan and estimate the cost based on these operators using this memory Read More...
Copyright Remus Rusanu 2009. Visit the original article at http://rusanu.com/2009/05/16/readwrite-deadlock/  How does a simple SELECT deadlock with an UPDATE? Surprisingly, they can deadlock even on well tuned systems that does not do spurious Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/11/26/replacing-service-certificates-that-are-near-expiration/  Service Broker services use certificates for authenticating message origin and for encrypting messages. Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/08/13/error-handling-and-activation/   I have previously talked here about the queue monitors and the role they play in launching activated procedures. If you Read More...
Copyright Remus Rusanu 2008. Visit the original article at http://rusanu.com/2008/08/03/understanding-queue-monitors/A major class of Service Broker applications have nothing to do with the distributed application capabilities SSB was designed for. Instead Read More...