How to produce the set of numbers within a given range without using While loop? OR How to check hierarchies within an employee table? OR How to reduce the lines of code for checking multiple IF exists condition within the same table?
Use the recursive CTE functions
Why social work is important?
We all are humans and we all are here in this world to enjoy life. Spreading love, helping others, imparting knowledge and giving belief that life is beautiful to those who require gets me connected to my soul which is enlightening and divine.
What are the steps in tuning the performance of a database?
Well, apart from the requirement of a good hardware to support a database, the important steps in the performance of a database is a good database design involving security, maintaining standards while writing a query, indexing, and partitioning. My first step is always to check for the table structure, and query performance since the main component of a database in any application are tables and queries written to perform operations. Without all these steps, even a good hardware won't be sufficient for a good performance of the database.