Thank you Jon M , I appricate your quick response.
I am going to use this query on a much larger xml where some customers may have 1, 2 , 3 or more...
Thanks Satya for your reply but I doubt 4 gig is enough for a 2 terabyte db.
I would like to reach out to other companies with a 2 terabyte sql server database. How much ram do you recommend having on the server?
I am looking for some suggestions.We have a very large table.. let' call it custorder table .Most of the reporting queries running against it, are...
No using the report server web interface.
Are you recommending building a custom front end app?
We are an accounting firm and have 50,000+ clients.
I am wondering how are people are handling these problems.
1) One of the parameters is client. We have 50,000 clients so the reports is slow to load...
Sounds like you should create an Application Role
On top of your stored proc do you haveset nocount on
SET TRANSACTION ISOLATION LEVEL read UNCOMMITTED
Separate names with a comma.