Oct 292012
 

Recently I came into a problem when I accidentally added a user to CRM that caused the entire CRM instance to no longer be usable. What happened is the user shared I added to an instance was the user that created the CRM instance.  That cause the whole instance to throw an error any time anyone would load it up. Continue reading »

Nov 162011
 

Given most programming problems there is an almost endless number of ways to implement a solution for even the most simple task. One of those tasks that many take for granted is string manipulation. When talking to a friend recently about this it brought up the question of which method is faster and better performing. So I decided I needed to look at execution speeds and memory usage of three of the main string manipulation implementations; String.Format, StringBuilder and String Concatenation. Continue reading »

Jun 092011
 

Recently I came across the need to insert the same unique identifier into two separate columns in the same insert statement. It turns out that it is a relatively easy solution but something that took a little bit of ingenuity.

So it’s not often, in fact I can’t think of many instances where you would need to insert the same unique identifier into two different columns in a single table in a single insert statement. As you may or may not know the easiest way to get a new unique identifier in T-SQL is using the command NEWID(). However, the problem is that if you make this call twice in a single statement you’ll get two unique identifiers. Continue reading »

Apr 152011
 
While writing a large series of in-line if / else statements I came across a very fundamental question.  Which one is faster, in-line if / else statements or your standard if / else statement block?  No matter who I asked no one seemed to have a good answer, so I took it upon myself to find one.We can all probably agree that in-line if statements certainly take up less space and some may argue that the are much cleaner code.  And to be fair the more I’ve used in-line statements the more I’ve come to like them.  But the question still remained, in the realm of performance which one was faster. Continue reading »