Toluu

Bill Pierce - Insert Catchy Title Here

Work to Live. Live to Code.

SSMS Execution Plan – Insert Index HereDecember 24 2008

I was troubleshooting a performance issue with a particular stored procedure in our application.  Myself being a developer my thought process is DB Performance Issue => Add an Index.  That is about the extent of my knowledge and when that doesn’t work I stop questioning what exactly it is that a DBA does :)  To figure out where an index is needed I would usually zero in on WHERE clauses and make sure any filtered columns are indexed.   The problem is this stored procedure was ginormous and called several other sprocs on its path to destruction.  So, I thought I’d check out the execution plan.  So I was using SSMS 2005 because that is what was installed on the machine I was remoted in to.  Problem was the execution plan looks like it was a collaboration of Dr. Seuss and MC Escher.  I didn’t want to tie up the server so I saved the execution plan and copied it down to my local machine (the plan was over 1MB so you feel my pain).  I tried to grok the plan for a while but didn’t have any luck so I decided to run the sproc with the troublesome parameters on my local box to see if the performance was bad locally.  I run SSMS 2008 on my local machine and when I ran the query with the execution plan turned on, lo and behold, the Execution Plan told me in bright green letters “Hey idiot stick, you are missing an index on Table X with Columns (Y and Z) Include (A, B, C).”  Needless to say I thought this was an awesome feature and sure enough, adding the in

Using Perforce Visual Merge with Team Foundation ServerDecember 24 2008

The best way to handle merging is to not do it at all :)  Merging can be a very painful process, especially if you are using the wrong tools.  I was a long time user of Perforce for source control and this company’s great tools made merging very straight forward.  I have now transitioned to a Team Foundation Server 2008 environment and while this tool is growing in usefulness, it still lacks in a few areas.  Luckily TFS can be configured to use existing merge tools, including Perforce Visual Merge (P4merge) from Perforce.

You can configure TFS to use a different merge tool by running the following from a Visual Studio Command Prompt:

tf diff /configure

This brings up a dialog like so

If you don’t already have a Merge operation line, you can add one, otherwise just modify the existing one and make it look like so:

Blogs I FollowOctober 21 2008

Justin Etheredge posted a list of blogs that he follows.  He also posted a snippet of LINQ that converted his OPML file to a simple unordered HTML list.  He encouraged his readership to let him know if there are any really good blogs he was missing.  I was curious to see which blogs he reads that I have not yet subscribed to.  I tweaked his LINQ slightly to output blogs that were in his OPML file, but not in mine.

var doc1 = XDocument.Load("http://media.codethinked.com/downloads/Opml.xml"); var doc2 = XDocument.Load("http://services.newsgator.com/ngws/svc/opml.aspx?uid=134891&mid=1"); var result = new XElement("ul", from d1 in doc1.Elements("opml").Elements("body").Elements("outline") join d2 in doc2.Elements("opml").Elements("body").Elements("outline") on d1.Attribute("htmlUrl").Value equals d2.Attribute("htmlUrl").Value into d3 from d2 in d3.DefaultIfEmpty() where d2 == null select new XElement("li", new XElement("a", new XAttribute("href", d1.Attribute("htmlUrl").Value), d1.Attribute("text").Value ), " ", new XElement("a", new XAttribute("href", d1.Attribute("xmlUrl").Value), "RSS" ) ) ); using (var xw = XmlW

NHibernate ProxyGenerators 1.0.0 Beta ReleasedOctober 7 2008

Read about it at NHForge.org

del.icio.us Tags: nhibernate proxygenerators

Please Explain the FollowingOctober 6 2008

Can someone please explain how this is possible?