Pritam's Blog

Sharing is Caring

By - Pritam Baldota

SQL Server Database Triggers

A trigger is an object contained within an SQL Server database that is used to execute a batch of SQL code whenever a specific event occurs. A trigger is “fired” whenever an INSERT, UPDATE, or DELETE SQL command is executed against a specific table. A Trigger is associated with Database Table There are three types of Database Triggers – INSERT

By - Pritam Baldota

Optimizing SQL Server Database Design Tips & Tricks

Database design is most crucial part in application development. Database can be anything SQL Server, MySQL, Oracle, etc. I will consider SQL SERVER as a part of discussion. Tunning the database depends upon various factors like whether one datatype is better depends on the context of it’s usage. Following are most common datatypes used in database. Numbers Datatype (For storing