What is a Dirty page?

Dirty page When we do any modification in the data, same will not be impacted in the physical table immediately. This follows a cycle to complete the action.  Modify the data in buffer cache pages – Called ‘Logical write’. Write the same

Read More

What is the difference between ASCII() and CHAR() functions?

ASCII() vs CHAR(): ASCII() and CHAR() functions work with ASCII characters. But the functionality wise, both work quiet opposite. ASCII() function returns the ASCII code number for the given character as input. Where as, CHAR() function returns the ASCII character for the

Read More