Posted by Erland Sommarskog on 07/23/05 00:50

Zero.NULL (manish19@gmail.com) writes:
> I would really like appreciate that you have got my problem clearly and
> want to be thankful that you tried to point the would be solution of
> this issue,
> however I should say here that the rules applied on "Partitioned Views"
> would trouble even more as there are situation and logic is developed
> accordingly where the data grows unlimitedly in a single table, whereas
> primary key column in partitioned tables require prefixed range set.

Huh? Could you clarify what you mean?

Since you create YYYYMM tables every now and then, you would have to
recreate the view every you do this, but that's not a big deal.

In your original post you said:

> We capture the details of a certain action in table
> "TransDtls<CurrMonth><CurrYear>" (this month: TransDtls072005).
> This way tables keep growing. every month a new table gets created. We
> have done it because we estimated that every month year table will
> carry around 2 - 3 Lac records and most of the time the operations will
> work on current month year table.

"Lac" is a unit that is unknown to me. Could you explain?



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]