Re: Help me understand the difference... (Tech question)

2008-05-04 Thread Maureen
I use both extensively and switch between them often without even thinking about which one I'm using until I get a query error - mostly on the things already mentioned like identity or triggers. The basic SQL for queries is very similar. On Fri, May 2, 2008 at 7:19 PM, C. Hatton Humphrey <[EMAIL

Re: Help me understand the difference... (Tech question)

2008-05-04 Thread Greg Morphis
Cool.. I havent used MSSQL (as I said earlier). My company used Oracle 9i currently and are in the process of upgrading to 10g. To each his own, aye? On Sun, May 4, 2008 at 4:38 PM, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > ** Private ** wrote: > > One of the features I absoluetly love about

Re: Help me understand the difference... (Tech question)

2008-05-04 Thread Jochem van Dieten
** Private ** wrote: > One of the features I absoluetly love about Oracle is the over() function.. > If you have a recordset and are trying to get multiple sums of columns > grouped by different columns.. > in MSSQL you'd have to create multiple queries right? MS SQL Server has the standard SQL Wi

Re: Help me understand the difference... (Tech question)

2008-05-03 Thread Greg Morphis
One of the features I absoluetly love about Oracle is the over() function.. If you have a recordset and are trying to get multiple sums of columns grouped by different columns.. in MSSQL you'd have to create multiple queries right? select sum(a, b) from foo group by c select sum(a, c) from foo gro

Re: Help me understand the difference... (Tech question)

2008-05-03 Thread Cameron Childress
They are essentially the same for more of your everyday queries. There are a couple of minor differences (like the TOP keyword), but mostly they are the same syntax-wise. When you get into more advanced stuff (like triggers) they do differ. Also worth noting - CF Standard supports MS SQL out of

Re: Help me understand the difference... (Tech question)

2008-05-03 Thread William Bowen
> 20M+ rows in MSSQL works just fine. Especially in SQL 2005 and SQL 2008. +1 , SQL Server 2005 when properly tuned is great. And proper tuning in 2005 is a lot closer to OOTB than in 2000. -- will "If my life weren't funny, it would just be true; and that would just be unacceptable." - Carr

Re: Help me understand the difference... (Tech question)

2008-05-03 Thread Loathe
See in those instances where we were dealing with huge record sets (DoD and NIH) we used DB2 on zOS, better performance, and these were from legacy mainframe systems. Greg Morphis wrote: > Doesn't work for me.. I wouldnt go to either.. > Yuk! > > I think if you use any DB exclusively, things ju

Re: Help me understand the difference... (Tech question)

2008-05-03 Thread Dana
ooo ooo I know this one! He can type, and is genuinely creative Dana On Fri, May 2, 2008 at 10:00 PM, morchella <[EMAIL PROTECTED]> wrote: > ok adam. > i am calling bs o this one.. > either you can type & are genuanily creative. > or you have paragraphs of analogies you can can copy and paste.

Re: Help me understand the difference... (Tech question)

2008-05-03 Thread Jochem van Dieten
** Private ** wrote: > What is the difference between CF + MSSQL and CF + Oracle? > > Is the query structure for Oracle that much different? If all you do is "SELECT field FROM table WHERE field = value" then the difference is that Oracle is harder to set up but will run on more platforms. http

RE: Help me understand the difference... (Tech question)

2008-05-02 Thread Adam Churvis
gt; Subject: Re: Help me understand the difference... (Tech question) > > Doesn't work for me.. I wouldnt go to either.. > Yuk! > > I think if you use any DB exclusively, things just become easier with > it. > And yeah we have 20+ million row tables.. Oracle work like a

RE: Help me understand the difference... (Tech question)

