In SQL Server, Collation is a mechnism by which the physical storage of character strings can be controlled. In other words, it determines how character sets (bit patterns) are interpretted in SQL server. This also determine the rules that sort and comp...

Different types of locks inside the SQL Server 2008 R2: 1) **Shared (S) :** For read (SELECT) operations. Compatible with other shared locks, but not with exclusive locks. its like.."I am reading this information". 2) **Update (U):** For resources...

Here, assuming that we have a table TABLE_NAME, with column COLUMN_NAME and we need to include all the names starting with A and J also. Also, writing only most sensible, resource effective and practical solutions. Method 1 SELECT * FROM...

**Triggers** are a special form of stored procedure that are executed automatically when data manipulation language (DML) or data definition language (DDL) commands are executed. The **generic syntax** for creating a trigger is CREATE TRIGGER ...

Isolation is the fence between two transactions. Regardless of what any other transaction is doing, a transaction must be able to continue with the exact same data sets it started with. According to “SQL:2008”, the sixth revision of the ISO and ANSI sta...