Monthly Archives: January 2010

Database Normalization

Posted on January 26, 2010 by vivekjohari

Database Normalization Normalization Database Normalization can be defined as the process of organization the data to reduce the redundant table data to the minimum. This process is carried out by dividing the database into two or more than two tables … Continue reading →

Posted in SQL Normalization, SQL Server | Tagged , | 24 Comments

Indexes in Sql server

Posted on January 3, 2010 by vivekjohari

Indexes-Indexing  is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the table.It can be compared with the index which we use in the book to search a … Continue reading →

Posted in Most Imp SQL Concepts, SQL Indexes, SQL Server | Tagged , | 25 Comments

Difference between Clustered Index and Non clustered Index

Posted on January 3, 2010 by vivekjohari

Indexes-Indexing  is way to sort and search records in the table. It will improve the speed of locating and retrieval of records from the table.It can be compared with the index which we use in the book to search a … Continue reading →

Posted in Imp SQL Difference, Interview Questions, SQL Indexes, SQL Server | Tagged , , | 31 Comments

Sql Joins- Inner Joins, Self Joins, Outer Joins, Cross Joins

Posted on January 2, 2010 by vivekjohari

I generally feel that people are afraid of Joins in SQL Server. But if they know what the different types of Joins in SQL Server are and how they can be best used then they really enjoy using them. By … Continue reading →

Posted in Most Imp SQL Concepts, SQL Joins, SQL Server | Tagged , , | 33 Comments