Geeks With Blogs

News
The Wrecking Bawl Destructuring query language, one keyword at a time.

I recently discovered that creating indexes in one of my production databases was causing deadlocks.  My problem was that I wasn't using ONLINE=ON when I was creating the index.  Check out the BOL for more information.

Posted on Friday, June 24, 2011 6:27 AM all tech stuff , SQL Server | Back to top


Comments on this post: indexes and deadlocks

No comments posted yet.
Your comment:
 (will show your gravatar)


Copyright © Alex Bransky | Powered by: GeeksWithBlogs.net