SQL SERVER – ACID

SQL SERVER – ACID

ACID Followed When we r designing the databases and application architectures.

    Atomicity

is an all -or-none Operations are performed in Transaction

    Consistency

guarantees that a transaction never leaves your database in a half-finished state.

    Isolation

keeps transactions separated from each other until they’re finished providing certain levels like Isolation levels

    Durability

guarantees that the database will keep track of pending changes so that they can be recovered when database Crashes

Advertisements

About kakani santosh kumar

Working as Software Engineer in Prithvi Information Solutions having 3 years of Experience in Dotnet Framework ranging from 1.1 to 3.5
Aside | This entry was posted in Articles, Database and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s