Re: PG vs MSSQL language comparison ?

Le 26/05/2012 06:36, Grant Allen a écrit :
> On 26/05/2012 00:04, Andreas wrote:
>> Hi,
>>
>> I'm not into comparing which DBMS is better as we all know ... kind of ... well ...
>>
>> I'd like to find ressources to look up how one can do X in MSSQL when one knows how it is done in PG's SQL and the other way around.
>>
>> regards
>> Andreas
>
> Hi Andreas,
>
> It's a little out of date (I've been meaning to update it for about 2 years now) and has some gaps, but try the Database Rosetta Stone.
>
> http://www.grantondata.com/community/dbrosettastone.html

Very out of date...

some example :
Statistics Gathering:
CPU Costing, says no... But it is YES
Disk / IO Costing, says no... But it is YES
Since a lot !

Query Management:
Query/Resource Governor, says no... But it is YES (since V 2008)
View historic queries in system cache, says no... But it is YES
(since V 2005)

Parallelism
Parallel Sorts, says ?... But it is YES (since a lot)
Parallel Index (re)build, says ?... But it is YES (since V 2005)
Parallel (table) Reorganisation, says ?... But it is YES (since a lot)

same on datatype
DATE, TIME, DATETIME WITh TIME ZONE... have been added to 2008 version**

and some indication are wrong.
Example :
CLOB Datatype sauys no. It is yes vith text type almost since v 7 (1999 !)

Totally incomplete for date functions...

>
> Let me know if you spot anything missing you'd like updated.
>
> Ciao
> Fuzzy
> :-)
>

--
Frédéric BROUARD - expert SGBDR et SQL - MVP SQL Server - 06 11 86 40 66
Le site sur le langage SQL et les SGBDR : http://sqlpro.developpez.com
Enseignant Arts & Métiers PACA, ISEN Toulon et CESI/EXIA Aix en Provence
Audit, conseil, expertise, formation, modélisation, tuning, optimisation
*********************** http://www.sqlspot.com *************************