In SQL Deadlocks are very crucial things which we need to handle with ease, So for this features, You can do whatever if any error occur.@@ERROR is not used for every statement executed then.TRY and CATCH helps to write logic and error handling code differenly.Whatever code need to execute you can write in TRY blockContinue reading “SQL – Information of TRY, CATCH and Error Handling”
Index Scan:Index scan touches every row in the table, whether or not it qualifies, the cost is proportional to the total number of rows in the table. Thus, a scan is an efficient strategy if the table is small or if most of the rows qualify for the predicate. A scan is the opposite ofContinue reading “Index Scan vs Index Seek”
Hi every one! My name is Nitin, I live in Mumbai, and a database developer for almost 5+ years (SQL). I started using WordPress for a SQL blog sql.tech.blog … So that was my real first approach with WordPress as a user. I started to have an interest as a developer.