SQL Server 2008 Implementing Sliding Window partitioning scenario on a table with a clustered primary key RRS feed

  • Question

  • Hello,
    In our company we have the following scenario
    table MRegistration (which stands for Machine Registration) we track the values of sensors(registers) on various machines in the factories.
    The table looks as followed:
    MachineId (PK, int) not null
    MachineRegisterId (PK,int)not null
    UtcTime (PK,datetime)not null
    Value (float)null

    The primary key is clustered on MachineId,MachineRegisterId and UtcTime, since the combination of these 3 will always form a unique set.

    We want to implement a sliding window based on UtcTime on a monthly basis. I followed some tutorials and blog posts but have been unable to implement this on our database.(I'm getting errors that range from indexes to constraint that are not partitioned to just saying that the table I want to switch out isn't partitioned)

    Can anyone help me

    Wednesday, November 10, 2010 2:50 PM