Monthly Archives: February 2013
Some SQL-Server Performance Enhancement Tips
Choose the Appropriate Data Types Use Triggers Cautiously Use views and stored procedures instead of heavy queries. It reduces network traffic, because client will send to server only stored procedure or view name (in certain cases heavy-duty queries might degrade performance up to 70%) instead of large heavy-duty queries text. This also facilitates permission management […]
ASP.NET State Management techniques
State management is the process by which you maintain state and page information over multiple requests for the same or different pages. As is true for any HTTP-based technology, Web Forms pages are stateless, which means that they do not automatically indicate whether the requests in a sequence are all from the same client or […]
Aggregation & Composition in OOPs
Aggregation and composition in real project define HAS-A relationship. Aggregation differs from ordinary composition in that it does not imply ownership. In composition, when the owning object is destroyed, so are the contained objects. In aggregation, this is not necessarily true. For example, a university owns various departments (e.g., Physics, chemistry), and each department has a […]