Geeks With Blogs

News
The Wrecking Bawl Destructuring query language, one keyword at a time. June 2011 Entries
annoying SSRS bug fix for building

If you're like me you've been using SSRS 2008 for a long time with TFS and have constantly had to delete the bin folder in order for builds to work.  This has irritated me to no end.  Well today is my lucky day!  There is a hotfix that actually fixes the bug!    Go here:  http://support.microsoft.com/kb/2438347

Posted On Thursday, June 30, 2011 6:19 AM

indexes and deadlocks

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

Copyright © Alex Bransky | Powered by: GeeksWithBlogs.net