SQLServer
-
국내외 알려진 RDBMS의 MVCC 방식 RDBMS별 MVCC 지원 정보 RDBMS 출시 버전 MVCC ORACLE 4 ↑ Rollback Segment TIBERO 3(추측) ↑ Rollback Segment IBM DB2 9.7 ↑ Rollback Segment MySQL 5 ↑ Rollback Segment (only Innodb) / MyISAM : MVCC X MariaDB 5 ↑ Rollback Segment (only Innodb) / MyISAM : MVCC X ALTIBASE 3.0 ↑ MGA(In-memory) / Rollback Segment (DISK) PostgreSQL 6.5 ↑ MGA SQL Server 2005 ↑ MGA CUBRID 10 ↑ MGA
MVCC 두 가지 방식: MGA와 Rollback Segment국내외 알려진 RDBMS의 MVCC 방식 RDBMS별 MVCC 지원 정보 RDBMS 출시 버전 MVCC ORACLE 4 ↑ Rollback Segment TIBERO 3(추측) ↑ Rollback Segment IBM DB2 9.7 ↑ Rollback Segment MySQL 5 ↑ Rollback Segment (only Innodb) / MyISAM : MVCC X MariaDB 5 ↑ Rollback Segment (only Innodb) / MyISAM : MVCC X ALTIBASE 3.0 ↑ MGA(In-memory) / Rollback Segment (DISK) PostgreSQL 6.5 ↑ MGA SQL Server 2005 ↑ MGA CUBRID 10 ↑ MGA
2022.10.14 -
SQL Server(mssql) 데이터베이스 버전 확인 SQL SQL> SELECT @@VERSION; | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Microsoft SQL Server 2022 (CTP2.0) - 16.0.600.9 (X64) ¶ May 20 2022 13:29:42 ¶ Copyright (C) 2022 Microsoft Corporation¶ Developer Edition (64-bit) on Li..
SQL Server(mssql) 버전 확인SQL Server(mssql) 데이터베이스 버전 확인 SQL SQL> SELECT @@VERSION; | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ Microsoft SQL Server 2022 (CTP2.0) - 16.0.600.9 (X64) ¶ May 20 2022 13:29:42 ¶ Copyright (C) 2022 Microsoft Corporation¶ Developer Edition (64-bit) on Li..
2022.10.10