Vikas
Can you post the text of the query?
Basic Pointers
1/ Add indexes for ther foreign keys (these can allow duplicates)
2/ Restrict the result set (I assume you dont want the query to return
10 million rows)
3/ use ansi join syntax
N
Hi
I have an query related to an sql sever 200o
I think there is *one* more person down there :-)
Do you have facilities I could use? :-)
Richard
Richard Vowles, Technical Advisor
Developers Inc Ltd
web. http://www.developers-inc.co.nz
ph. +64-9-3600231, mob. +64-275-467747, fax. +64-9-3600384
skype. rvowles, LinkedIn, Twitter
need me to do
Hi Leigh, any number I put out there would simply be a guess - we come
across people regularly who use earlier versions of Delphi who simply won't
upgrade.
Richard Vowles, Technical Advisor
Developers Inc Ltd
web. http://www.developers-inc.co.nz
ph. +64-9-3600231, mob. +64-275-467747, fax.
Developers not upgrading...
I suppose that is one of the core Codegear problems.I have been working
at a firm with production software in Delphi 5 Enterprise - there has been
no real need to upgrade, as it does most of what they need. The main
reluctance about upgrading are simply the
Get a release out with full Unicode support and generics and we'll upgrade
from Delphi 5...
Of course it better be darn stable and have useful help ;-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of John Bird
Sent: Thursday, 8 May 2008 11:12 p.m.
To:
John == John Bird [EMAIL PROTECTED] writes:
John If there was an easy way to even just test compiling and
John running the existing code on a later version, I bet it would
John be much easier for clients like this to upgrade...
Just buying an upgrade version isn't too expensive is
I think there is *one* more person down there :-)
Hmm. So we could have user group meetings over coffee.
Do you have facilities I could use? :-)
Certainly! :-) Data projector, big video conf TV, etc in our meeting
room but sounds like overkill for the size of the audience.
--
Phil
I think this is in general a sql server question. sql 2000 has a sql
enterprise manager/ studio which I can analyze sql query plan which you may
check which index you are using.
The step what I do is debug a normal sql query in sql query analyzer, once I
am happy, then I will put the code in
I've noticed this one also and it's generally quite annoying because it
requires a couple of extra mouse clicks once you know it's happening.
The other one that bothers me a little is the TTable and TQuery glyphs
are missing on the components quite frequently - I guess it makes it
obvious
Developers not upgrading...
Well I bought D2 Enterprise. When upgrade time around I found not only
was upgrade around 80% of purchase price, but so many of the
enterprise bits were completely different. Ie Borland just provided a
different set of 3rd party components so application
Thankfully D2007 does not have these issues - and it is much faster.
Have you installed Andreas Hauslanden DelphiSpeedup Package? Well worth
it.
http://andy.jgknet.de/dspeedup
The only issues experienced on D2006 IDE exit were ones from 3rd party
components and our own - which are now fixed.
Get a release out with full Unicode support and generics and
we'll upgrade from Delphi 5...
Of course it better be darn stable and have useful help ;-)
Yeah. What he said.
Admittedly are somewhat less recalcitrant - we are on BDS 2006 as the
IDE improvements were worth it.
Blaming the
The only issues experienced on D2006 IDE exit were ones from 3rd party
components and our own - which are now fixed.
If D2007 fixes these, then I am interested in upgrading but could find
anything which suggested it did. I have used DSpeedup.
While crashes might be due to 3rd party
Yeah, D2006 had some serious leaks, and most of those are also fixed in
D2007 with the latest patches. A couple of small ones still remain, I
suspect, but not enough to worry about anymore.
You can of course download the D2007 trial and install it free for 30
days! It's a full working version, so
Do you have any tips/pointers on tracking down this shutdown issues? I
agree that it's most likely our own components that are causing these
errors for me; just wondered if you have any general suggestions about
solving them.
Yes. If its not memory leaks then what other sin does a
Hi Phil, I have found the Delphi 2007 IDE (win32 only) to be an
improvement over D2006 for reliability, however still some glitches. It
seems however if you can hold out for Tiburon released later this year
you will get your Unicode support as well. Personally I'll be looking
for a sign that
To be honest, I had been hoping for something more helpful.
Because it's not immediately obvious to me how to go about tracking down
a memory leak in any one of a few dozen components on IDE shutdown
without just eyeballing the code, which I would think would take a
prohibitive amount of time,
I have used Delphi to debug Delphi. The issue is normally around
component editors, component destruction orders, message notifications
on destruction, unit finalization code etc. Mostly a lot of nil pointer
stuff.
Myles.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL
18 matches
Mail list logo