Stack Overflow
Stack Overflow

Questions tagged [database-management]

115 questions
106
votes
15 answers

Listing information about all database files in SQL Server

Is it possible to list information about the files (MDF/LDF) of all databases on an SQL Server? I'd like to get a list showing which database is using what files on the local disk. What I tried: exec sp_databases all databases select * from…
M4N
  • 94,805
  • 45
  • 217
  • 260
25
votes
6 answers

Visual Studio vs. SQL Server Management Studio - Your Pick

Just to preface: I work in a small company that does ASP.NET development and uses SQL Server 2005 for all of our database needs. I was curious as to what were the pros and cons of using Visual Studio or SQL Server Management Studio for our…
TheTXI
  • 37,429
  • 10
  • 86
  • 110
23
votes
12 answers

Should we have separate database instance for each developer?

What is the best way for developing a database based application? We can have two approaches. One common database for all the developers. Separate database for all the developers. What are the pros and cons of each? And which one is better…
Amitabh
  • 59,111
  • 42
  • 110
  • 159
21
votes
4 answers

How can I list all tables in a database with Squirrel SQL?

I use Squirrel SQL to connect to a JavaDB/Derby database on my desktop. I can run SQL queries. But how can I list all tables in the database? And preferably all column and column types.
Jonas
  • 121,568
  • 97
  • 310
  • 388
17
votes
2 answers

Single Table Inheritance (Database Inheritance design options) pros and cons and in which case it used?

Today, I studied about about 2 database design inheritance approaches: Single Table Inheritance Class Table Inheritance In my student opinion, Single Table Inheritance makes a database smaller vs other approaches because it uses only 1 table. But…
Ben
  • 25,389
  • 34
  • 109
  • 165
10
votes
5 answers

Code & data tracking / deployment

For a long time now, we've held our data within the project's repository. We just held everything under data/sql, and each table had its own create_tablename.sql and data_tablename.sql files. We have now just deployed our 2nd project onto Scalr and…
Andrei Serdeliuc ॐ
  • 5,828
  • 5
  • 39
  • 66
10
votes
5 answers

Map existing Database table for Laravel

I am looking for a way to map existing tables in a project with the Eloquent ORM and use them in code. I use a MySQL database and plan to migrate to MSSQL. Any way points are appreciated.
Sangoku
  • 1,588
  • 2
  • 21
  • 50
10
votes
3 answers

MySQL Database Connection Management In PDO

I'm very new to PHP/MySQL and I'm learning things as I go. One of the newer things I've learned is that there is a maximum number of connections that can be made to a database for a given username. When I first started building my website on…
user1562781
  • 379
  • 1
  • 9
  • 20
8
votes
2 answers

Insert BLOB test string bigger than 2000 or 4000 bytes

I have a table in oracle with a BLOB column, that can store XMLs and as well XMLs zipped. These are requirements from the customer and can't be changed. The tables will be created and I have to read and work with some information inside the BLOBs.…
Weslor
  • 22,180
  • 2
  • 20
  • 31
8
votes
2 answers

Spring cannot propagate transaction to ForkJoin's RecursiveAction

I am trying to implement a multi-threaded solution so I can parallelize my business logic that includes reading and writing to a database. Technology stack: Spring 4.0.2, Hibernate 4.3.8 Here is some code to discuss…
nyxz
  • 6,918
  • 9
  • 54
  • 67
7
votes
3 answers

Semantics of the Boolean and comparison operators in the context of three-valued-logic

Professor ask me this question: What is the semantics of the Boolean and comparison operators in the context of three-valued-logic? I'm not sure what he meant by that. What is comparison operator? Is that the same as relational operator? Semantics?…
DB Student
  • 71
  • 2
5
votes
2 answers

How to modify the duplicate form in the database manager?

I want to add some other field to this form that can be accessed from the Database Manager in Odoo The data is sent to this controller: @http.route('/web/database/duplicate', type='http', auth="none", methods=['POST'], csrf=False) def…
ChesuCR
  • 9,352
  • 5
  • 51
  • 114
5
votes
2 answers

Phpmyadmin vs Jetbrains Datagrip for database management

I have been working with Phpmyadmin for quite some time and recently i came across Jetbrains Phpstorm and Intellij which i both really liked. Now i found the database environment Datagrip. I wanted to know objectively: what are the advantages of…
TheDoctor
  • 2,362
  • 4
  • 22
  • 39
5
votes
2 answers

How to Handle Database Connections in Qt?

Here my problem; in such a case it complains about duplicate connections with same connection name: Test::Test(QString connectionName) { db=QSqlDatabase::addDatabase("QMYSQL",connectionName); } int main(int argc, char *argv[]) { QString…
metdos
  • 13,411
  • 17
  • 77
  • 120
4
votes
1 answer

How long are stats in PostgreSQL's pg_stat_all_indexes table stored?

I use PostgreSQL 11.1 and I'm trying to gather information from pg_stat_all_indexes table about indexes usage to determine whether a particular index can be removed or not - according to Index size/usage statistics section in…
bronek
  • 43
  • 4
1
2 3 4 5 6 7 8