Thomson Reuters Interview Question

Explain SQL Join. What causes memory leaks in C#