UML Tutorial

Comments

Post a Comment

Popular posts from this blog

Microsoft Technology

Throw Vs Throw ex Posted: 29 Jun 2010 08:41 AM PDT Throw Throw Ex try    {          // do some operation that can fail    }     catch  (Exception ex)    {         // do some local cleanup          throw ;    } try    {          // do some operation that can fail    }     catch  (Exception ex)    {         // do some local cleanup          throw  ex;    } It preserve the Stack information with Exception It Won't Send Stack information with Exception This is called as "Rethrow" This is called as "Breaking the Sta...
Read more

Design Patterns

Image
There are three basic classifications of patterns Creational, Structural, and Behavioral patterns. Creational Patterns • Abstract Factory :- Creates an instance of several families of classes • Builder : - Separates object construction from its representation • Factory Method :- Creates an instance of several derived classes • Prototype :- A fully initialized instance to be copied or cloned • Singleton :- A class in which only a single instance can exist Note : - The best way to remember Creational pattern is by remembering ABFPS (Abraham Became First President of States). Structural Patterns • Adapter :-Match interfaces of different classes . • Bridge :-Separates an object’s abstraction from its implementation. • Composite :-A tree structure of simple and composite objects. • Decorator :-Add responsibilities to objects dynamically. • Façade :-A single class that represents an entire subsystem. • Flyweight :-A fine-grained instance used for efficient sharing...
Read more

Query Optimization Tips

Use  views and stored procedures  instead of heavy-duty queries. Try to use  constraints  instead of triggers, whenever possible. Use  table variables  instead of temporary tables. Try to use  UNION ALL statement  instead of  UNION , whenever possible. Try to  avoid using the DISTINCT  clause, whenever possible. Try to  avoid using SQL Server cursors , whenever possible. Try to  avoid the HAVING clause , whenever possible. If you need to return the total table's row count, you can use alternative way instead of  SELECT COUNT(*) statement. Include  SET  NOCOUNT   ON  statement into your stored procedures  to stop the      message indicating the number of rows affected by a T-SQL statement. Use the select statements with  TOP keyword or the SET ROWCOUNT  statement, if  you need to return only the first n rows.        More Tips w...
Read more