Sybase 12.5 Database Statistics (Maximum)
Answer / prabhu
Databases per Adaptive Server Enterprise - 32,767
Server Size - 8 terabytes
Database size - 4 terabytes
Page Size - 2K, 4K, 8K, 16K
Databases spanned by one update 16
Databases opened by one transaction 16
Tables in a query 50
Logins per server 2,147,516,416
Users per database 2,146,484,223
Groups per database 1,032,193
Columns per table 1024
Arguments to stored procedure 2048
| Is This Answer Correct ? | 6 Yes | 2 No |
How would you check the long running transaction?
Given a table which contains some rows with duplicate keys, how would you remove the duplicates?
Tempdb is full. How would you clear it?
What is difference between sybase and oracle?
Why am I running out of locks on the replicate side in sybase ?
List different types of locks in sybase?
How do I take advantage of table partitioning with bcp in sybase?
What is an advantage to using a stored procedure as opposed to passing an sql query from an application ?
What is the equivalent of oracle/db2 coalesce function in sybase?
What is raid and sybase?
How do I configure identities in sybase?
Explain coalesce.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)