Difference between TRUNCATE and DELETE commands in SQL-Server

TRUNCATE is a DDL command whereas DELETE is a DML command. TRUNCATE is much faster than DELETE. When you type DELETE. All the data get copied into the Rollback Tablespace first. Then delete operation get performed. That’s why when you type ROLLBACK after deleting a table; you can get back the data (The system gets it for you from the Rollback Tablespace). All this process takes time. But … Continue reading Difference between TRUNCATE and DELETE commands in SQL-Server

A brief introduction to UML

Unified Modeling Language (UML) is a standardized modeling language enabling developers to specify, visualize, construct and document artifacts of a software system. Thus, UML makes these artifacts scalable, secure and robust in execution. UML is an important aspect involved in object-oriented software development. It uses graphic notation to create visual models of software systems. Some of the important components of UML are: Use Case Diagrams … Continue reading A brief introduction to UML

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 even whether a single browser instance is still actively viewing … Continue reading ASP.NET State Management techniques

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 number of professors. Now due to some reasons, if the … Continue reading Aggregation & Composition in OOPs