sometimes we need to check if a directory is empty or not before performing an operation on this directory.For this,
Continue readingAuthor:
Difference Between Checkpoint And Lazy Writer
CHECKPOINT vs LAZY WRITER CHECKPOINT LAZY WRITER Check point runs in only transaction log file Lazy writer operates from buffer
Continue readingLazy writer in SQL Server
Lazy writer Lazy writer in SQL Server :- Lazy writer check each page header and verify whether all transactions in
Continue readingWhat’s the difference between TRUNCATE and DELETE in SQL
The difference between TRUNCATE, DELETE, and DROP is one of the most common interview questions. Here are some of the
Continue readingWhat are the difference between DDL, DML, DCL and TCL commands?
DDL Data Definition Language (DDL) statements are used to define the database structure or schema. Some examples are:- CREATE –
Continue readingLock Granularity in SQL Server
Understanding Lock Granularity in SQL Server SQL Server Lock granularity describe which resource is locked by a single lock attempt.
Continue readingPL/SQL Program for Armstrong Number
Armstrong number is a number that is equal to the sum of cubes of its digits. For example 0, 1,
Continue readingPl/SQL Program for Palindrome Number
A palindrome number is a number that remains the same when its digits are reversed. example:- 16461 Pl/SQL Program for
Continue readingPL/SQL Program for Fibonacci Series
Fibonacci Series is a series of numbers in which each number is the sum of the two preceding numbers. The
Continue readingPL/SQL Program to Reverse a String
PL/SQL Program to Reverse a String Here we are going to write a pl/sql program to reverse a string. In
Continue reading