Hottest Questions Today

0

votes

3

answers

17

views

Could not allocate space for object sql server

sql-server

modified 34 mins ago scsimon 1,877

1

vote

2

answers

20

views

MS SQL Server Error 18456 after database move

answered 1 hour ago Shekar Kola 345

0

votes

1

answer

19

views

Matching records that fall into same date range

sql-server

answered 1 hour ago Akina 6,853

0

votes

3

answers

12

views

Pairing Row Values in Any Order

unique-constraint

modified 1 hour ago Vérace 17.3k

2

votes

0

answers

13

views

Truncate Table locking sys views

sql-server sql-server-2014 truncate snapshot-isolation

asked 2 hours ago Jamie Marshall 150

2

votes

1

answer

29

views

Which are the downsides of not deleting the CDC records in change tables?

sql-server replication change-data-capture

modified 2 hours ago scsimon 1,877

5

votes

2

answers

67

views

IndexOptimize - Configuration

sql-server maintenance ola-hallengren

modified 5 hours ago Andriy M 17.2k

0

votes

1

answer

21

views

Improve speed of COPY COMMAND in postgres

postgresql postgresql-performance copy

modified 5 hours ago Laurenz Albe 2,581

0

votes

1

answer

13

views

InnoDB vs MyISAM vs OThers for Huge Table [on hold]

mysql innodb myisam

answered 1 hour ago Rick James 46.8k

0

votes

0

answers

13

views

PostgreSQL 10 not allowing remote connection

postgresql connectivity postgresql-10

modified 2 hours ago Laurenz Albe 2,581

0

votes

1

answer

14

views

Select all columns from table but apply function to 1 column

postgresql

modified 1 hour ago a_horse_with_no_name 45.8k

0

votes

2

answers

40

views

How to write an sql database to a file? [on hold]

mysql dbms

modified 3 hours ago Ross 11

0

votes

2

answers

29

views

How can I update the roles for all logins using T-SQL?

t-sql ssms

answered 5 hours ago KevH 301

0

votes

0

answers

22

views

Dimension attribute with one-to-many relationship

sql-server ssis data-warehouse dimensional-modeling

modified 5 hours ago Amira Bedhiafi 106

0

votes

1

answer

18

views

Table design - parent with always exactly 1 or 2 children

database-design schema

answered 5 hours ago Kayaman 143

1

vote

1

answer

18

views

How to get all records where a joined column contains some value (at least once)

mysql

modified 4 hours ago David 8

0

votes

1

answer

25

views

Does Data Migration Advisor migrate system databases?

sql-server-2012 sql-server-2016 ssms migration system-databases

answered 4 hours ago LowlyDBA 7,603

0

votes

1

answer

15

views

Postgres PITR: Recovery does not seem to fetch from Archive Dir

postgresql

answered 6 hours ago Laurenz Albe 2,581

0

votes

1

answer

26

views

Which rights to grant for controlling an SQL Server Availability Group?

sql-server permissions availability-groups sp-askbrent

modified 9 hours ago Shekar Kola 345

0

votes

0

answers

15

views

PostgreSQL - Update not working inside function

postgresql postgresql-10

asked 7 hours ago Stavros Argyrou 1

0

votes

2

answers

43

views

Schedule Full, Differential and Transnational Backup in SQL Server 2016

sql-server-2016 sql-server-agent

modified 3 hours ago lili 3

0

votes

0

answers

13

views

How do I make the RPO (recovery point target) of the database is one minute when I perform the backup through RMAN?

oracle-12c rman disaster-recovery

modified 8 hours ago ypercubeᵀᴹ 80.6k

1

vote

0

answers

37

views

Tool to migrate data to another database with different object names [on hold]

sql-server oracle migration

modified 10 hours ago George K 1,251

-2

votes

0

answers

33

views

I need to add a new condition in between subquery to compare two tables id and include the matching ids data [on hold]

postgresql subquery

modified 7 hours ago akhilesh kedarisetty 1

0

votes

1

answer

30

views

How get in SQL pairs of connections in a FW Logs

vertica

modified 1 hour ago a_horse_with_no_name 45.8k

6

votes

2

answers

345

views

Turn TDE off when restoring SQL databases

sql-server transparent-data-encryption

modified 23 hours ago BradC 6,742

0

votes

1

answer

21

views

How to get all tables in informix database and their sizes in GB?

informix

answered 4 hours ago jrenaut 26

3

votes

1

answer

210

views

Why can't SQL Server optimizer use foreign key [on hold]

sql-server sql-server-2017 cardinality-estimates

modified 10 hours ago Henrik Alstad 176

1

vote

1

answer

16

views

Change postgres default behavior for connection to database when dbname not supplied

postgresql

modified 2 hours ago mustaccio 11.6k

4

votes

2

answers

130

views

How can I run SQL Server Vulnerability Assessment from a SQL Job?

sql-server sql-server-agent vulnerability-assessment

answered yesterday Scott 171

0

votes

1

answer

45

views

Why are execution plans wildly different when selecting 1000 rows vs 2000?

sql-server sql-server-2016

answered 12 hours ago JShark 31

0

votes

1

answer

11

views

SSRS Security Audit

ssrs

answered 11 hours ago Shekar Kola 345

0

votes

2

answers

25

views

Multiple AGs on same Windows Failover cluster the Listeners don't work properly

sql-server availability-groups

modified 11 hours ago Shekar Kola 345

9

votes

4

answers

1k

views

How do I intentionally fragment a SQL Server Index?

sql-server index clustered-index

answered yesterday Tom V 14.3k

0

votes

1

answer

62

views

Is there a database table design to avoid storing table names in a table?

mysql database-design normalization

modified 11 hours ago Kayaman 143

2

votes

1

answer

38

views

Availability Group Read Only Routing Not Working for SQL Logins

availability-groups sql-server-2017 read-only-routing sql-authentication

answered 11 hours ago voodoo_sh 391

0

votes

1

answer

22

views

tempdb move issue

tempdb

answered 12 hours ago George K 1,251

2

votes

3

answers

26

views

How to get efficient range index scans with multiple columns with different sort order?

postgresql

modified 15 hours ago Laurenz Albe 2,581

-1

votes

1

answer

32

views

Month on Month count to determine variance of table growth

oracle count

answered 6 hours ago Wernfried Domscheit 1,432

5

votes

2

answers

722

views

Infinite loop in CURSOR

t-sql cursors

modified yesterday scsimon 1,877

1

vote

2

answers

40

views

Correct data types for my database

sql-server table

answered 21 hours ago Jon of All Trades 3,596

1

vote

0

answers

32

views

How to make Indexed Views work for SQLCLR?

sql-server materialized-view sql-clr

asked 23 hours ago Pxtl 113

0

votes

1

answer

24

views

Postgres consuming a lot of cpu

postgresql cpu

answered 22 hours ago jjanes 16.5k

5

votes

1

answer

69

views

Restore stuck in ASYNC_IO_COMPLETION

sql-server restore wait-types

answered yesterday Bahtiyar Samet Çoban 371

0

votes

0

answers

18

views

Oracle - clean LOB files - recovering disk space

oracle

asked 22 hours ago Rod 1

2

votes

1

answer

23

views

Saved state for SQL Server Always On on Hyper-V

sql-server sql-server-2016 availability-groups

answered yesterday Max Vernon 55.4k

0

votes

0

answers

21

views

Command runs fine in elevated command prompt, but fails when run in a Windows Task Scheduler task

sql-server t-sql scheduled-tasks

asked 22 hours ago user1596979 1

Top Questions

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