Hi Guys,

The post got many view and no replies, is the issue description not clear or what?.

If not clear please let me know to rephrase it.

Thanks Nader

Hi Guys,

I tried getting the different types of warnings or errors available in SQL server to use them in same SQL Robert posted to detect any other problems.

I couldn't find...

Thank you very much.

Dear Jack,

While testing with different values , i notice the number of record sets coming is different so after debugging i found out that in come cases the result is...

Hi Jack,

I have changed the stored procedure(GetCommonItemCount) that i call from within the main stored procedure(CheckBoxAvailability).

Now when i call CheckBoxAvailability as follows

exec CheckBoxAvailability 119,59,0,1

sometimes i get result as one record...

Dear Jack,

Thank you very much , i appreciate your help, it worked finally.

I will continue testing the data and let you know result.

Best Regards

Nader

Hi Jack,

Thanks for your reply, your guess is right.

Please tell me how to use the example you wrote

Exec GetCommonItemCount @cnt = @cnt Output

Do you mean i should define an additional...

Dear All,

Thanks you very much for your replies.

I have reattached the files and attached script to fill data as well.

I will try what you have mentioned and let you know...

Thanks George Sibbald,

I have a question please, i see here you are getting the most expensive stored procedures based on I/O but what i wanted to know is which queries...

What if i need to get the query not the object as many queries could be using the same object, anyway to do that?.

Thanks

Hi Jeff,

Thanks for the detailed explanation , i will have to examine that thoroughly.

But based on that solution, doing the partitioning online directly on original table will cause a bad...

Dear Jack,

Thanks again for your valuable information, i will try it and let you know.

Regards

Nader

Dear Jack,

Thanks fro your reply, what i understand from your reply is that it has an impact but not that serious, is that right?., specially for tables with large number...

Dear Abu Dina and GilaMonster thanks very much for you replies

Thanks for you reply