Hottest Questions Today

1

vote

1

answer

15

views

Indexing for a table with many large subsets

answered 1 hour ago Joe Obbish 20.2k

2

votes

1

answer

35

views

Deadlock with insert and delete

sql-server locking deadlock

modified 32 mins ago jadarnel27 2,663

0

votes

2

answers

39

views

Workaround to implement Minimum Degree of Parallelism

sql-server maxdop

modified 3 mins ago crokusek 978

1

vote

2

answers

29

views

SQL Server Error Log - Is It / Can It Be Encrypted?

sql-server encryption error-log

answered 53 mins ago Michael Keleher 649

0

votes

1

answer

38

views

How to export SQL Server database as single .sql query file

sql-server t-sql

modified 3 hours ago RDFozz 9,779

0

votes

0

answers

14

views

Inserting into table depending on conditions

sql-server insert

modified 3 hours ago McNets 14k

1

vote

0

answers

13

views

How to resolve error 15517 when DBO is set to SA?

sql-server-2016 ssms

modified 3 hours ago Vargr 6

0

votes

1

answer

24

views

Always on basic question

sql-server

modified 6 hours ago Kin 52.5k

-1

votes

0

answers

11

views

SQL Log File to Table Insert/Update

sql-server mysql postgresql database-design sql-server-2012

modified 4 hours ago McNets 14k

0

votes

2

answers

21

views

Get ID which has two rows with specific values for one column

oracle

modified 4 hours ago a_horse_with_no_name 38.1k

0

votes

1

answer

18

views

How do you delete an aliased user

sql-server-2008-r2 sql-server-2000

answered 5 hours ago Dan Guzman 13.3k

0

votes

1

answer

21

views

Vehicle Pickup time database design

mysql database-design

answered 6 hours ago Rick James 40.1k

0

votes

1

answer

34

views

SQL Server 2016 capped at specific CPU usage

sql-server sql-server-2016

answered 10 hours ago Andrew Brennan 1,906

0

votes

1

answer

21

views

How to get Average value from one row if have zero or null values in mysql

mysql count

answered 6 hours ago Rick James 40.1k

0

votes

0

answers

15

views

Insert constraint issue

informix

modified 7 hours ago McNets 14k

0

votes

0

answers

14

views

Sync test MySQL database with production

mysql data-synchronization heroku vpn

asked 9 hours ago Biker John 106

0

votes

2

answers

27

views

Time taken to drop/add index is lesser than adding a column. Why is that?

mysql innodb mariadb alter-table mariadb-10.1

answered 7 hours ago Rick James 40.1k

0

votes

1

answer

31

views

Create Copy of all rows where foreign key matches specified and then replace foreign key

sql-server database-design replication

modified 11 hours ago J. Spence 3

0

votes

0

answers

24

views

Select constrains with on update no action

postgresql migration

modified 11 hours ago Dave 304

0

votes

2

answers

24

views

Best way to include AND exclude?

mysql

modified 13 hours ago McNets 14k

0

votes

0

answers

14

views

Make use of PostgreSQL 10 multi-column statistics when planning index scans

postgresql postgresql-10 index-statistics

asked 12 hours ago Justinas Marozas 101

0

votes

0

answers

16

views

Where is the connection pool connection timeout set?

mongodb connections mongodb-3.0 connection-pooling timeout

modified 11 hours ago Ian_H 1,423

0

votes

0

answers

12

views

mysql - allow a user to grant privilliges to databases to other users

mysql permissions

modified 12 hours ago w-- 101

0

votes

2

answers

34

views

How to choose which backup files to restore when identical timestamps exist for diff and log backups

sql-server backup restore

answered 16 hours ago Jerry Hung 96

0

votes

1

answer

42

views

Changing SQL Server (MSSQLSERVER) Service Account

sql-server

answered 9 hours ago Tibor Karaszi 1,291

-1

votes

1

answer

23

views

Time difference between 2 consecutive lines

sql-server

modified 16 hours ago McNets 14k

-1

votes

0

answers

13

views

In SQLitestudio, how to query this schema

sqlite

modified 15 hours ago McNets 14k

-1

votes

0

answers

13

views

sql server 2008 r2 differential backup [on hold]

sql-server sql-server-2008-r2

asked 17 hours ago thotwielder 158

-1

votes

0

answers

15

views

Help needed in PHP MySQL code

mysql php

modified 17 hours ago a_horse_with_no_name 38.1k

0

votes

0

answers

12

views

Payment method schema design

mysql

asked 17 hours ago Lansana 123

2

votes

2

answers

55

views

Design star schema for relatonal database

data-warehouse star-schema

modified yesterday Mr.Brownstone 8,669

0

votes

0

answers

17

views

How to store skip lists on disk?

database-design data-pages tree disk-structures physical-design

modified 20 hours ago gayita 1

-1

votes

1

answer

23

views

phpMyAdmin 4.8 vs 5.0 comparison

phpmyadmin

answered 11 hours ago Dave 304

-1

votes

2

answers

62

views

DB2 Join with case when statement or union

db2 query case

answered 4 hours ago Butterfly 1

0

votes

0

answers

21

views

Can't connect to MongoDB by SSH Tunnel with OPENSSH key

mongodb

modified 13 hours ago Hugo 101

-1

votes

1

answer

57

views

How to create a view joining the following tables? I want to find cities that have the same name as students' first names [on hold]

mysql

modified yesterday ypercubeᵀᴹ 73.5k

0

votes

1

answer

18

views

Duplicate Ips for cluster nodes causing backup issues

sql-server clustering windows-server-2012 dns

answered 20 hours ago Sean Gallardy 14.9k

1

vote

2

answers

45

views

How to optimize a table for a very high-frequency updates?

postgresql

answered yesterday jjanes 12.4k

0

votes

0

answers

18

views

using “LOAD DATA” with CSV files

csv mysql-8.0

modified 16 hours ago Michael Green 14.1k

1

vote

1

answer

25

views

MySQL schema design - how to decide between an `enum` vs. a table join

mysql database-design rdbms

answered yesterday Rick James 40.1k

1

vote

1

answer

50

views

Measuring latency of a long-distance SQL connection

sql-server-2012 query-performance

modified 11 hours ago jadarnel27 2,663

1

vote

1

answer

17

views

Error while installing Oracle 11g in Ubuntu 18.04

oracle-11g-r2 installation ubuntu

answered yesterday Zuman 16

0

votes

1

answer

27

views

For each implementation in joins

join mariadb

modified yesterday Community♦ 1

-1

votes

0

answers

30

views

No matching network interface found for resource 'Cluster IP Address' IP address 'xx.xxx.245.140' (return code was '5035')

sql-server-2016 availability-groups clustering

modified 16 hours ago Michael Green 14.1k

1

vote

1

answer

14

views

My Database Tables Revert to MyISAM Instead of InnoDB (MySQL)

mysql

answered yesterday Rick James 40.1k

0

votes

1

answer

56

views

Is it good practice to create a separate table for views count?

mysql database-design best-practices relations

modified 8 hours ago Rick James 40.1k

6

votes

2

answers

129

views

Why does changing the sort order return a different number of results? Is it a bug?

sql-server

answered 13 hours ago Michael Green 14.1k

0

votes

2

answers

45

views

SQL Grouping rows in a feed database table, output only grouped rows adding a group row

mysql sql-standard

modified yesterday Sam 349

Top Questions

Looking for more? Browse the complete list of questions, or popular tags. Help us answer unanswered questions.