Archive for category Technology

Design Patterns

Many a times I have wondered about Design Patterns.  I thought it was a complex subject and it needs more stuff to understand them.  But eventually out of my experience I have understood that Design Patterns are something which we use them in our day-to-day activities.  All the above mean in particular with programming and that too in .NET.  Several years before I created a website which hosted all my funny and interesting emails.  I had used some design patterns in them.  On later stage I came to know that I have used MVC Pattern, Factory Pattern and Singleton Pattern in the website.

As of now almost everything in programming follows a design pattern which helps a lot when it comes to complex programming.  All the developers to some extent might be aware of the Object Oriented Programming.  But it would be the best if they are able understand the real life problems that they face with OOP.  Design Patterns come to rescue over solving some complex issues with ease.

For a long time Design Patterns are in the safe lockers of Architects.  Now an awareness was found among the developers to concentrate more on Design Patterns.  I was trying to google around an was able to see lots of information about design patterns.  I would like to list a few of them for your reference.

  1. http://wiki.asp.net/page.aspx/276/design-patterns/
  2. http://msdn.microsoft.com/en-us/library/ms954629.aspx

Also you can find more than I have listed.   I hope this post might find you interesting to have a look into design patterns if you have not looked into it yet.

, , ,

No Comments

A Note About Indexing

For queries to run efficiently it is important that appropriate indexes be in place. A simple guideline is that all fields referenced in a comparison in a WHERE clause or in the ON clause of a JOIN statement should be indexed. Bear in mind that all primary key fields are automatically indexed, but that foreign keys must have an index added manually.

Well, there you have it. Now that you have witnessed some of the awesome power of SQL, with its greater flexibility and increased capability, it is easy to see why it is the query language of choice for high-end database servers.

No Comments

Switch to our mobile site