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 *************************
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
