Viewing 15 posts - 781 through 795 (of 5,504 total)
Use a calendar table and a LEFT JOIN to your order table.
December 17, 2011 at 8:30 am
Dev (12/17/2011)
December 17, 2011 at 5:10 am
There are multiple possible reasons for the slow performance.
Here are a few I can think of:
Network issues (e.g. due to a large size of the result set), blocking due to...
December 17, 2011 at 3:50 am
Stefan Krzywicki (12/16/2011)
L' Eomot Inversé (12/16/2011)
Stefan Krzywicki (12/16/2011)
SAP = BlechSAP = a lot worse than just Blech
In addition to many of the faults I already knew about, it is SO...
December 17, 2011 at 3:07 am
What exactly is your question?
We don't know anything about the company you're working for nor the extent you're using BI at the moment nor anything about the business plan of...
December 16, 2011 at 3:20 pm
Brent Seeney-273128 (12/14/2011)
<Party>
<CustomerID Role="SENDER">1122334455</CustomerID>
<Name>SomeOne</Name>
...
December 15, 2011 at 2:52 am
You might want to have a look at my question on a similar thread.
It's not as much focused on the location of the file itself but more on the SAN...
December 14, 2011 at 12:33 pm
vkr.karthick (12/13/2011)
yes, we have a erp product that should be installed in standard edition. now it is in testing stage so we required trial edition.
Whoever sells you that product should...
December 13, 2011 at 1:01 pm
Dev (12/13/2011)
...‘Tools with Technician’ and ‘Weapons without soldier’, aren’t you suggesting the same? :w00t:
Not sure about the latter, but definitely the former 😀
December 13, 2011 at 5:40 am
Like I stated before:
There are tools available claiming to be able to convert in that direction (SQL Server to Oracle).
A google search should help.
Will those tools help you to...
December 13, 2011 at 5:08 am
If you really want to go down that route, you'll need to verify the T-SQL code can actually be migrated into Oracle (will be "fun stuff" if you're using Service...
December 13, 2011 at 3:24 am
We'd need to see the function itself together with DDL of all tables involved to make any suggestion. It sounds like a scalar function anyway. So, the next question would...
December 13, 2011 at 1:10 am
Evil Kraig F (12/12/2011)
Nah, he used the front portion of the crown. It's about the hardest portion of your body, he's fine. I've done that a few times...
December 12, 2011 at 4:48 pm
The major difference in this scenario is the missing statistic information. If you look at the actual execution plan, you'll se a big difference between estimated number of rows (=1...
December 12, 2011 at 4:29 pm
Evil Kraig F (12/9/2011)
LutzM (12/9/2011)
Wouldn't the UNPIVOT approach be a little easier?
:blush: Yes.
Pardon me, I need to find a mirror. I know someone who deserves a facepalm and...
December 9, 2011 at 3:36 pm
Viewing 15 posts - 781 through 795 (of 5,504 total)