SQL Queries

To do List for SQL Queries

1. Select, From, Where
2. Manipulating result sets: Sql operators,Distinct,Order by,top,output
3. Joins
4. Group by,Roll up, cube,having, Aggregate functions
5. Combining Data sets - union, except, intersect,apply
6. Logical order of query processing
7. Built in Scalar functions
8. Common Table Expressions
9. Sub-queries - Correlated & Non Correlated
10. Dynamic queries
11. Ranking Functions
12. Tuning Queries & Improving Performance
13. Query XML Data
14. Full Text Search
15. Challenges Faced and Solutions

Challenges Faced and Solutions

Use OpenRowset to move data between SQL Servers when you don't have linked Server

http://technet.microsoft.com/en-us/library/ms190312.aspx