SQL Server

Heap

What is a SQL Server Heap? Before we get into the different types of indexes that are available in SQL Server we should first describe the basic structure of a table.  Tables with no clustered…

SQL Server

Triggers

Triggers are specail stored procedures that execute automatically based on an event. There are 3 types of triggers: DML (Data-Manipulating Language) Triggers: work when the event of DMLs are invoked like Insertion, Updating, Deletion etc…

SQL Server

Views

where ever we use a select statement we get some kind of resultset. in order to save our time sql provides a functionality to save such queries as views so Views are basically stored queries.…