A tag is a keyword or label that categorizes your question with other, similar questions. Using the right tags makes it easier for others to find and answer your question.
SQL Server Integration Services, an ETL tool sold by Microsoft and bundled with SQL Server versions since SQL Server 2005.
A schema of a database system is its structure described in a formal language supported by the database management system (DBMS) and refers to the organization of data to create a blueprint of how a d…
UPDATE changes the values of the specified columns in all rows that satisfy the condition. Only the columns to be modified need be mentioned in the SET clause; columns not explicitly modified retain t…
MySQL version 5.6 - please also tag with mysql for search purposes.
Splitting a database table into multiple segments for performance or manageability.
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
A widely-used open-source operating system that is particularly popular on servers.
A type of integrity constraint used in a RDBMS platform to ensure that a value in a column matches one of a range of key values from another table.
Azure SQL Database is a relational database-as-a-service from Microsoft. This tag is for questions about Azure SQL Database, NOT SQL Server hosted in an Azure VM (use azure-vm).
SQL Server 2019 (major build version 15.00.xxxx). Please also tag sql-server.
Amazon Relational Database Service is a web service that makes it easy to set up, operate, and scale a relational database in the cloud.
Oracle Database 12c. Please also tag oracle for search purposes.
the process of moving databases or data from one place to another
The process of determining which indexes are useful and which are not.
A mechanism for managing concurrent access to shared data or resources by granting temporarily exclusive access to the processes requesting the lock.
A core statement in SQL that does what it says on the tin: inserts data into a table.
Db2 is a family of relational database management servers developed by IBM. It runs on multiple platforms, including Unix (namely AIX), Linux, IBM i (formerly OS/400), z/OS and Windows.
Transaction log is a list/history of modification executed by a database management system to guarantee ACID properties over crashes or hardware failures.
A cluster consists of a group of computers connected so that in many respects they can be viewed as a single system.
When used in the context of databases, memory refers to RAM directly addressable by the CPU as opposed to going through the I/O subsystem.
A mechanism for committing a consistent set of changes into a database atomically.
A function performs some specified work, usually taking parameters as input. In terms of databases these may be specific to SQL or to the database vendor.
MySQL's Standard Dump/Backup Utility
GROUP BY : SQL Aggregation for Common Values
Oracle Database 11g (not 11g R2). Please also tag oracle for search purposes.
SQL term used to describe when a `SELECT` statement is used as part of a larger SQL statement. The larger statement may be DML and is always found within brackets or parenthesis.
The choice of settings for hardware, firmware, software or other components of a database system.
A popular open-source embeddable (i.e. non client-server) RDBMS implemented as a C library.
Microsoft Access is an application development and database development tool from Microsoft. It combines the Microsoft Jet/ACE Database Engine with a graphical user interface and software-development …
Use ONLY if PHP is directly relevant to the question and likely to be the source of your problem, not just because you're using a PHP library to connect to a database. PHP stands for Professional Hype…
Normalization is the process of organizing columns into tables within a relational database in such a way as to minimize redundancy and avoid insertion, update and deletion anomalies.
Improving the performance characteristics of a database application or system.
A virtual table that represents the data in one or more tables in an alternative way.
Operating system produced by Microsoft. Windows is produced in various desktop and server versions. Please also add a version-specific tag like windows-10 if that is relevant to the question.
MySQL version 8.0 - please also tag with mysql for search purposes.