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

1

vote

0

answers

5

views

By using SQL Window Functions, how can I get the lead of the last row in a partition?

postgresql window-functions

modified 25 mins ago a_horse_with_no_name 45.8k

3

votes

1

answer

902

views

speed up PostgreSQL calculations via OLAP warehouse?

postgresql query-performance schema data-warehouse olap

modified 43 mins ago Community♦ 1

1

vote

1

answer

170

views

MS SQL 2008 Databse in Suspect mode and CHECKDB returns error: Object ID 3 has chain linkage mismatch

sql-server-2008 data-loss

modified 1 hour ago Community♦ 1

0

votes

0

answers

7

views

help me in database normalization and ERD

database-design

modified 1 hour ago a_horse_with_no_name 45.8k

0

votes

1

answer

98

views

Problems to connect to an Oracle Database with SQLPLUS and URL-Variable, can somebody explain what I have to do?

oracle ubuntu sqlplus connections

modified 2 hours ago Community♦ 1

0

votes

1

answer

844

views

InnoDB: Cannot open table (New Issue)

mysql innodb mysql-5.5 mysql-5.6

modified 3 hours ago Community♦ 1

0

votes

0

answers

2

views

Cannot create or use an SSIS package template in SSDT 2017

ssis ssdt visual-studio-2017

asked 3 hours ago Scott M 11

0

votes

0

answers

4

views

MySQL: INSERT INTO SELECT issues

mysql update insert alias

asked 4 hours ago Mark Messa 138

3

votes

3

answers

691

views

Optimise Large Record Deletion Procedure

mysql performance query-performance optimization stored-procedures

modified 4 hours ago Community♦ 1

1

vote

1

answer

636

views

Cannot connect to database hosted at CentOS VM through SQL Developer on Windows

oracle oracle-12c centos vmware

modified 5 hours ago Community♦ 1

2

votes

2

answers

97

views

What is the most efficient way to store a bunch of empty fields, and ones with only a few choices?

mysql storage

answered 5 hours ago cybernard 111

1

vote

1

answer

1k

views

Connecting SQL Anywhere with Sybase database file on local computer

sybase-sql-anywhere

modified 6 hours ago Community♦ 1

1

vote

2

answers

197

views

mySQL Workbench new Connection : There is no disk in drive. Please insert disk in \Device\Harddisk2\DR2

mysql mysql-workbench connectivity

modified 7 hours ago Community♦ 1

Browse more Questions

Database Administrators Stack Exchange works best with JavaScript enabled