Search results for sql


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 ...
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

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 ...
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 ...
You have to tables A and B as following: Table A: A1 | A2 -------- a11 | a12 a21 | a22 Table B: B1 | B2 -- ...