Dot Net Authorities

INDEXPage-SqlTutorial-1: Microsoft SQL Server Training: Free Tutorials and Online-Learning Classes (OLCs)

›
Microsoft SQL Server Training: Free On-line Tutorials And On-line Learning Classes(OLCs) Tutorial-1: Database Development Usi...
84 comments:

SqlTutorial-1 : Lesson-5 : Class-1 : Part-1
Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL
Advanced-SELECTs:
Common Table Expression (CTE) - WITH Statement

›
CTE is named expression that holds result of Sub-select temporarily. The main advantage of CTE is light-weight and recursion; hence i...
2 comments:

SqlTutorial-1 : Lesson-5 : Class-1 : Part-2
Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL
Advanced-SELECTs: Pivot / UnPivot operator

›
Pivot and Unpivot are cross-tabular operators that transform (or rotate) a table column into rows or vice versa respectively. IND...
4 comments:

SqlTutorial-1 : Lesson-5 : Class-2
Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL
Advanced-GROUPING-BY:
COMPUTE, ROLLUP|CUBE, PARTITION, NTILE

›
INDEX N-Tile() Over ( PARTITION-clause)  COMPUTE-BY Statement GROUP BY with CUBE | R...
16 comments:

SqlTutorial-1 : Lesson-9 : Class-2
Microsoft SQL Server Training:
Free Online-Learning Classes (OLC) for T-SQL
Sql-INDEX Operations:
Creation, Altration, Deletion and Optimization

›
Index is a performance optimization technique that speeds up the data retrieval process. It is a persistent data structure (Key-Point...
346 comments:
›
Home
View web version

About Me

dotnetauthorities
View my complete profile
Powered by Blogger.