Database Optimization TIPS helps any system to perform work efficiently and quickly. SQL Server Performance tuning is very wide subject and there are a lot of different pieces to troubleshoot a poor performing application. Connectivity / Network Server Hardware Operating System SQL Server Database Query The basic principle of Optimization / Tuning is Profile First [...]
Category Archives: Index
Indexes on SQL Server 2008
Posted by Mahesh Gupta on July 25, 2011
0 comments
This topic, will let you know the very basic knowledge of Indexes in SQL server 2008. Lets begin.. and this small blog can be very useful to your SQL knowledge: There are 8 types of SQL Server indexes in 2008: a) Clustered b) Non Clustered c) Unique d) indexes with included column e) Full Text [...]
Introduction to Indexes in SQL Server – Beginner
Posted by Mahesh Gupta on April 27, 2011
0 comments
We all understands that Indexes helps SQL Server to retrieve the data. Let’s a brief introduction to SQL Server Indexes. This Video Tutorial is going to help us in understanding The fundamentals and purpose of indexes What are data pages? What if a table has no indexes?
