Hottest Questions Today

0

votes

1

answer

15

views

Is it possible to write a function in postgresql which directly writes its parameters to a text file?

postgresql functions

modified 2 hours ago mustaccio 12.5k

0

votes

0

answers

13

views

Nested select statement work procedure

modified 4 hours ago McNets 18.1k

0

votes

1

answer

11

views

How to connect two attributes without a PK (MySQL)

mysql phpmyadmin

answered 5 hours ago Michael Green 16.6k

3

votes

3

answers

103

views

SQL log file 2TB is not enough, now what?

sql-server transaction-log

modified 56 mins ago AMtwo 5,361

0

votes

1

answer

18

views

GROUP BY with date ranges when values change but then change back

sql-server t-sql query gaps-and-islands

modified 5 hours ago Michael Green 16.6k

1

vote

2

answers

42

views

Permissions using a TYPE as a Table Valued Parameter

sql-server sql-server-2014

modified 23 hours ago David Browne - Microsoft 16.3k

-1

votes

2

answers

40

views

Is there a way to increase the speed of the following insert without having to create an unclusterd index being suggested by sql server? [on hold]

sql-server query-performance insert

answered 18 hours ago J.D. 692

0

votes

0

answers

30

views

Without rewriting this query, is there a way to force the query optimizer to better estimate the amount of resources required, e.g. with query hints?

sql-server sql-server-2008-r2 query-performance optimization hints

asked 18 hours ago J.D. 692

0

votes

0

answers

22

views

Storing 450,000,000,000 data points in a bitemporal datastore

database-design scalability time-series-database

asked 18 hours ago Tom 11

-3

votes

0

answers

13

views

MySQL returns more than one row with AND operator match

join mysql-5.6

asked 17 hours ago Abu Nooh 122

0

votes

2

answers

16

views

How to add time from a Date value to another without a varchar conversion?

oracle query datetime date

answered 18 hours ago Michael Kutz 2,927

-1

votes

1

answer

18

views

How to sync data between two databases on two different ms sql server instances - one 2008 and the other 2016

sql-server-2008 sql-server-2016 sql-data-sync

answered 10 hours ago Priyanka 104

0

votes

1

answer

24

views

Session ID in SQLCMD running multi-batch script

sql-server sqlcmd session

answered yesterday Scott Hodgin 20.1k

1

vote

1

answer

33

views

UPDATE column to MIN of a SELECT result set - what went wrong?

sql-server select update

answered 19 hours ago Rob Farley 14.1k

0

votes

1

answer

25

views

Insert set value into DB

sql-server-2017

answered 23 hours ago Scott Hodgin 20.1k

-1

votes

0

answers

13

views

Restore plan cache and buffer pool after database restore?

sql-server restore plan-cache buffer-pool

asked 19 hours ago Conrad S. 106

-3

votes

0

answers

34

views

can anyone answers these im new to database [on hold]

mysql

modified 1 hour ago John Stuart 1

0

votes

0

answers

18

views

Postgresql v10.1 - How to fix ERROR: duplicate key value violates unique constraint

postgresql amazon-dms

modified 20 hours ago mustaccio 12.5k

2

votes

1

answer

34

views

what could be preventing my transaction log autogrowth to be set to UNLIMITED?

sql-server sql-server-2016 transaction-log configuration auto-growth

modified yesterday sepupic 8,549

0

votes

0

answers

34

views

Recommended ways to export large query result to JSON or other text format

sql-server

asked yesterday John Kinane 1

0

votes

1

answer

26

views

Can we copy data from 1 text file to 2 postgresql tables?

postgresql copy

modified 20 hours ago Erwin Brandstetter 105k

0

votes

2

answers

20

views

Select data from table join or UDPATE?

postgresql performance update

answered 22 hours ago jjanes 18.2k

0

votes

1

answer

45

views

Restructuring table - start with PK or not?

sql-server database-design schema-migration

answered yesterday sepupic 8,549

1

vote

1

answer

22

views

Oracle Database 11g Failing to mount on windows server 2012

oracle oracle-11g-r2

answered yesterday Balazs Papp 29.7k

-1

votes

0

answers

47

views

Incorrect syntax near the keyword 'CASE' [on hold]

sql-server sql-server-2012 sql-server-2008 t-sql

modified yesterday a_horse_with_no_name 47.4k

1

vote

2

answers

24

views

How can I have an aggregate function in the WHERE clause?

postgresql postgresql-9.3 count sum

modified yesterday Akina 7,942

0

votes

1

answer

27

views

Create a user on database A with a procedure from database B (with EXECUTE AS)

sql-server stored-procedures permissions security sql-server-2017

modified 7 hours ago Shekar Kola 965

0

votes

0

answers

31

views

AG lag for some weird reason [on hold]

sql-server availability-groups enterprise-edition

modified yesterday Peter Vandivier 2,335

0

votes

2

answers

26

views

New to CTE - How to do a count after making table unique

cte redshift

modified 21 hours ago mustaccio 12.5k

1

vote

1

answer

15

views

Postgresql Master/Slave Using Patroni

postgresql patroni

answered yesterday Laurenz Albe 5,199

0

votes

1

answer

17

views

Serialize a column based on sorting order?

mariadb

answered yesterday Akina 7,942

10

votes

4

answers

1k

views

Why would shrinking TEMPDB log lead to slowness?

sql-server transaction-log tempdb

modified 2 days ago scsimon 2,915

-1

votes

1

answer

40

views

Return the last purchase for each item in a group

mysql greatest-n-per-group

modified yesterday a_horse_with_no_name 47.4k

0

votes

2

answers

42

views

SQL cannot add columns to query

postgresql postgresql-9.5

answered yesterday user2569831 3

1

vote

1

answer

25

views

Some timeout in query store but get all SP:Starting and SP:Completed in profiler

sql-server profiler query-store timeout troubleshooting

modified yesterday Randi Vertongen 10.5k

0

votes

0

answers

16

views

Can copy command in postgresql append data to a file? [duplicate]

postgresql copy

modified yesterday suvrat 3

0

votes

0

answers

14

views

Is it possible to join on column placeholders?

join google-bigquery

modified yesterday Philᵀᴹ 27.4k

1

vote

1

answer

26

views

mongodump fails after exactly 10 minutes

mongodb mongodump

answered yesterday ssasa 171

3

votes

1

answer

112

views

Add banner motd to postgres database

postgresql

answered 2 days ago Laurenz Albe 5,199

0

votes

1

answer

12

views

Use plpgsql to count records selected for output AND output those records

postgresql select count

answered yesterday Laurenz Albe 5,199

1

vote

1

answer

29

views

(MySQL) SET column with values from a foreign key constrant

mysql

answered yesterday Akina 7,942

1

vote

3

answers

76

views

Filtered index is not used when variable in WHERE condition

sql-server execution-plan filtered-index

answered yesterday uberbloke 36

0

votes

0

answers

28

views

FTS is slower on tsvector than text

postgresql index full-text-search

modified yesterday BinaryVeil 68

2

votes

2

answers

28

views

Is partial dependency possible In Data Base for Foreign key relationship

database-design

answered yesterday Michael Green 16.6k

0

votes

2

answers

19

views

Different Maximum server memory across Availability Replicas

sql-server-2014 availability-groups configuration memory

answered yesterday Shanky 15.6k

0

votes

3

answers

87

views

+100

Extract only Date from the string

sql-server

answered 22 hours ago James 1,241

1

vote

2

answers

88

views

SQL Server RAM usage is increasing and query executions is slowing down with time

sql-server memory wait-types

answered yesterday sepupic 8,549

Top Questions

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