Sybase

  Numeric data type SAP IQ – supports up to (126, 38) MySQL/memSQL – support up to 65 digits; https://docs.memsql.com/sql-reference/v6.5/datatypes/ ISNULL vs IFNULL SAP IQ …

  Pre-Migration : Questionnaire That need to ask from the client before planning to migrate SAP Sybase ASE database servers from physical machines to virtual. …

  We are going to create warm standby backup of SAP Sybase ASE Prod1 server to Standby1 server using Sybase Replication Server REP15_7 for a database …

  Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB …

  Adding Space to Sybase IQ server Little background about IQ space. In IQ 15.0 Dbspace != dbfile Under one dbspace we can have many dbfiles …

  Single Node Architecture: when we talk about Sybase IQ architecture , We should explain about the Three important IQ stores and three main files. which …

It will display current running processes: [crayon-676e37500af10192077774/]   It will display processes which is running by “dbmaint” user id: [crayon-676e37500af13208280336/]   It will display databases …

  1)How to Calculate Memory Usage and Disk Space Usage? There are 2 stored procs which help you to calculate the memory size and database …

Introduction A principal component of a protected system is accountability. One way to ensure accountability is to examine events on the system. Many events that …

  1.Check error log to find the tempdb full. 2.Find out the space free in tempdb using [crayon-676e37500b551880545689/] 3.dum tran with truncate only if still …