Top Questions

Active Hot Week Month

4 votes

2 answers

372 views

@@SERVERNAME Consistency in 3 node SQL Availability Group

39.2k

answered Nov 3 at 14:36

5 votes

1 answer

680 views

Allow non-sysadmin to gain access to DB

39.2k

answered Nov 5 at 15:58

4 votes

1 answer

371 views

Identify user who performed last_user_update in SQL Server

6,511

modified Nov 6 at 12:12

4 votes

1 answer

328 views

Is it possible to stripe backups going to Azure Blob Storage?

39.2k

modified Nov 5 at 20:09

2 votes

1 answer

372 views

Do canary tables make sense for Availability Groups?

39.2k

answered Nov 15 at 18:25

1 vote

1 answer

208 views

Log file AutoGrow Cancelled/timed out

10.1k

modified Oct 28 at 21:42

1 vote

2 answers

223 views

Use column default value for optional parameter in stored procedure

Peter Vandivier

5,951

modified Oct 29 at 1:50

0 votes

2 answers

135 views

SSMS Noob Error: The query references an object that is not supported in distributed processing mode

88.7k

answered Oct 31 at 15:59

2 votes

1 answer

222 views

BULK INSERT from a CSV file not working

39.2k

modified Nov 18 at 13:01

0 votes

2 answers

126 views

SQL Server 2019 (v15) : tempdb related files eat up about 80 GB on C disk, how to make it small and free up some space in C

19k

answered Oct 29 at 15:16

4 votes

1 answer

133 views

How can I tell which tables, indexes, or pages do not have checksums?

18.1k

answered Nov 10 at 15:12

4 votes

1 answer

113 views

Querying sys.databases in a peculiar way results in "transport-level error has occurred when receiving results from the server" error

33.2k

modified 2 hours ago

3 votes

1 answer

119 views

MERGE causes unique constraint violation when source contains key multiple times

18.1k

modified Nov 21 at 11:12

2 votes

1 answer

90 views

RDS - connect to HA Secondary without joining domain

39.2k

answered Nov 7 at 23:24

3 votes

1 answer

70 views

sqlcmd truncating "text" type column

39.2k

answered Nov 10 at 18:20

1 vote

1 answer

69 views

Semantic search database installed but not functional

6,511

modified Nov 1 at 11:18

5 votes

0 answers

106 views

Could BEGIN/END really be used inside CASE in SQL Server 2005?

692

asked Nov 21 at 12:49

2 votes

1 answer

82 views

Stale View Metadata on AlwaysOn Secondary Replica After Table Re-creatio

18.1k

answered Nov 18 at 13:33

3 votes

1 answer

76 views

What is the maintenance on the index caused by insert, update, or delete operations?

6,511

modified Nov 6 at 12:06

0 votes

1 answer

39 views

SQL Server encrypting backup with a certificate failed with "Cannot find server certificate with thumbprint..."

39.2k

answered Nov 10 at 21:00

0 votes

2 answers

60 views

How to resolve "phantom" tables in the tablespace?

269

modified Nov 3 at 9:07

1 vote

2 answers

57 views

Safe process to update production data?

17.3k

modified Nov 21 at 22:11

0 votes

2 answers

56 views

PLSQL query to return the trackingcodes only if all its cashout_trackingcodes belong exclusively to that trackingcode

1,502

modified Nov 17 at 10:00

0 votes

1 answer

54 views

Why does READ COMMITTED allow Phantom Reads in PostgreSQL?

62.7k

answered Nov 16 at 11:16

0 votes

1 answer

69 views

How can I find the source (hostname, etc.) of one Azure SQL Database query using Extended Events without having to capture every statement?

88.7k

answered Nov 12 at 2:45

-1 votes

1 answer

53 views

Couldn't import excel file in my SQL(SSMS) but the "IMPORT" and "EXPORT" are greyed or faint that it can't be clicked on

21

modified Nov 18 at 19:20

1 vote

1 answer

67 views

How to change password for federated access between two IBM Db2 databases?

28.8k

answered Nov 7 at 13:00

1 vote

2 answers

85 views

MSSQL Performance gain when clearing out (large size) filestore-table records?

Yano_of_Queenscastle

2,001

modified 16 hours ago

0 votes

1 answer

30 views

PostgreSQL:Why promoting standby while primary is online causing WAL fork?

700

modified Nov 11 at 1:21

1 vote

0 answers

78 views

SQL Server Express Master database corrupted tables

6,511

modified Nov 17 at 10:22

0 votes

1 answer

47 views

MSSQL RESTORE WITH STOPAT doesn't stop

129

answered Nov 20 at 23:17

0 votes

2 answers

73 views

How to debug MongoDB recurring error 314 ObjectIsBusy

51

modified Nov 3 at 9:02

-1 votes

0 answers

65 views

Creating a linked Server in SQL 2022

447

asked Nov 18 at 12:08

0 votes

1 answer

50 views

Unable to restart PostgreSQL after automatic shutdown

Sébastien Clément

1,843

modified Nov 14 at 19:34

1 vote

0 answers

64 views

SQLPackage generating unwanted Alter Database commands

39.2k

modified Nov 3 at 12:46

-2 votes

1 answer

30 views

Why am I getting a syntax error running the same code via openrecordset vs. direct connection to remote server

19k

modified Nov 14 at 10:15

-1 votes

1 answer

48 views

Access denied for user to a database?

433

modified yesterday

0 votes

1 answer

46 views

MariaDB --skip-grant-tables --skip-networking appears to remain despite removal from cnf files

17.3k

modified Oct 30 at 15:14

0 votes

1 answer

54 views

Automatically transfer all data from postgres server to another remote server

Luís Felipe Araujo de Oliveira

1

modified Nov 12 at 15:14

1 vote

1 answer

54 views

Safely update parts of JSON data stored in SQLite, OCC

1,044

answered Nov 6 at 14:38

0 votes

1 answer

53 views

Adding Indexes with type "VECTOR" to Table takes a LOOOONG time

8,333

modified 1 hour ago

0 votes

1 answer

32 views

Enabled always statement level trigger on logical replication target does not seem to fire

3,992

answered Oct 31 at 13:15

0 votes

0 answers

50 views

Optimise "Virtual Keys" in PostgreSQL Views

17.3k

modified Oct 31 at 15:41

0 votes

0 answers

50 views

How to use the same subquery in both queries for UNION

2,168

modified Nov 5 at 8:09

0 votes

1 answer

49 views

how to solve SQLSTATE[HY000] [2002] Permission denied on localhost mariaDB 10.11.14

269

modified Oct 29 at 9:09

0 votes

1 answer

49 views

Unable to Delete Database - Chunks Stuck in "Recovering" State

16

answered Nov 17 at 6:21

0 votes

1 answer

38 views

Monitoring PostgreSQL Copy Operations

62.7k

modified Nov 12 at 9:49

-2 votes

0 answers

48 views

FOR XML PATH, subqueries, sequential ids [closed]

377

modified Nov 16 at 0:41

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