Hi Nakul Vachhrajani, Thank you for the information. As I am a beginner on SQL server can you provide some more information or links to know about Durability of SQL Server....

Hi Nakul Vachhrajani, Thank you for the information. As I am a beginner on SQL server can you provide some more information or links to know about Durability of SQL Server....

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

The ACID rules of transaction in any database assure the reliability of data in all transactions in the database. Atomicity (“all or nothing” rule) - this rule states that either the complete transaction takes place, or none. Even if a part of a transa...

The ACID rules of transaction in any database assure the reliability of data in all transactions in the database. Atomicity (“all or nothing” rule) - this rule states that either the complete transaction takes place, or none. Even if a part of a transa...

The ACID rules of transaction in any database assure the reliability of data in all transactions in the database. Atomicity (“all or nothing” rule) - this rule states that either the complete transaction takes place, or none. Even if a part of a transa...

The ACID rules of transaction in any database assure the reliability of data in all transactions in the database. Atomicity (“all or nothing” rule) - this rule states that either the complete transaction takes place, or none. Even if a part of a transa...

SQL Server 2005 introduces a new TSQL feature that allows you to retrieve data affected by insert/update/delete statements easily. This is achieved by the use of OUTPUT clause which can reference columns from the inserted and deleted tables (that are av...

SQL Server 2005 and above has total of 4 ranking function. Ranking functions return a ranking value for each row in a partition. All the ranking functions are non-deterministic. **ROW_NUMBER** () OVER ([] ) Returns the sequential number of a row with...

A collation specifies the bit patterns that represent each character in a data set. Collations let users sort and compare strings according to their own conventions. 1) Code Page This is a single-byte character set that represents the alphabet, pu...