Re: Newbie: feature comparison

From: Jacco Schalkwijk (NOSPAMjaccos_at_eurostop.co.uk)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 15:36:08 -0000

Well, SQL Server is not alone. DB2 also doesn't support Multi Version
Concurrency Control, as it is sometimes also called. You can find a
whitepaper here that explains why they don't:
http://www.ibm.com/software/data/pubs/papers/readconsistency/readconsistency.pdf

I had a quick look at the document but I can't be bothered to address all
the points really. One area I'd like to comment on though, and that is the
emphasis Borland put on the triggers they support.. For example:
"The ideal solution is to add a Before Insert trigger to the Customer table
which adds the sales territory and sales rep codes to the record before it
is inserted. "

Triggers are usually _not_ the ideal solution in any situation, and why you
shouldn't use a stored procedure here I don't see. Doesn't IB support stored
procedures? 

-- 
Jacco Schalkwijk
SQL Server MVP
"news.cyberia.net.lb" <softnet@cyberia.net.lb> wrote in message
news:103jlgseego1tfa@corp.supernews.com...
> Hi to all,
>
> I am presently using Borland Interbase and am considering switching to SQL
> Server 2000. I have read the document
> http://www.borland.com/products/white_papers/pdf/ib_vs_SQLServer.pdf and
got
> and was amazed to know that SQL server uses pessimistic locking. I must be
> missing something. I am aware of numerous features of SQL Server that are
> not mentioned in this document. Can anyone take a look at it (21 pages
only)
> and try to clarify some of the "defficiencies" mentioned?
>
> Thanks
>
> Salim
>
>

Relevant Pages

  • RE: Non initialized Cmd Parameter Collection via ASP vs SQL Server 200
    ... component to access database and execute some stored procedure. ... error when change the database from SQL server 2000 to SQL Server 2005, ... Microsoft MSDN Online Support Lead ... Delighting our customers is our #1 priority. ...
    (microsoft.public.data.ado)
  • RE: Visual Basic 2005.Net TableAdapters
    ... TableAdapter doesn't work in the same manner as a SQL Server Stored ... A stored procedure consists of several SQL statements and compiled on the ... Microsoft Online Community Support ...
    (microsoft.public.dotnet.languages.vb)
  • RE: Configuration parameter in SQL database
    ... Welcome to Microsoft Newsgroup Support Service! ... how to store&return the configuration ... SQL Server + SQL Dependency Cache ...
    (microsoft.public.dotnet.general)
  • RE: Connection Open Exemptions
    ... If the user can log into SQL server using QA, ... The user account can be either Windows account or SQL account. ... that you open a Support incident with Microsoft Product Support Services ...
    (microsoft.public.sqlserver.connect)
  • RE: Non initialized Cmd Parameter Collection via ASP vs SQL Server
    ... component to access database and execute some stored procedure. ... error when change the database from SQL server 2000 to SQL Server 2005, ... Microsoft MSDN Online Support Lead ... Delighting our customers is our #1 priority. ...
    (microsoft.public.data.ado)