I'll be checking TRACE stuff and see if it works.

Thanks.

For now the biggest number I've seen is 56k but I don't think it would reach around a 100k.

The retrieval of data from db and binding of grid will be...

Thanks for sharing your opinion guys. It makes me more firm on my decision 🙂

As what Dan have said, each tool/technology is meant for one specialized function, like for...

Thanks! Point taken, I'll have it listed to prepare for rebuttal 😀

Thanks Grant, I'll take note of that and check it out later.

Thanks!

Thanks for your suggestion.

There is a chance that a recruiter might change the candidate's data, but most of the time other tables related to the

Candidates table are being updated...

Thanks guys for giving me a headstart!

I'll go check replications. Thanks!

Thanks pete you've explain clearly why I was doing the report tables.

Thanks crazyeights for sharing your way of handling tables for reporting.

To my knowledged SQL 2005 will still reject the...

Hi Serg,

But wouldn't it be an additional hit on the transactional tables, especially if the traffic on that table is very high? But I will consider it as an...

BTW, just a note, the limitation still exists in SQL 2005

http://www.sqlservercentral.com/articles/Development/2862/

Anyone there who have done report tables in SQL 2000? How did you denormalized your tables?

I'll be doing some test now. Thanks for the input guys.

Hi Kishore,

That's what actually adding to my confusion, it was showing a warning message but the table is created actually. What does this warning message implies? Would there...

Well I think it make sense now, I should weigh whether which more is more heavily used, insert/update or select?

I guess I should go with indexing, and as for the...

OIC. Thanks for the input.

For the modified fields, those are just high level auditing, I have a separate one that audits in detail.

But what if a single table uses...