Deadlock is a situation when two processes, each having a lock on one piece of data, attempt to acquire a lock on the other's piece. Each process woul ...
Search results for sql
What is a deadlock?
Posted by Interview Answers
DELETE TABLE is a logged operation, so the deletion of each row gets logged in the transaction log, which makes it slow. TRUNCATE TABLE also deletes a ...
SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 6 salary FROM employee
ORDER BY salary DESC) a ORDER BY salary
ORDER BY salary DESC) a ORDER BY salary
Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the co ...
Write an SQL Query to Delete Duplicate records from a table using ROWID?
Posted by Interview Answers
A question where every coder/DBA/QA and Tester should now about
Task is to write a function which removed words "INSERT" and "DELETE" from the input string
string Clean(string input)
Result of function clean sh ...
Recent question for DBA position in NYC. My answer about Pivot tables in Excell didn't work very well. Interviewer was keep asking about what is cross ...
SQL Cross Join
Posted by Student-looking-for-job
You have to tables A and B as following:
Table A:
A1 | A2
--------
a11 | a12
a21 | a22
Table B:
B1 | B2
-- ...
