Viewing 15 posts - 56,641 through 56,655 (of 59,067 total)
I still want Brian to tell us what the EXE does and how many rows per call it's going to handle.
April 5, 2007 at 4:24 pm
I'm thinking in the SQL side but could probably also be done on the ASP side. In either case (sorry about the pun), financial calculations should probably not have general...
April 5, 2007 at 4:15 pm
Yep... you're correct... require a particular format. I recommend TAB delimited files so that quotes and commas can be included as part of the data, if the customer desires.
And, I'm...
April 4, 2007 at 10:01 pm
How'z that work Peter... sounds interesting but also sounds like it might be a cursor and I'm thinking I know you better than that... ![]()
[EDIT] Oh...
April 4, 2007 at 9:49 pm
What does the EXE do?
April 4, 2007 at 9:45 pm
Macro that executes on load and reexecutes every 10 seconds should do it ![]()
April 4, 2007 at 9:44 pm
Dinendra,
First, don't even think
cursor... especially not for this size table... ![]()
The following is fully programmable...
April 4, 2007 at 9:38 pm
You need to use some CASE statements, at the very least. Accounting functions are way too important to trust defaults.
April 4, 2007 at 9:05 pm
Even if the perfect indexes were present, it's not likely they'd be used because of the calculations on columns in the WHERE clause... there's even a UDF in there...
"Hopefully this...
April 4, 2007 at 8:51 pm
| You might also want ot learn how to use OSO-11179 naming rules |
Yep... especially when it comes to...
April 4, 2007 at 8:30 pm
No such thing in SQL Server 2000. You can make one with a trigger on each table and a "LastModified" table... just be careful not to make any deadlocks...
April 4, 2007 at 8:12 pm
Some hard disk systems (SAN's, etc) come with clone and snapshot systems that will do this in scant minutes for a half-terabyte database.
April 4, 2007 at 8:09 pm
Um... not sure... but I think you may have missed the point...
What does the "executable" actually do? And for how many rows per call does it do it?
April 4, 2007 at 8:06 pm
Eamon,
Drop the target table (takes indexes with it) and do a SELECT collist INTO tgttable FROM srctable WITH (NOLOCK). Then, reapply your indexes. If it takes more than 10 minutes...
April 4, 2007 at 7:48 pm
Viewing 15 posts - 56,641 through 56,655 (of 59,067 total)