Tag Archives: SQL
SQL : Transactions and ACID properties.
Welcome to CodeSpread!There are always two point of views of transactions. First, the user point of view, for example, customer went to an ATM to retrieve some amount. For him, the transaction might look like, For a developer or admin, the transaction will be, But did we estimate any failure condition in both of the…..
SQL : Clustered and NonClustered Index
We read about SQL indexes in our previous post, We will dive into the topic and learn the different types of indexing possible in SQL. We have clustered and non-clustered index in SQL, let’s see the difference, their operation and advantages each one have. We have a basic understanding that indexes are created on columns…..
SQL: Story of Indexes
I know many people know everything about this topic but as this is one of my favorite topics, I will make sure that I will give you some additional information or knowledge. My first thought about Indexes is that ‘It is a solution’. I assume that you will ask me ‘What was the problem behind…..
SQL: Bitwise Operator SlideShow and ScreenCast
Here is a slide show and screencast of Bitwise Operator . This slide show is also available for download. You can also check the screencast on our youtube channel.
SQL: Common Table Expression called CTE SlideShow and ScreenCast
Here is a slide show and screencast of Common Table Expression called CTE . This slide show is also available for download. You can also check the screencast on our youtube channel.
SQL: Common Table Expression called CTE
I remember somebody talked about CTE or Common Table Expression with me and tried helplessly to make me understand it. Honestly, I listened very peacefully but was not able to figure out the exact behavior of CTE.Then i went my usual way, which is try to understand the dictionary meaning of CTE or Common Table…..
