I wish to Avoid ...

Hi All,
I am working on Web Application which deals with history data for
reports and keeping track of changes.
Current Solution :
1) For each Entity I am having a column TID (Tracking ID) which
keep on increasing for an instance of Entity. (so history and present
data in the same table) . It makes querying the data difficult.
2) I am also using month year table for Managing data i.e
<TableNameMMYYYY> for a given month and year
Purposed Soluion :
1) Using a seperate table so that history and present data is
placed seperately .
2) Store All data in one table <TableName>
Please guide me on advantages and divantages you pin point in the
two approaches.
With warm regards
JatinderCheck out Partitioned Views in the BOL (or google it).
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"jsfromynr" <jatinder.singh@.clovertechnologies.com> wrote in message
news:1121943363.320745.186330@.o13g2000cwo.googlegroups.com...
Hi All,
I am working on Web Application which deals with history data for
reports and keeping track of changes.
Current Solution :
1) For each Entity I am having a column TID (Tracking ID) which
keep on increasing for an instance of Entity. (so history and present
data in the same table) . It makes querying the data difficult.
2) I am also using month year table for Managing data i.e
<TableNameMMYYYY> for a given month and year
Purposed Soluion :
1) Using a seperate table so that history and present data is
placed seperately .
2) Store All data in one table <TableName>
Please guide me on advantages and divantages you pin point in the
two approaches.
With warm regards
Jatinder|||Thanks for your Time,
I wish to make the solution Portable and Easy to Manage.
With warm regards
Jatinder|||There's really no such thing as portable. Easy to manage is a relative
term, too. Sometimes, you have to go the extra mile for performance.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"jsfromynr" <jatinder.singh@.clovertechnologies.com> wrote in message
news:1121951901.658739.22330@.g47g2000cwa.googlegroups.com...
Thanks for your Time,
I wish to make the solution Portable and Easy to Manage.
With warm regards
Jatinder