Microsoft SQL has two variants i.e. CROSS APPLY and OUTER APPLY. Both operators are in SQL used to perform table-valued function /correlated subqueries against rows in another table. CROSS APPLY It is similar to an INNER JOIN i.e. It returns rows from the left table that have a matching row in the right table. NoContinue reading “Understanding Microsoft SQL CROSS APPLY and OUTER APPLY Operators”
Category Archives: Uncategorized
SQL – Information of TRY, CATCH and Error Handling
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 vs Index Seek
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”
Introduce Myself
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.
