Viewing 15 posts - 53,776 through 53,790 (of 59,068 total)
but when you're dealing in hundreds of millions of records with finite resources you have to delete it sometime.....and when the garbage man comes around to remove the records flagged...
December 1, 2007 at 5:16 pm
Hmmm... and what do you do for sprocs that are used by multiple applications?
December 1, 2007 at 4:04 pm
I can find a lot of stored procedures that are available
"Steal" code from those...
December 1, 2007 at 9:30 am
And, I'm not so sure about the need for the cross join... but I'm on my way out for the day...
December 1, 2007 at 9:27 am
Oracle is very picky about the reuse of table aliases within a given query... try this...
SELECTP.patno, P.name, P.docno, P.docname, P.specialization, COALESCE( T.NoOfTreatments, 0 ) AS NoOfTreatments
FROM(
SELECTPa.patno, Pa.name, D.docno, D.docname,...
December 1, 2007 at 9:22 am
Heh... "A Developer must not guess... a Developer must KNOW"...
... especially in a political environment where you are challenging incumbent "knowledge".
One of the most difficult things you can do is...
December 1, 2007 at 9:06 am
Try this instead...
--DROP TABLE dbo.FirstName,dbo.LastName
--===== Create a couple of test tables
CREATE TABLE dbo.FirstName
(
...
November 30, 2007 at 8:01 pm
Just a suggestion...
If you regularly load large amounts of data using BCP or Bulk Insert, consider making a "staging area" database. Because all data in a staging area should...
November 30, 2007 at 7:36 pm
Ummmm... OK... Guess I don't understand... why are you keeping any rows for a long period of time in a "staging area"... all of that data should be expendable to...
November 30, 2007 at 3:35 pm
Or... you could kick off the proc and do a WAITFOR DELAY 'hh:mm:ss'.
Of course, if the server get's taken down or the job ever fails, you need to manually restart...
November 30, 2007 at 2:59 pm
Also - your test has a flaw in it, since you start by trying to cram 4 digits after the decimal point into 2 digits after the dot. So you...
November 30, 2007 at 2:55 pm
Heh... You do DELETEs? In a "staging area"? I'd just mark the rows with a flag of some sort and tell my procs to ignore those rows.
November 30, 2007 at 2:26 pm
Heh... at that point... I'd be thinking "BEER"! 😀
November 30, 2007 at 2:22 pm
Even if it's "auto-generated" code, someone someday is going to have to troubleshoot it... take some time out to format it! And, the use of table aliases would clear...
November 30, 2007 at 2:15 pm
Viewing 15 posts - 53,776 through 53,790 (of 59,068 total)