Tags
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.
Combining multiple data points into a single data point. This usually is used in reference to SQL and usually to an aggregate function of some sort.
619 questions
Installation (or setup) of a database application, is the act of putting the application onto a computer system so that it can be executed.
619 questions
Linked server allows operation to multiple server as one query.
607 questions
Searching the text of a collection of documents or free text fields in a database to find those containing a word or combination of words.
600 questions
MySQL version 8.0 - please also tag with mysql for search purposes.
597 questions
A situation caused by two or more processes being unable to proceed (and thus release their locks) because they are blocked by locks on resources held by the other process.
596 questions
Procedural Language/Structured Query Language is Oracle Corporation's procedural language extension for SQL. IBM supports PL/SQL for DB2 since version 9.7. Questions about PL/SQL should probably be ta…
595 questions
SQL Server Reporting Services, a web based reporting tool produced by Microsoft and bundled with SQL Server.
589 questions
Ubuntu is a desktop and server operating system based on Debian GNU/Linux. Note that http://askubuntu.com is specifically dedicated to Ubuntu questions.
581 questions
A data structure that organizes information into rows and columns.
529 questions
SQL Server Agent is a Windows service installed with the SQL Server Standard Edition and above. It provides an automated way of executing or performing administrative task against a SQL Server instanc…
528 questions
The import of data is the automated or semi-automated input of data sets between different software applications.
520 questions
A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
517 questions
Specifies the type of data being stored (string, date, numeric, etc).
511 questions
MyISAM is the non-transactional storage engine for MySQL. It provides high-speed storage and retrieval, as well as fulltext searching capabilities. In addition, it is the default storage engine type f…
510 questions
The automated distribution of transactional changes from a publishing database to one or more subscriber databases.
491 questions
Upgrade refers to the replacement of a product with a newer version of the same product.
- replace (a software program) with a more recently released, enhanced version.
- replace (a hardware devic…
489 questions
A declarative mechanism such as a check or foreign key that enforces some data integrity rule in a database.
485 questions
A pivot (or crosstab) converts row data into columnar data, and vice versa for an unpivot. Not all databases support explicit PIVOT syntax but the functionality can be implemented, often using decisio…
473 questions
applies to questions about Relational Model theory. The Relational Model for database management is an approach to managing data using a structure and language consistent with fi…
449 questions
In the database structured query language (SQL), the DELETE statement removes one or more records from a table.
445 questions
Apache Cassandra is an open source distributed database management system. It is designed to handle very large amounts of data spread out across many commodity servers while providing a highly availab…
445 questions
COUNT : an aggregate SQL function that is used to count the number of rows.
445 questions
For questions about specific error codes or messages, including troubleshooting.
442 questions
A clause used in SQL SELECT statements to sort query results.
441 questions
All versions of Windows Server. Please also add a version-specific tag like windows-server-2012 if that is relevant to the question.
437 questions
High-availability technologies mask the effects of hardware or software failure, so that perceived downtime for users and applications is minimized.
433 questions
Recovery is the rebuilding of a database or table space after a problem such as media or storage failure, power interruption, or application failure. If you have backed up your database, or individual…
424 questions
A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.
423 questions
A catch-all term describing database systems using various non-relational models. Such systems are usually engineered to be high-performance.
415 questions
Constructing a query at runtime with string concatenation operations and executing the query from that string.
414 questions
Database auditing involves observing a database so as to be aware of the actions of database users.
401 questions