The default setting in SQL Server 2005 and later is to keep a trace running all the time that captures basic information about the instance. This is called the Default Trace. The created trace files can be viewed in Performance … Read more →
Deadlocks in SQL Server can be difficult to avoid completely, but there are some basic rules that can help in avoiding them. This blog post will cover the basics of deadlocking in SQL Server.