Hottest Questions Today

0

votes

0

answers

12

views

Cannot find slow (frozen) running query in Query Store

modified 1 hour ago Creztian 58

0

votes

0

answers

11

views

Can we use MariaDB mysqldump CLI to take dump from MySQL Community version?

mysql mariadb mysqldump mysql-5.7 mariadb-10.3

modified 3 hours ago karthikeayan 106

4

votes

1

answer

62

views

Update Intersect hangs

sql-server sql-server-2014 update

modified 30 mins ago Paul White♦ 56.1k

0

votes

0

answers

14

views

What will this nonclustered index's root and non-leaf level look like? [on hold]

sql-server nonclustered-index

modified 2 hours ago Paul White♦ 56.1k

0

votes

2

answers

27

views

Are race conditions possible in SQL?

locking blocking

answered 2 hours ago Laurenz Albe 1,100

0

votes

0

answers

12

views

non cluster index store the cluster key instead of RID [on hold]

sql-server nonclustered-index

modified 2 hours ago Paul White♦ 56.1k

4

votes

2

answers

83

views

Very similar queries, vastly different performance

sql-server performance query-performance optimization execution-plan

modified 1 hour ago Randi Vertongen 6,403

5

votes

3

answers

127

views

DBCC checkdb on tempdb

sql-server dbcc-checkdb

modified 15 hours ago Shanky 15.3k

0

votes

2

answers

34

views

SQL Alert for long running queries

query sql-server-2017 alerts

modified 3 hours ago Mauricio 1

1

vote

2

answers

36

views

Find user who kicked off a SQL Agent job at runtime

sql-server-2016 security

answered 1 hour ago Dennis Finke 45

-3

votes

2

answers

44

views

Why is this query not returning the right result? [on hold]

postgresql

modified 4 hours ago Laurenz Albe 1,100

1

vote

1

answer

19

views

How to prevent concurrency issues in a ssis package?

sql-server ssis sql-server-2017 concurrency

answered 8 mins ago user3760185 1

0

votes

1

answer

28

views

How do I get more control over backup file retention using Ola Hallengren's DatabaseBackup solution?

sql-server ola-hallengren

answered 11 hours ago HandyD 2,993

-2

votes

1

answer

27

views

How to find out NOT NULL attributes in tables

sql-server query

answered 11 hours ago HandyD 2,993

2

votes

0

answers

19

views

Is it possible to setup a CREATE_LOGON trigger that treats AD Groups differently from users?

sql-server trigger

asked 13 hours ago Manzabar 111

0

votes

1

answer

11

views

sp_BlitzCache and cursors

cursors sp-blitzcache

answered 13 hours ago Brent Ozar 36.6k

0

votes

0

answers

18

views

How to formulate a query and view for the following structure?

mysql database-design

modified 13 hours ago Laurenz Albe 1,100

1

vote

0

answers

13

views

Can CyberArk Manage SQL Credentials To Synchronize Password Changes?

sql-server security

asked 12 hours ago MattyZDBA 1,146

6

votes

1

answer

66

views

Cannot insert duplicate key row on a non-unique index?

sql-server sql-server-2017

modified 16 hours ago Piotr 152

0

votes

0

answers

25

views

Striped SQL Backup - Benefits [on hold]

sql-server backup

asked 15 hours ago Kris 5

0

votes

1

answer

11

views

How to prevent a record from being affected by the ORDER BY RAND statement in MYSQL

mysql php phpmyadmin mysqli

answered 13 hours ago Rick James 44.9k

2

votes

2

answers

32

views

Job Information - When querying [msdb].[dbo].SYSJOBS_VIEW through linked server

sql-server query linked-server

answered 15 hours ago Kin Shah 54.6k

7

votes

2

answers

270

views

Covering index used despite missing column

index innodb mariadb covering-index

modified yesterday Tom 150

0

votes

0

answers

22

views

Is a relation with 2 attributes always in BCNF?

normalization relations

asked 16 hours ago PS Nayak 1

1

vote

0

answers

13

views

SQL Server Database auditing not working

sql-server azure azure-sql-managed-instance

asked 14 hours ago PatrickSteele 125

0

votes

0

answers

20

views

Mysql ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

mysql mysql-5.7 solaris

modified 3 hours ago Paul White♦ 56.1k

1

vote

1

answer

32

views

Deduplication/normalization of string column on insert

database-design normalization sqlite

modified 2 hours ago Lennart 13.7k

-2

votes

1

answer

38

views

Query syntax error [on hold]

sql-server syntax

modified yesterday Paul White♦ 56.1k

2

votes

1

answer

46

views

When do Azure SQL Database index rebuilds occur?

configuration azure-sql-database index-maintenance

modified 16 hours ago Shanky 15.3k

8

votes

1

answer

58

views

initdata: No memory for kernel buffers

sql-server linux sql-server-2019

answered 14 hours ago Max Vernon 53.8k

0

votes

1

answer

16

views

How to increase size of temp tablespace in Oracle 12C RAC with ASM?

oracle-12c rac

modified 3 hours ago Gryu 21

1

vote

1

answer

19

views

SQL sort by sum of two different where clauses in a join

sql-server mysql pivot

answered 18 hours ago Raymond Nijland 811

1

vote

1

answer

12

views

Using plpgsql to remove all functions

postgresql plpgsql

modified 19 hours ago kumom 18

0

votes

1

answer

59

views

In Oracle 12c trying to create table with columns greater than 4000

oracle oracle-12c configuration

modified 19 hours ago djfkc 1

0

votes

2

answers

80

views

Background Index Creation on SQL Server

sql-server sql-server-2017 azure-vm

modified yesterday Paul White♦ 56.1k

0

votes

1

answer

32

views

How to query results from a huge postgres database?

postgresql postgresql-performance count distinct

modified yesterday Paul White♦ 56.1k

6

votes

2

answers

865

views

How can I restore a master database from its bak file?

sql-server restore master-system-database

answered yesterday Marcel Klein 11

2

votes

0

answers

11

views

How to Configure SSRS Web Service Port via Command Line

windows-server-2012 ssrs-2014

asked 20 hours ago Shoeless 282

13

votes

3

answers

1k

views

SQL Server has encountered occurences of I/O requests taking longer than 15 seconds

performance performance-tuning sql-server-2017 storage

modified yesterday bokan 167

1

vote

1

answer

70

views

How to optimize a MySQL joining to itself?

mysql query-performance mysql-5.7

modified yesterday Paul White♦ 56.1k

0

votes

0

answers

13

views

display data from database query in Java Jtable [on hold]

sql-server java

asked 22 hours ago Alice Carter 1

0

votes

0

answers

11

views

Postgres count the same join by different values

postgresql join aggregate self-join

asked 21 hours ago ChristopherJ 212

5

votes

1

answer

211

views

Does Service pack have all the changes in a cumulative update

sql-server sql-server-2016 patching

modified yesterday George.Palacios 3,354

0

votes

1

answer

20

views

How to get dates from a table while the date range is from the date belonging to another table?

mysql query mysql-workbench

answered yesterday KevH 1

-3

votes

0

answers

23

views

how to remove the same value in SequenceNO column [on hold]

sql-server

modified yesterday a_horse_with_no_name 43k

-1

votes

1

answer

54

views

Truncate multiple tables after finding those tables using a select query

sql-server sql-server-2012

modified 20 hours ago Scott Hodgin 18.7k

3

votes

1

answer

42

views

What kind of database is this schema for, and how can I open it?

export embedded

modified yesterday Paul White♦ 56.1k

Top Questions

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