Vipul Shah's SQL Blogs

SQL Server Blogs

February, 2007

  • Table Partitioning in SQL 2005

    This feature of SQL Server 2005 is one of the provided Solutions for Large Tables in SQL by Microsoft. Lots of help will be available in SQL Books Online Shipped with SQL 2005 on concepts and implementation. The best part of this feature is that you can...
  • 64-bit - Query performance

    There are clearly a lots of advantages on going to 64-bit. Read my previous blog on advantages of 64-bit SQL Server 2005. There were few cases where they found out that the query performance was bit slower in 64-bit vs. 32-bit, but that depends on type...