SQL Server Performance

Partitioning Issue

Discussion in 'General Developer Questions' started by amitm79, Jan 27, 2005.

  1. amitm79 New Member

    Hi All,
    I am facing a strange issue in horizontal partitioning. If i change the datatype of partitioning key from INT to BIGINT, my queries start hitting all partitions rather then just the required one. If i keep it INT, its works fine. Any ideas/experience of it?

    Regards,
    Amit

Share This Page