2008-05-02 Thread Adam Churvis
I just typed it out as I thought of it. Respectfully, Adam Phillip Churvis President Productivity Enhancement > -Original Message- > From: morchella [mailto:[EMAIL PROTECTED] > Sent: Saturday, May 03, 2008 12:00 AM > To: CF-Community > Subject: Re: Help me understand

Re: Help me understand the difference... (Tech question)

2008-05-02 Thread morchella
sry.. its time to go to bed.. i like both dolly & jlow On Sat, May 3, 2008 at 12:00 AM, morchella <[EMAIL PROTECTED]> wrote: > ok adam. > i am calling bs o this one.. > either you can type & are genuanily creative. > or you have paragraphs of analogies you can can copy and paste.. > sure i am wro

Re: Help me understand the difference... (Tech question)

2008-05-02 Thread Greg Morphis
Doesn't work for me.. I wouldnt go to either.. Yuk! I think if you use any DB exclusively, things just become easier with it. And yeah we have 20+ million row tables.. Oracle work like a charm (properly partitioned and indexed of course). On Fri, May 2, 2008 at 10:54 PM, Adam Churvis <[EMAIL PROT

Re: Help me understand the difference... (Tech question)

2008-05-02 Thread morchella
ok adam. i am calling bs o this one.. either you can type & are genuanily creative. or you have paragraphs of analogies you can can copy and paste.. sure i am wrong.. but this just took me 3 minutes to type.. On Fri, May 2, 2008 at 11:54 PM, Adam Churvis < [EMAIL PROTECTED]> wrote: > > Mainly it'

RE: Help me understand the difference... (Tech question)

2008-05-02 Thread Adam Churvis
s [mailto:[EMAIL PROTECTED] > Sent: Friday, May 02, 2008 11:41 PM > To: CF-Community > Subject: Re: Help me understand the difference... (Tech question) > > Difficult? > > Care to elaborate? > > > On Fri, May 2, 2008 at 10:37 PM, Loathe <[EMAIL PROTECTED]> > wrote:

RE: Help me understand the difference... (Tech question)

2008-05-02 Thread Adam Churvis
> Mainly it's just a bigger pain in the ass to use oracle. Amen to that, brother! Oracle is kinda like Jennifer Lopez, and MSSQL is kinda like Dolly Parton. If you're easily amazed, Jennifer Lopez does it for you at first and you feel really privileged to have her perform for you. You get use

Re: Help me understand the difference... (Tech question)

2008-05-02 Thread Loathe
Everything requires more lines of code. I like CF over say PHP, it's easier and quicker to write. I feel the same way about the SQL Server/Oracle debate. Also you have to write code for damned near everything you do with oracle, with SQL Server you can do 95% of it visually. Yes I know that t

Re: Help me understand the difference... (Tech question)

2008-05-02 Thread Greg Morphis
Difficult? Care to elaborate? On Fri, May 2, 2008 at 10:37 PM, Loathe <[EMAIL PROTECTED]> wrote: > God, > > Mainly it's just a bigger pain in the ass to use oracle. > > You have to write all your own sequences and triggers, when in SQL > Server you get identity fields. > > Also the visual tools

RE: Help me understand the difference... (Tech question)

2008-05-02 Thread Adam Churvis
Message- > From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] > Sent: Friday, May 02, 2008 10:20 PM > To: CF-Community > Subject: Help me understand the difference... (Tech question) > > What is the difference between CF + MSSQL and CF + Oracle? > > Is the

Re: Help me understand the difference... (Tech question)

2008-05-02 Thread Loathe
God, Mainly it's just a bigger pain in the ass to use oracle. You have to write all your own sequences and triggers, when in SQL Server you get identity fields. Also the visual tools for SQL Server are just a lot nicer. Theres more than that, major code differences, seems like everything is m

Re: Help me understand the difference... (Tech question)

2008-05-02 Thread Greg Morphis
As an Oracle user.. I don't think there's much difference in standard DB things.. they're both ANSI compliant.. I'm sure MSSQL has some specific features, as does Oracle.. On Fri, May 2, 2008 at 9:35 PM, Zaphod Beeblebrox <[EMAIL PROTECTED]> wrote: > It's been while since I've done it, but there

Re: Help me understand the difference... (Tech question)

2008-05-02 Thread Zaphod Beeblebrox
It's been while since I've done it, but there was a huge difference in how the joins were made in Oracle vs MSSql and the stored procs are very different also. On Fri, May 2, 2008 at 9:19 PM, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > What is the difference between CF + MSSQL and CF + Oracl

Help me understand the difference... (Tech question)

2008-05-02 Thread C. Hatton Humphrey
What is the difference between CF + MSSQL and CF + Oracle? Is the query structure for Oracle that much different? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad