Skip to main content

Top 10 databases 2017

Just curious to know best databases in 2017. From the serverwatch, I got some information.
  1. Oracle
  2. Microsoft SQL Server
  3. IBM DB2
  4. SAP Sybase ASE
  5. PostgreSQL
  6. MariaDB Enterprise
  7. MySQL
  8. Teradata
  9. Informix
  10. Ingres

Comments

Popular posts from this blog

Table and its count

Table and its count To view all tables and its count by executing command and immediately, use below commands - MSSQL SELECT      sc. name   + '.' + ta. name   TableName,  SUM (pa. rows ) RowCnt FROM      sys.tables ta INNER   JOIN   sys.partitions pa      ON   pa.OBJECT_ID = ta.OBJECT_ID INNER   JOIN   sys.schemas sc      ON   ta.schema_id = sc.schema_id WHERE   ta.is_ms_shipped = 0  AND   pa.index_id  IN   (1,0) GROUP   BY   sc. name ,ta. name ORDER   BY   SUM (pa. rows )  DESC