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 ...
Search results for query
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
A question where every coder/DBA/QA and Tester should now about
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 ...
« previous1 next »