T-SQL/MSBI Knowledge Share

Please feel free to send your questions/suggestions/comments on T-SQL/MSBI to following mail Id : tsql.knowledge.gallery@gmail.com

T-SQL/MSBI Knowledge Share Videos

T-SQL/MSBI Knowledge Share Videos : http://www.youtube.com/results?search_query=T+SQL/MSBI+Knowledge+Share+Videos

Tricky Join Examples

In the below example you see that all types of joins give the same result as cross join.

No comments:

Subscribe to: Posts (Atom)

Author

Sreehari Katageri

View my complete profile

Data Warehouse Topics

Understanding Data Warehouse
Basic Data Warehouse Concepts
Types of Dimensions

T-SQL Topics

Database Overview
Key Constraints
Normalization
Joins & SELECT Sequence
Examples on T-SQL Joins
Tricky Join Examples
Truncate and Delete
Group By/Distinct/Count
Incremental loads and updates
Delete duplicate records
Temp table,Table variable,CTE
Sub Query
Basic Ranking function
Indexed Views
Clustered/Non-Clustered Index (Key Lookup/ Book Mark Lookup and RID Lookup)
T-SQL Miscellaneous 1
T-SQL Miscellaneous 2
T- SQL Miscellaneous 3
T-SQL Miscellaneous 4
T-SQL Miscellaneous 5
Maximum value from the multiple columns
Table Valued Parameter (TVP)
Row level security implementation
TSQL/MSBI Youtube Links
Resume Format
SQL Reference link

Some important SQL/MSBI links and articles

MSBI Knowledge Share
Important SQL/MSBI links

Total Blog views

Followers

Google Search

Powered by Blogger.