Cost of ownership and cost of both development DBAs (which I am) and
production DBAs is a lot lower with SQL Server than Oracle. Oracle
DBAs tend to specialize in certain things about the role. Because
of the size and complexity of it, it is pretty much impossible to
do everything in it well as a DBA. All of the Oracle "development"
DBAs that I have dealt with have been very competent with writing SQL
statements, again I think it is the specialization thing.
The change done to DTS to make it SSIS was generally to put it into
competition with Informatica. For those of you that have not seen it,
it is a lot like the SSIS interface. SSIS is also much more powerful
than DTS ever was.
Also, if you write the T-SQL correctly, it can be extremely versatile
for the GUI/Business layer programmer to use. For example, the update
can be written so that not all the fields need to be passed in, but
the ones that are passed in will be updated.
For example:
UPDATE dbo.tbl_HSE_Causes
SET [HSEC_HAZOP_ID] = CASE WHEN @HSEC_HAZOP_ID IS NULL THEN [HSEC_HAZOP_ID]
ELSE @HSEC_HAZOP_ID
END,
[HSEC_No] = CASE WHEN @HSEC_No IS NULL THEN [HSEC_No]
ELSE @HSEC_No
END,
[HSEC_Project_ID] = CASE WHEN @HSEC_Project_ID IS NULL THEN
[HSEC_Project_ID]
ELSE @HSEC_Project_ID
END,
[HSEC_Description] = CASE WHEN @HSEC_Description IS NULL THEN
[HSEC_Description]
ELSE @HSEC_Description
END
WHERE HSEC_ID = @HSEC_ID
All of the parameters are optional except the HSEC_ID in the example.
I would be interested in reading that article. It seems that they should be
optimizing the dynamic stuff more because of LINQ. So maybe they have in 2008.
But, I do not know many people that are using it yet. SPs definitely
faster in 2000 and 2005 that dynamic.
At 02:32 AM 12/17/2008, you wrote:
>Date: Tues, Dec 16 2008 7:24 pm
>From: "Aaron Rouse"
>
>
>Yeah just a shame that the price tag on Oracle and CF Enterprise(if you want
>out of the box datadirect drivers) is rather steep for some. We are being
>pushed slowly towards SQL Server because MS gave a bunch of licenses for it
>and makes the cost of Oracle all the sudden seem like a huge waste of money
>to the higher ups. Have to love MS's approach, make the first uses free
>then once they are sunk in charge them a lot.
Robert Stewart
ProjecTools.com
713-371-9840 X1305
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the "Houston ColdFusion
Users' Group" discussion list.
To unsubscribe, send email to [email protected]
For more options, visit http://groups.google.com/group/houcfug?hl=en
-~----------~----~----~----~------~----~------~--~---
