In previous post I explained basics of ISOLATION levels in general. This post is a sort of demo of isolation levels in SQL Server. In SQL Server, Isolation property can be configured using “SET ISOLATION” command. This command can be used to set isolation at any given transaction. SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED GO
Tag: Database
Isolation levels in SQL Server … part I
Just like any reliable transaction system, SQL Server supports ACID properties. If you have never heard of ACID properties before than it is actually set of four properties Atomicity, Consistency, Isolation and Durability. These set of properties makes sure that what ever transaction we do in SQL Server (or any DBMS) and database performs consistently
WordPress and Database Connection Error …
This week, I changed my WP Blog password and DB Password for that blog as well. And I did it using control panel provided by my hosting service provider. It went all well without any sort of error or so. But just today when I was trying to access my blog for some past reference,
Database Normalization … taming the wild horse
For any application to use database and hence data effectively it is very important that data is organized properly. The most common problem for database is redundancy in data. If table has highly redundant data, that means for every operation (like insert, update or delete) it takes more effort to find correct record. And it
SQL Server … Searching Tree !!!
If by any chance you happen to know a little history of computers, you will be surprised that most of the early innovators had taken their primary field of study as Mathematics or Physics !!! At first glance, you may wonder what a mathematician is doing in field of computers right ?? But even if
Database …. Introduction to SQL Server
After understanding of internal of DBMS, different major physical components we are now ready to move company specific DBMS product, and the product i work on is Microsoft SQL Server. Microsoft is “fresher” in database field compared to its rivals Oracle and IBM. But it has conquered significant portion of market as of today and
Database 101 … Physical Requirements
Just like any other software, any given DBMS has its own system requirements. They too have min. and recommended system requirements. Minimum system requirements are something that DBMS need to just “work” and recommended system requirements can make DBMS work well beyond OK (but having very good performance of DBMS is whole different story) But