Each day learning something New and Interesting

Today, we spent more time upon writing SOL queries. Created Sub queries under that I did :

• Single Row Sub Queries.
• Multi-Row Sub Querries.
• Nested Sub querries And
• Co-related sub queries. I also created Indexes . Indexes is a relational database are mainly use to make the data retrival faster similiar to index available at the end of the book. There are two types of Indexes:

• Clustered Index : Cluster index is the index that will arrange the rows physically in the memory in sorted order.
• Non-Clustered Index : Cluster index is the index that will not arrange the rows physically in the memory in sorted order.

So I created the Index by name DnoIdx on Emp table that I created before and tried both clustered/non clustered creation of Indexes.

In the secod half I tried to analyze and learn C# basics like:

• Static Methods vs Non Static Methods
• Static Constructors vs Non Static Constructors
• Static Classes

It has become the everyday Routine to learn Something new related to SQL Server and C#.Net and implement it practically.Looking forward for more such new topics everyday, so that I can at the end, able to know almost everything about the .Net language concepts(C# and ASP),AJAX and SQL Server far better.