Post reply

Do u have some inteligent way of implementing this ???

  • February 16, 2004 at 10:17 am

    #107079

    Hi

    I am having a problem in the database (SQL Server 2000) A table is growing quite rapidly and it has already reached few millions so giving timeouts on sps.This table is about to grow more.

    I was thinking of implementing some thing inteligent dont know what...So that the code accessing this table does  not change and I split the table into few tables and create something (don't know what) so that logicall the code sees the same table but physically i have more than one table thus easy to manage

    Can soem one help me out on this

    Vivek

  • February 17, 2004 at 2:28 pm

    #494435

    Does "View" sounds good to you?  -chris

  • February 18, 2004 at 4:52 pm

    #494609

    Your talking about Partioned Views!

    However, How many million records are there and what is the growth per day?

    Lets analyze this from the ground up before you dive into Partioned Views!

    Kindest Regards,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply