OK i will definitely avoid looping , thanks for your suggestion. One more thing that i wanted to know about is the Count function in T-SQL. I did some...

Hi

I am not sure if I have understand your statement fully here when you mention

"You should make sure that you're doing that as a batch, not as a cursor...

Ok So i am faced with a situation now. User can create missions and others can bid on them. Mission and bids both can be suspended by the administrators. So...

Sorry to bother you again, But can you guide me to the ways through which i could ensure that my scheduled job actually builds the statistics reliably and without getting...

Thanks both of you for your responses. I just want to know your opinion regarding having denormalized tables in such scenario, what is the standard practice in such scenarios, i...

Hi

Thanks for your response. For now i know that they are looking for historical aggregates. If they want to see more data , i will probably convince them to...