Author Archives: user

SQL – Database Tuning Table of content SQL Database Tuning Database Tuning in SQL is a set of activities performed to optimize a database and prevents it from becoming a bottleneck. There are various techniques with which you can configure the optimal performance of a particular database. Database tuning overlaps with query tuning; so, good […]

SQL – Common Table Expression (CTE) Table of content A Common Table Expression (CTE) can make it easier to manage and write complex queries by making them more readable and simple, like database views and derived tables. We can reuse or rewrite the query by breaking down the complex queries into simple blocks. The SQL […]

SQL – Cursors Table of content A database cursor solves the problem of impedance mismatch. It acts as a filter between the result of a SQL query and the statements that process this result. Cursors in SQL A Cursor is a temporary memory that is allocated by the database server at the time of performing […]