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 |
|
SpecApps
Starting Member
3 Posts |
 Posted - 2003-02-26 : 04:40:25
|
| Problem QuerySelect * from ordersSelect * from customersNot hard to work out the two queries but with very complex queries working out that there is two is near impossible. Okay try Show Plan On excute no results gives you the queries but when the select is greater than 3900 characters it returns a broken select statement.Why you may ask, trying to build a better widget than QA. QA has some smarts and uses server side cursors for its result sets which keeps its memory usage down and speed in grid reasonalbe. (try a large query in QA and press Ctrl+A in the grid and watch the memory go through the roof). With OLEDB you can not use multiresultsets with server side cursors. This means for the same query we may run out of memory. We don't want to move to dblib as MS has stated that they won't be supporting it after 2000 and OLEDB through ADO is where they will be moving to.Any help would be greatly appreaciated.Bryan Oliverbryan@specapps.comBryan@specapps.com |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-02-26 : 13:23:23
|
| Aren't you creating stored procedures? I think that would be the most efficient thing to do.Brett8-) |
 |
|
|
SpecApps
Starting Member
3 Posts |
Posted - 2003-02-27 : 07:48:13
|
| Hi,Have foung a solution thanks to the guys at MS on the SQL development team.Bryan@specapps.com |
|
|
|
|
|
|
Getting Seperate Select Statements from a Query