Repository pattern is usefult for decoupling entity operations form presentation, which allows easy mocking and unit testing.
“The Repository will ...
Search results for query
Stack and Queue interview questions
Posted by CMaster
Stack and Query structures in computing are extremely fundamental and important. Then interviewing I expect candidate to fully understand this data s ...
Continuing list of common mistakes from real phone interview
Not verbalizing your answer:
It is a huge deal in technical phone interviews as the ve ...
The sub-query contained in the query requests values from the outside query, creating a loop.
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
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 ...