Podcast #128: We chat with Kent C Dodds about why he loves React and discuss what life was like in the dark days before Git. Listen now.

Questions tagged [database-engine]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
2answers
56 views

Differences between EDU and thread

In DB2, there is this command that shows active EDUs (engine dispatchable units): db2pd -edus There are two fields in the respective output: EDU ID and TID. According to this db2pd page from the ...
0
votes
1answer
44 views

Connecting to database engine again when a new query or running view

When I connect to a server via SSMS, I can connect fine albeit a slow. When I click on a new query or try to run a view in a database on this server, the same prompt comes up but with everything ...
1
vote
1answer
23 views

Tables with engines of “MEMORY” does not get dropped when server is restarted

I read a description from When to Use MEMORY or NDB Cluster from the MySQL website. Operations involving transient, non-critical data such as session management or caching. When the MySQL server ...
0
votes
1answer
32 views

csv engine and mysql start

my question is about speed when perform service mysql start. with many tables (some not often used). what engines consumes more or less start time ? example: innodb --> the more tables, the more ...
0
votes
1answer
40 views

Common practices to determine what database technology to use [closed]

Supposing I've started a new project that needs a database for persistence purposes. What are common practices to determine which database technology (MSSQL, MySQL, MongoDB, etc...) would best fit ...
-2
votes
3answers
92 views

admin: prefix before the servername while connecting to DB Engine Query in MS SQL Server

I am using SSMS to connect to DB Engine Query for DAC. I've seen some video tutorials where people use 'admin:' prefix before server name while connecting When trying to connect with that prefix I ...
10
votes
5answers
2k views

How to check what Database Engine is installed on the DataBase server that I have acces to run queries on?

I want to check what type of sql is running on a Datasase server that I can access. I only have access to a web interface and a list of tables. Through the interface I can run queries on the tables ...
2
votes
1answer
111 views

Database Engine not getting connected

I installed, SQL server 2016 on my local machine with SSIS feature. I am able to connect Analysis instance but when I am trying to connect to Database Engine it is giving below error. Services start ...
13
votes
1answer
1k views

Do databases make a delete and an insert when having to update rows?

So today a professor told us that when the database has to make an update, internally (at low level) it makes a delete and then an insert with the updated fields. He then said that this is something ...
1
vote
2answers
64 views

Is there a sql database engine that support “specific value duplicate restriction”?

For example, in the brand column of a product database, the brand value "unknown" should only exist once while other brand values can exist many times. Is there a sql database engine that supports it?...
0
votes
1answer
47 views

Database engine that share a row among multiple tables

I'm wondering whether exists any database engine that can share cells or rows amongst many tables. For example: TABLE Customer ( CID: int Fullname: nvarchar(50) Age: int ) TABLE Group ( ...
1
vote
1answer
2k views

InnoDB to MyISAM Conversion Problem

I have a dedicated server based on CentOS 5 OS , mysql 5 and phpmyadmin I was trying to convert all database tables from InnoDB to MYISAM. I tried to do it by setting in /etc/my.cnf file the value ...
3
votes
1answer
1k views

Alter mysql database engine doesn't work from cluster to other

I got into this issue when I tried to alter my database table engine to InnoDB from ndbcluster, It did not work. But When I changed engine from InnoDB to ndbcluster it worked. It did not throw any ...
1
vote
1answer
3k views

Constraint based rules engine

I am evaluating software systems which configure products that tout constraint based versus rules based engines. Can someone explain (with maybe an example or two) to a non-expert what the difference ...
1
vote
1answer
1k views

What are some good methods of structuring a MySQL audit trail to be both immutable, and perform well for usage?

In one application, we have an audit table that uses the ArchiveEngine in conjunction with a few triggers to capture 100% of the changes that occur. The upside to this is that 20+ million rows ...
12
votes
2answers
10k views

What exactly is a database engine?

I have gone through the definition on http://en.wikipedia.org/wiki/Database_engine several times: A database engine (or "storage engine") is the underlying software component that a database ...