Duplicate records in the database are old age problem that almost every organization has to deal with that.Duplicate may appear
Continue readingHow To Delete Duplicate Rows in SQL Server
Duplicate records in the database are old age problem that almost every organization has to deal with that.Duplicate may appear
Continue readingPerformance Tuning :- How to identify blocking And Lead blocker in SQL Server
During normal processing in a database, it is blocked. Blocking is “by design” because your database is on ACID. In
Continue readingDifferent Types Of Cursor In java
If we want to get objects one by one from the collection we should go for cursor. There are 3
Continue readingJava Program to Find Equilibrium Index of an Array
The following code snippet find Equilibrium Index of an Array in java. class IndexEquilibrium { int findIndexEquilibrium(int A[], int n)
Continue readingJava – GMT to IST Conversion
The following code snippet convert GMT to IST in java. import java.util.*; import java.io.*; import java.text.*; public class GmtToIstConversion
Continue readingJAVA – Convert GMT to EST
The following code snippet convert GMT to EST in java. import java.util.*; import java.io.*; import java.text.*; public class GmtToEstConversion {
Continue readingSQL Server – Cannot detach a suspect or recovery pending database
I tried to detach the database in one of our SQL servers, but received the following error:- Cannot detach
Continue readingGallon to liter conversion in java
To convert Gallon to liter we are using a formula “liter = gallon * 3.7854118“. Java Program to covert Gallon to
Continue readingJava Program To Convert Inches To Metres
To convert Inches To Meters we are using a formula “meters = inches * 0.0254“. Convert Inches To Metres In
Continue reading