↳
SELECT A.id, A.firstName, A.LastName , B. address1, B.address2. B.city FROM Person A JOIN Address B on A.id=B.id A.id is primary key on table Person and B.id is foreign key in table Address B Menos
↳
Truncate is faster and there is no logging.
↳
Review nodes in execution plans on high cost. Review IO and Time statistics to get an idea of how many times a table is getting hit. Menos
↳
FROM clause WHERE clause GROUP BY clause HAVING clause SELECT clause ORDER BY clause Menos