All articles: Others

Checkout our self-help content, created by our top Experts!
FINDSTRING function in SSIS – Querychat
We use FINDSTRING function if we need to find a particular string within an SSIS column value. Very often, users have the need to get particular value out of specific column values already provided in the data source. For example, a common situation is to extract a year out of...
How to Copy a Database in MySQL – Querychat
While we are working with our database, we may need to copy it to another database on the same server, for example, for data backup. In this article, we will learn how to clone the database in MySQL. This guide contains instructions and examples. MySQL: duplicate database Copying a database...
How to Deal with Oracle Database Login Issues – Querychat
When using Oracle, we might face a problem when trying to connect to the database. In this article, we learn how to deal with login issues in the Oracle Database Server. Also, we will learn how to deal with common port listener issues when logging into the database. Common login...
Public role access in SQL Server – Querychat
SQL Server offers various access roles when dealing with data and database infrastructure. One of the access roles that are being mostly used is the public role. This article elaborates on what the public role access is in SQL Server, how it is configured, and when do we use it...
Staging table in SQL – Querychat
When developing database systems that deal with data that reside from some external sources, we often need to store that data in some temporary place. These places are called staging tables. This article elaborates on what are staging tables in SQL, and why we need them in terms of performing...
SQL Server Memory Usage – Querychat
A memory setting is a crucial configuration setting in SQL Server. It helps us use the resources efficiently and get the data from the databases quickly. This article elaborates on what is and how to read and set two crucial SQL Server memory options, min server memory, and max server...
How to Optimize TABLE in MySQL – Querychat
In this article, we will find out how to increase the efficiency of data input and output from the table through its optimization. We will learn in which cases optimization is necessary and look at an example showing how to optimize them. MySQL OPTIMIZE TABLE syntax We can optimize a...
What Is a Table Variable In SQL? – Querychat
In this article, we will discover the table variables in SQL, which are very similar to temporary tables and help us to store the contents of a whole table. Earlier, temporary tables were used as storage of any intermediate data and then appeared table variables. Table variable syntax The temporary...
How to Export MySQL Query to CSV – Querychat
In this easy and short guide, we will cover the theme of exporting the MySQL SELECT query result into a CSV file. Converting a query result into a text file is easier than it could appear.  MySQL output to CSV We can decide to export the query to the file...
How to Login to MySQL Through the Command Line – Querychat
In this article, we will discover the principle of connecting a client program to a MySQL server, as well as how to configure connection parameters through the command line. MySQL login command The client program connects to the server using such necessary parameters as the hostname, username, and password of...
1 2 20 21