Top Questions

3 votes
2 answers
3k views

Are views logically redundant?

3 votes
2 answers
243 views

What is the effect of using different COLLATE values in a WHERE clause?

3 votes
2 answers
180 views

Snowflake won't allow an analytic function to be renamed

2 votes
2 answers
173 views

What SQL Server server-level roles allow you to add users to database-level roles?

3 votes
1 answer
170 views

Finding all the index corruptions in the entire Postgres DB

2 votes
2 answers
93 views

Finding encrypted SQL database instances in our SQL Server Estate

1 vote
2 answers
104 views

Prevent users from sending an email attachment in sql server

-1 votes
1 answer
49 views

When patching SQL FCI, how to ensure there will not be a failover to the node being patched?

1 vote
1 answer
62 views

how can I see how many records have been affected by a transaction before it is committed? or how costly would be the rollback if I have to kill it?

1 vote
1 answer
53 views

What foreign key should I store from users table or clients table?

1 vote
0 answers
84 views

SSMS User Mapping Slow to Load, or Not Responding

-1 votes
1 answer
65 views

MySQL design and best design practices

2 votes
1 answer
39 views

Query for single return meeting multiple criteria and values

0 votes
1 answer
60 views

SQL Server - moving databases to an earlier version - options

0 votes
2 answers
56 views

Finalize GroupAggregate parent using Partial HashAggregate child nodes in Postgres query plan

0 votes
1 answer
43 views

Cannot disable Query store due to QUERY STORE ASYNC LOAD

-1 votes
1 answer
42 views

Relational Algebra Practice Question

-1 votes
0 answers
69 views

Using R and Python with SQL Server 2022 not possible

0 votes
1 answer
50 views

How to set Account for SQL Server service in configuration file?

user avatar
1 vote
0 answers
63 views

SQL Server not using index in aggregates [closed]

0 votes
1 answer
38 views

ORA-19504: failed to create file "bh2jk0h7_1_1"

0 votes
0 answers
61 views

A SQL Query without Key Lookups takes 5-30 seconds to execute

1 vote
1 answer
126 views

Performance degradation after migrating from SQL Server 2016 to SQL Server 2022

1 vote
1 answer
46 views

Can the plan cache be used to diagnose a lack of RAM?

0 votes
1 answer
31 views

Why a consistent backup still requery recovery in Oracle?

0 votes
1 answer
50 views

Is my schema "correct"?

0 votes
1 answer
45 views

how to get explain plan from pl/sql function call?

0 votes
2 answers
55 views

SQL Developer edtion as a new node within an Enterprise Availability Group

-2 votes
1 answer
33 views

Best Practice for full backup and transaction log truncation [closed]

0 votes
0 answers
42 views

How can I check the current memory management mode for an oracle database instance?

0 votes
0 answers
41 views

Probably missing something simple, source of ERROR 1146 (42S02): Table doesn't exist error

0 votes
0 answers
41 views

Are SERIALIZABLE deadlocks avoided or just detected?

0 votes
1 answer
41 views

Can I password protect a specific ms sql database view?

0 votes
2 answers
41 views

Point in time Postgres restore

0 votes
2 answers
40 views

Mysql count Same Two or More Same Record as One and Summarize It

0 votes
1 answer
31 views

Cassandra nodes show other nodes as unreachable

0 votes
2 answers
29 views

PostgreSQL16 on Windows - Clean up pg_wal archive location

0 votes
0 answers
37 views

Can my database LDF and MDF files go into this directory?

0 votes
0 answers
36 views

invalid username/password; logon denied with kerberos authentication

0 votes
1 answer
28 views

Ideal VLF size - SQL Server transaction log

0 votes
0 answers
35 views

Why reading data in Postgres requires lock?

0 votes
2 answers
27 views

Select random records until a cumulative total is exceeded

1 vote
2 answers
34 views

Merging information from multiple rows into one row

0 votes
1 answer
34 views

Postgres: how to insert and delete many records and to not run out of space

0 votes
2 answers
26 views

PostgreSQL plan cache and variable number of arguments

0 votes
1 answer
33 views

Oracle 19c and 21c expdp exports dumpfile of 308kb without any content

-2 votes
1 answer
33 views

What's your "best" backup strategy for multi-hundred-gb tables?

user avatar

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