As I mentioned earlier I was traveling this week to four major cities of South Gujarat SQLAuthority Author Visit - Valsad, Daman, Silvassa, Vapi - Tech Meetings . I had tech meetings in each city. I was fortunate to meet IT head of different large organizations. My travel itinerary is as following: ...

I have listed few important links of SQLAuthority.com, I still receive some repeated questions. I do my best to respond to all of my readers, however, most of the time I am sending them link to one of my previously written article. Many times most of the answers can be found right away by searching ...

I have received call from my DBA friend who read my article SQL SERVER - 2005 - Introduction to Partitioning . He suggested that I should write simple tutorial about how to horizontal partition database table. Here is simple tutorial which explains how a table can be partitioned. Please read my arti...

Partitioning is the database process or method where very large tables and indexes are divided in multiple smaller and manageable parts. SQL Server 2005 allows to partition tables using defined ranges and also provides management features and tools to keep partition tables in optimal performance. Ta...