Viewing 15 posts - 4,156 through 4,170 (of 6,036 total)
Just populate your table with 500k dummy orders having 5 lines per order (quite typical number for 3-4 years old systems) and try to perform 1st option.
Decide for yourself if...
June 5, 2007 at 4:46 pm
Posting the query would be useful.
But general suggestion - apply COLLATE inside equation:
WHERE SomeCal COLLATE ... = AnotherVal COLLATE ...
June 5, 2007 at 2:34 pm
SELECT LEFT(@Var, @Position -1) + '?' + SUBSTRING(@Var, @Position + 1, LEN(@Var) - @Position)
June 5, 2007 at 2:07 pm
If you perform such insert using INSTEAD IF trigger on a view it will become auto transaction.
Anything fails inside of transaction - and everything rolls back. Whole insert.
No need to...
June 5, 2007 at 2:01 pm
Set a clustered index on the column(s) mentioned in ORDER BY.
June 5, 2007 at 1:48 pm
David, you did not answer the question:
When the even suppise to happen to be named by you "midnight event"?
Exectly at midnight?
Not 1s later?
Not 1 ms later?
Not 1 mcs later?
What if...
June 5, 2007 at 1:44 pm
> Database is usually the bottleneck right? [Wink]
Not really. Only if it's designed badly.
In my last project test with 400 users simultaneously accessing database revealed that internet traffic was a...
June 5, 2007 at 6:10 am
David, there was a question buried in tons of spam:
What would you name a "midnight event"?
What does it mean for you: this happened at 00:00?
June 5, 2007 at 5:48 am
100 replies.
Whoo-hoo!
And if to consider that this topic was started as an extension to another one, also quite long...
June 4, 2007 at 11:41 pm
And I don't what your B.S. degree is worth but you perception of business practices is just wrong.
In tax reports if intermediate results must be included in report
TotalTax should...
June 4, 2007 at 10:56 pm
They have at least something in common:
- they based on wrong assumptions;
- they were proven by some people (by you in case of BR) using big names of big authorities....
June 4, 2007 at 10:39 pm
> Sorry, it worked,
Sorry, it did not work.
Everyone can see it.
> was approved by the accountants, and the auditors, and for this company is a part of their business...
June 4, 2007 at 9:56 pm
"Once again you manage bring up something that has nothing to do with the subject at hand."
Or now you're trying to prove that Bankers Rounding is invalid?
Don't bother, I know...
June 4, 2007 at 9:26 pm
> ... IBM, IEEE, Microsoft, about every signal processor manufacturer in the world, the PLC manufacturing industry, and just about anyone else who matters.
Once again you manage bring up...
June 4, 2007 at 8:56 pm
Once again, for really "smart" people with big diplomas:
I ready to admit anything you can prove.
As soon as you cannot prove validity of Bankers Rounding there is nothing to admit...
June 4, 2007 at 8:35 pm
Viewing 15 posts - 4,156 through 4,170 (of 6,036 total)