The Wrecking Bawl

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/dnC

Posted On Monday, May 20, 2013 11:13 AM | Comments (0)
Filed Under [ all tech stuff SQL Server ]

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/diV

Posted On Friday, April 12, 2013 12:00 PM | Comments (0)
Filed Under [ SQL Server ]

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/dZV

Posted On Friday, February 15, 2013 12:04 PM | Comments (0)
Filed Under [ SQL Server ]

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/dP0

Posted On Friday, December 7, 2012 12:34 PM | Comments (0)
Filed Under [ SQL Server ]

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/dOv

Posted On Thursday, December 6, 2012 10:06 AM | Comments (5)
Filed Under [ SQL Server ]

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/d1J

Posted On Wednesday, June 20, 2012 4:29 AM | Comments (0)

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/ctk

Posted On Thursday, May 3, 2012 7:08 AM | Comments (1)

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/cik

Posted On Wednesday, February 29, 2012 10:43 AM | Comments (4)

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/cZ1

Posted On Wednesday, January 4, 2012 9:22 AM | Comments (2)

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

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/bzR

Posted On Thursday, June 30, 2011 6:19 AM | Comments (0)

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.

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/byN

Posted On Friday, June 24, 2011 6:27 AM | Comments (0)

If you're like me you had at one time connected one of your Reporting Services instances to a report server database that was already in use by another instance.  This allows the instance to show up in the Scale-out Deployment section of the Reporting Services Configuration Manager.  My problem was that the server that got joined to the original server was no longer available as it had been repurposed, and when I clicked Remove Server to remove it from my scale-out it would fail because it couldn't contact the server.  After searching for a solution for quite some time I decided to look around in the report server database tables, and voila!  All I had to do was remove the old server from the Keys table.  I can't guarantee there won't be any side effects to this method, but it worked like a charm for me.

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/bVN

Posted On Thursday, March 3, 2011 7:49 AM | Comments (1)

If you're wondering how to migrate your SharePoint databases to a new server, this Microsoft article is actually pretty useful, though still overly complex like most of their other articles.

http://technet.microsoft.com/en-us/library/cc512725.aspx

The one thing I would change is that they seem to recommend installing SQL Server Configuration Manager on web servers, when all that was needed in my case was to add an entry to the hosts file on the SharePoint web server that used the IP address of the new SQL Server with the name of the old SQL Server.  This might not be appropriate in cases where the old server is not being decommissioned.

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/bS6

Posted On Wednesday, February 16, 2011 10:55 AM | Comments (0)

For those of you who, like me, transitioned from Subversion and TortoiseSVN to TFS, you might be confused as to how to view the history of a folder recursively.  My problem was that I was wanting to see the recursive history in the Solution Explorer rather than the Source Control Explorer.

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/ajm

Posted On Friday, August 6, 2010 8:45 AM | Comments (1)

If there's already a way to get a List<int> of consecutive integers without a loop in C#, I don't know what it is, so I created a method for it.

        public static List<int> GetIntegerListFromRangeUsingLoop(int start, int end) {
            if (end < start) {
                throw new ArgumentException("Faulty parameter(s) passed: lower bound cannot be less than upper bound.");   
            }
            List<int> returnList = new List<int>(end - start + 1);
            for(int i = start; i <= end; i++) {
                returnList.Add(i);
            }
            return returnList;
        }

 UPDATE:

I was pointed to Enumerable.Range(), so I updated my code.

        public static List<int> GetIntegerListFromRangeUsingEnumerableRange(int start, int end) {
            IEnumerable<int> list = Enumerable.Range(start, end - start + 1);
            return list.ToList();
        }

Then I used the StopWatch class in my unit tests to compare the two methods.

Results:

GetIntegerListFromRangeUsingEnumerableRange averaged 6.5 milliseconds.

GetIntegerListFromRangeUsingLoop averaged 0.43 milliseconds.

Wow.  Apparently Enumerable.Range() is a lot slower than using a loop.

• Share This Post:
• 
• 
• 
•   Short Url: http://wblo.gs/aJA

Posted On Wednesday, April 28, 2010 7:17 AM | Comments (2)