Viewing 15 posts - 136 through 150 (of 595 total)
quote:
I have been delving heavily into VB.NET myself as a way to get away from Access, b/c of its 'issues' - like...
July 31, 2003 at 8:57 am
quote:
Hmm, I've never seen an Insert statement like that...would someone enlighten me as to why you would need a Group By /...
July 31, 2003 at 7:49 am
There are a couple suggestions that would improve the speed of the procedure you posted; however I don't know how the dirty reads are happening until I see the code...
July 31, 2003 at 7:45 am
1) What isolation level is the transaction set?
2) Are you using SELECT ... INTO or INSERT INTO?
3) Have you done an analysis of the locking scheme that...
July 30, 2003 at 2:31 pm
hbkdba, Great news! Give us an update when you do a performance comparison on the cursor...
Jeremy,
I have a feeling those UDFs might be the culprit, like NPeeters mentioned. ...
July 30, 2003 at 12:32 pm
82 seconds is still a really long time for a simple query. Regardless, what is the ADO code you are executing? There are 2 timeouts (I know, it's...
July 30, 2003 at 11:25 am
Not quite sure why you couldn't handle most of this in the ASP and not in T-SQL cursor. Could you post the schema and an example of update/insert/delete based...
July 30, 2003 at 10:12 am
1) Have you run the code in Query Analyzer and seen any difference?
2) If you have, look at the execution plan and see where the most processing time is being...
July 30, 2003 at 10:08 am
Not sure. You may want to post this on an ASP forum.
July 30, 2003 at 10:04 am
Don't use a cursor. Use a SET-based solution. Post the schema of the table and an explanation as to what you would like to update.
July 30, 2003 at 9:21 am
Are you including adovbs.inc? If not, you need to replace the ad-prefix Constants with the numbers they represent.
July 30, 2003 at 9:20 am
quote:
how about...Group by Convert(char, your_date_field, 101)
This does an extra lookup in syslanguages to find the...
July 30, 2003 at 9:12 am
Jeremy,
There may be some things in your SQL that we could look at that might speed things up. But aside from that, speed is not the...
July 30, 2003 at 7:00 am
quote:
The WHERE clause can be rewritten as:...
WHERE CHECKSUM(o.data1,o.Data2,o.Data3)<>CHECKSUM(t.data1,t.Data2,t.Data3)
The CHECKSUM creates a CRC value.
Nice. Very...
July 30, 2003 at 6:52 am
quote:
I thought it wasDATEADD(d,DATEDIFF(d,0,dtCol),0)
makes no difference. DateAdd has the following prototype:
July 30, 2003 at 6:40 am
Viewing 15 posts - 136 through 150 (of 595 total)