Every table must have at least one column as the Primary Index. The Primary Index is defined when the table is created.There are two reasons you …
Read More »Sybase Questions
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 …
Read More »PG Log File Maintenance and DB Corruption
It is a good idea to save the database server’s log output somewhere, rather than just routing it to /dev/null. The log output is invaluable when …
Read More »PostGre SQL Database Maintenance
PostgreSQL, like any database software, requires that certain tasks be performed regularly to achieve optimum performance. The tasks discussed here are required, but they are repetitive in nature …
Read More »PG DB Optimization
Overview This article briefs us on how to tune a database or make it work faster Max connections: We can configure the maximum number of …
Read More »PG Tuning, Statistics and Indexes
Database Tuning Fundamentally, database performance tuning is done for two basic reasons, to reduce response time and to reduce resource usage, both of which can apply …
Read More »PostgreSQL Basics
Overview PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store …
Read More »SQL Server 2017 Setup on Redhat Linux Or Migrate SQL Server 2012 DB on Window Server to SQl Server 2017 on Redhat Linux
SQL Server 2017 is supported on Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and Ubuntu. It is also supported as a …
Read More »How to build a MySQL on Linux quickly?
This article introduces how to build a MySQL on Linux quickly. This’s often used to build a temporary MySQL for testing. In short, we only need …
Read More »MariaDB Column Compression 10.3
MariaDB support different type of compression before 10.3.x . Most of them need external packages (lz4,lzo,lzma,bzip2,snappy) to be installed before using them . Default …
Read More »