PG vs MSSQL language comparison ?
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
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
Let me know if you spot anything missing you'd like updated.
Ciao
Fuzzy
:-)
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
AndreasHi 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.
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 *************************
On Sat, May 26, 2012 at 7:04 AM, Andreas <maps.on@gmx.net> wrote:
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.
Here's another resource, going into more detail:
http://troels.arvin.dk/db/rdbms/
Regards,
Marti
On 27/05/2012 04:46, F. BROUARD / SQLpro wrote:
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.
Very out of date...
Yep, agreed, as you found with the examples you shared :) Thanks for those, it's motivation to get my act in gear and bring it up to speed for 9.2.
:)