Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

Sign up to join this community

Anybody can ask a question

Anybody can answer

The best answers are voted up and rise to the top

Explore our Questions

more tags

Active 2 Bountied Hot Week Month

0

votes

0

answers

9

views

CMS - Database Schema Review / Questions

mysql database-design schema

modified 4 mins ago Ainsley Clark 1

0

votes

1

answer

423

views

Cannot recover Database from ibdata file

mysql restore ibdata

modified 5 mins ago Community♦ 1

0

votes

1

answer

23

views

How to perform schema migration from array to many-to-many to lookup table?

postgresql database-design postgresql-9.6 many-to-many schema-migration

answered 6 mins ago Erwin Brandstetter 110k

2

votes

3

answers

240

views

Operator used tempdb to spill data . The estimated row are less than real rows

sql-server t-sql sql-server-2017

modified 33 mins ago Omar AMEZOUG 111

0

votes

0

answers

4

views

Incompatibility between unixODBC and Firebird ODBC driver

ubuntu odbc firebird r unixodbc

asked 51 mins ago dwenzel 3

0

votes

1

answer

219

views

Find and Insert Missing data in Mongodb Collection

mongodb python

modified 1 hour ago Community♦ 1

0

votes

0

answers

4

views

error while importing data in MySQL workbench

mysql-workbench

modified 1 hour ago Shorouk Raafat 1

0

votes

0

answers

9

views

I would like to migrate SQL SERVER 2014 to SQL SERVER 2019 on Linux using AG

sql-server-2019

asked 1 hour ago Hanan Hit 1

1

vote

1

answer

35

views

Can/Should rarely used columns be placed in a different table for performance?

mysql mariadb sqlite

modified 1 hour ago Rick James 50.4k

0

votes

1

answer

393

views

Importing a .bacpac from SQL Azure into a local SQL Server 2016 server gives errors

sql-server sql-server-2016 azure-sql-database

modified 2 hours ago Community♦ 1

1

vote

2

answers

43

views

Is it better to have a CASE expression or a JOIN with a dimensional table?

mysql postgresql performance redshift

answered 2 hours ago Rick James 50.4k

-3

votes

0

answers

13

views

Handling nulls while executing subqueries in WITH Clause

subquery

asked 2 hours ago Thirupathi 1

0

votes

0

answers

12

views

SQL Server linked server from on premises to SQL Server instance on Windows in Amazon EC2

sql-server

asked 2 hours ago user3213459 39

0

votes

1

answer

272

views

Unable to insert into table after creating an After insert trigger

mysql trigger

modified 3 hours ago Community♦ 1

Browse more Questions

Database Administrators Stack Exchange works best with JavaScript enabled