Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-11 : 08:13:24
|
| ann writes "i'm having a problem with memory. I have an SQL database and an accounts application - basic day to day work is a point of sale system where users enter in sales - i have stored procedures which read the stock code and price then create an invoice and print it - simple queries. in the back office, i have enquiries which show total sales for the day, week, month, year. if a user queries sales for a year, the stored procedure that returns this dataset (which can contain all sales lines for the year - could be over 500,000 lines) - when i run this query it stalls everything else. what i want to do is to give this query low priorty (the user in the back office can wait for this query to run) and the simple queries (if a user has a customer waiting to buy an item at a counter, they can't wait for the back office query to finish) the higher priorities. can you do this?hope this makes senseann." |
|
|
|
|
|
Prioritise Queries