Views in Sql Server

Definition: A view is a virtual table created by a stored SQL statement that can span multiple tables. Views can be used as a method of security within your database, and they provide a simpler front end to a user querying the data. A view is a virtual table that consists of columns from one [...]

Read Full Post »

JOIN in Sql Server

Definition: The SQL JOIN statement is used to combine the data contained in two relational database tables based upon a common attribute. Types of Join: Inner Join Outer Join Left Outer Join Right Outer Join Full Outer Join Cross Join 1. Inner Join: Inner Join is a default type join of SQL Server. It uses [...]

Read Full Post »

Triggers in Sql Server

Introduction: The SQL CREATE TRIGGER statement provides a way for the database management system to actively control, monitor, and manage a group of tables whenever an insert, update, or delete operation is performed. The statements specified in the SQL trigger are executed each time an SQL insert, update, or delete operation is performed. An SQL [...]

Read Full Post »

Indexes in Sql Server

Clustered Indexes A clustered index stores the actual data rows at the leaf level of the index. Returning to the example above, that would mean that the entire row of data associated with the primary key value of 123 would be stored in that leaf node. An important characteristic of the clustered index is that [...]

Read Full Post »

Functions in Sql Server

USER DEFINED FUNCTIONS: UDF’s support a wide range of functionality and just because you can’t commit write changes to a database, it doesn’t mean that you should turn a blind eye to them. Here’s a list of the statements that you can include in the body of a UDF: Flow control statements such as IF…ELSE, [...]

Read Full Post »

SQL Query Optimization Tips

SQL Optimization Tips:                        Use views and stored procedures instead of heavy-duty queries. This can reduce network traffic, because your client will send to server only stored procedure or view name (perhaps with some parameters) instead of large heavy-duty queries text. This can be used to facilitate permission management also, because you can restrict [...]

Read Full Post »

ASSEMLIES

Definition:             It is the building block of an application which provides all required execution information to “CLR”. Functions of an Assembly: à    It contains IL that gets executed by CLR à    It forms the security boundaries à    It allows the side – by –side execution of multiple version of same assembly. Features of assemblies [...]

Read Full Post »

JUST IN TIME COMPILER (JIT)

 During Run Time, the CLR invokes the JIT compiler to convert the MSIL into Native code (i.e. Executable Binary Code). When the Function is called, the IL of the function’s body is converted to Native code Just In Time. So the part of code that is not used by the particular run is never converted [...]

Read Full Post »