All posts by balvvant2006
Facade Pattern
They fall into structural pattern categories. Façade pattern sits on the top of group of subsystems and allows them to communicate in a unified manner. The façade takes care of orchestration part and present more simplified interface to the client. Example: In a typical online shopping cart when a customer places any order following […]
Singleton Pattern
The singleton pattern falls into Creational patterns. When it is used Used when we want only one object to be shared between clients. The client should not create an object. The object should be created only once and then the same object should service all the client requests. How to Implement There are various different […]
Abstract Factory Patterns
This is a rarely used pattern. It exists only when you have factory patterns in the project. Abstract factory expands on the basic factory pattern. Abstract factory helps us to unite similar factory patterns classes into one unified interface. This leads to more simplified interface for the client. Example: Steps: We have common […]
Factory Pattern
Introduction One of the most widely used creational patterns is the Factory. This pattern is aptly named, as it calls for the use of a specialized object solely to create other objects, much like a real-world factory. We need Factory pattern: To eliminate new keywords to create on client. The client is not aware of […]
SQL SERVER INDEXES
Definition Indexes are one of the biggest determinate of database performance. Indexes allow you to speed query performance on commonly used columns and improve the overall processing speed of your database. Types Microsoft SQL Server supports two types of indexes: Clustered indexes define the physical sorting of a database table’s rows in the storage media. […]
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 […]
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 […]
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 […]