Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Advantage of Adaptive Server over MS SQL Server?

3 posts in Windows NT Last posting was on 2000-09-19 13:47:21.0Z
Mathew Chacko Posted on 2000-09-18 14:47:05.0Z
Message-ID: <39C62AE9.27AE929C@hotmail.com>
Date: Mon, 18 Sep 2000 16:47:05 +0200
From: Mathew Chacko <mathew_chacko@hotmail.com>
Organization: Datamatics Ltd.
X-Mailer: Mozilla 4.75 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Advantage of Adaptive Server over MS SQL Server?
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 4
NNTP-Posting-Host: polaris.unicc.org 192.91.247.212
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1630
Article PK: 1089106

I am interested in advantage of Adaptive Server Enterprise over MS SQL
Server.
Need help.

Thanks & regards,

Mathew.


Peter Veilleux Posted on 2000-09-18 15:35:47.0Z
Message-ID: <39C63653.F25467A1@nvestservices.com>
Date: Mon, 18 Sep 2000 11:35:47 -0400
From: Peter Veilleux <pveilleux@nvestservices.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Advantage of Adaptive Server over MS SQL Server?
References: <39C62AE9.27AE929C@hotmail.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 52
NNTP-Posting-Host: 206.136.227.189
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1629
Article PK: 1089103

well, IMHO, here a few things I like better about Sybase than Microsoft:

1. MSSQL restarts their INDENTITY columns at 1 if you truncate the table.
Sybase picks up where it left off.

2. I find MSSQL showplan output tedious to read. Sybase's is much easier
on the eyes.

3. No aliases in MSSQL. I haven't read too much about it, but we had a
hell of a time trying to do the equivalent of aliasing someone to dbo.
Had to modify a script Siebel provided for us as part of their
installation.

4. Devices v. files. MSSQL did away with devices and just uses o/s
files. Some might argue this is good, but some people like to have the
control you get with segments. This is a toss-up.

5. MSSQL doesn't run on UNIX. Depending on your environment, you might be
better off on NT, but I'm a big fan of running database servers on UNIX.

6. MSSQL will not allow you to load an old copy of the database. In a
nutshell, if you have a 6.5 database, and want to go to 7.0, you cannot
install 7.0, we'll say on a new box, take a dump of 6.5 and load it into
7.0. You must upgrade the 6.5 server with the databases already in
place. I'm sure there are some tricks to this (I've tried the MSSQL
Switch program), but out of the box and by the book, you're out of luck.

7. Sybase support over MS support, in a heartbeat. Granted, I'm biased,
but I had a MS tech (who actually was very helpful) tell me I couldn't
call him during certain hours because he was not allowed to take calls,
even if they were work related. He had to sit on the phone queue and do
nothing but take new calls. I have my opinions about how TS should work,
and that doesn't quite fit in.

I wish I had more for you, but I try to avoid digging too deep into
MSSQL7.0. It will just frustrate me even more at the control they have
taken away from the users.

Good luck....

Pete

Mathew Chacko wrote:

> I am interested in advantage of Adaptive Server Enterprise over MS SQL
> Server.
> Need help.
>
> Thanks & regards,
>
> Mathew.


Peter Veilleux Posted on 2000-09-19 13:47:21.0Z
Message-ID: <39C76E69.F1FDCD06@nvestservices.com>
Date: Tue, 19 Sep 2000 09:47:21 -0400
From: Peter Veilleux <pveilleux@nvestservices.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Advantage of Adaptive Server over MS SQL Server?
References: <39C62AE9.27AE929C@hotmail.com> <39C63653.F25467A1@nvestservices.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 65
NNTP-Posting-Host: 206.136.227.189
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1622
Article PK: 1089096

one more pet peeve of MSSQL:

sort orders - cannot change them and run a reindex like you can on Sybase.
With MSSQL, once you install with a certain sort order, you're locked in. And
that brings up the dilemma, what if you need to load a db from a server of a
different sort order? You're reduced to doing a logical dump and load.

Dealing with this one right now, so I thought I would mention it.....

Pete

Peter Veilleux wrote:

> well, IMHO, here a few things I like better about Sybase than Microsoft:
>
> 1. MSSQL restarts their INDENTITY columns at 1 if you truncate the table.
> Sybase picks up where it left off.
>
> 2. I find MSSQL showplan output tedious to read. Sybase's is much easier
> on the eyes.
>
> 3. No aliases in MSSQL. I haven't read too much about it, but we had a
> hell of a time trying to do the equivalent of aliasing someone to dbo.
> Had to modify a script Siebel provided for us as part of their
> installation.
>
> 4. Devices v. files. MSSQL did away with devices and just uses o/s
> files. Some might argue this is good, but some people like to have the
> control you get with segments. This is a toss-up.
>
> 5. MSSQL doesn't run on UNIX. Depending on your environment, you might be
> better off on NT, but I'm a big fan of running database servers on UNIX.
>
> 6. MSSQL will not allow you to load an old copy of the database. In a
> nutshell, if you have a 6.5 database, and want to go to 7.0, you cannot
> install 7.0, we'll say on a new box, take a dump of 6.5 and load it into
> 7.0. You must upgrade the 6.5 server with the databases already in
> place. I'm sure there are some tricks to this (I've tried the MSSQL
> Switch program), but out of the box and by the book, you're out of luck.
>
> 7. Sybase support over MS support, in a heartbeat. Granted, I'm biased,
> but I had a MS tech (who actually was very helpful) tell me I couldn't
> call him during certain hours because he was not allowed to take calls,
> even if they were work related. He had to sit on the phone queue and do
> nothing but take new calls. I have my opinions about how TS should work,
> and that doesn't quite fit in.
>
> I wish I had more for you, but I try to avoid digging too deep into
> MSSQL7.0. It will just frustrate me even more at the control they have
> taken away from the users.
>
> Good luck....
>
> Pete
>
> Mathew Chacko wrote:
>
> > I am interested in advantage of Adaptive Server Enterprise over MS SQL
> > Server.
> > Need help.
> >
> > Thanks & regards,
> >
> > Mathew.