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
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 [...]
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?