Skip to main content
OverflowAI is here! AI power for your Stack Overflow for Teams knowledge community. Learn more

Top Questions

21 votes
2 answers
5k views

Why is COALESCE not a function?

2 votes
3 answers
1k views

MariaDB / MariaBackup : What is the best way to export/migrate a 700GB table to another server, but with only 200GB of free space at the origin?

9 votes
1 answer
631 views

Extra NESTED LOOP / INNER JOIN causing NO JOIN PREDICATE warning

1 vote
2 answers
801 views

Why does the SERIALIZABLE transaction isolation level not guarantee point-in-time views of data?

3 votes
1 answer
387 views

"#1292 - Incorrect datetime value" when time is within one hour

0 votes
3 answers
130 views

Can using UPDLOCK and ROWLOCK help me fight of deadlocks in my situation?

2 votes
1 answer
480 views

Most efficient way to UPDATE a billion rows in AWS Aurora PostgreSQL?

0 votes
1 answer
118 views

Why is COMPATIBILITY_LEVEL: 160 using Clustered Index Scan?

2 votes
1 answer
149 views

Granting SELECT...INTO permissions

3 votes
1 answer
222 views

What exact error messages do UMPPC*.DLL and SCRIPTCONTROL*.DLL cause SQL Server Agent when it fires SSIDB packages?

4 votes
2 answers
75 views

How do I fully qualify event predicates for [backup_restore_progress_trace] Extended Events?

-1 votes
1 answer
107 views

Can AWS services replace SQL Server Agent Jobs?

4 votes
1 answer
188 views

Advisory locks: private to connected database or shared across cluster?

2 votes
2 answers
241 views

Can't restore SQL Server database

4 votes
2 answers
128 views

Index seeks and predicate push down

2 votes
1 answer
198 views

Why there is huge gap between allocated and used size in a database

0 votes
2 answers
88 views

SQL Server database size is 10GB but tables are only around 450MB, what is occupying the rest and how can I reduce it?

6 votes
1 answer
84 views

Running sp_repldone on a secondary node of an Availability Group with @reset = 1 not working

1 vote
4 answers
92 views

are my expectations for mysql unrealistic?

3 votes
1 answer
113 views

Is Analysis Services DMV query executing "on server" or "on database"

3 votes
1 answer
75 views

What does SQL Server's Error Log actually log?

1 vote
3 answers
118 views

Database for large matrix

1 vote
3 answers
85 views

Decreasing execution time of insert and deletes in SQL Server

-2 votes
1 answer
66 views

Why should I write SQL code with uppercased keywords? [closed]

2 votes
1 answer
99 views

Emulate Loose Index Scan for multiple columns with alternating sort direction

0 votes
2 answers
41 views

why sp_ExecuteSql output parameter returns null from linked server when procedure shows correct value in results panel

0 votes
2 answers
84 views

Performance issue - using try catch to return data to service & how to use partition table with unique index

2 votes
2 answers
85 views

Execute `sp_spaceused` only for all databases

1 vote
2 answers
137 views

Mysql query is too slow for what it is, help me debug it

0 votes
1 answer
50 views

Does client timeout send the execution of a stored procedure from the TRY block to the CATCH block?

2 votes
1 answer
81 views

Could not locate statistics in the system catalogs error in SQL Server

0 votes
1 answer
81 views

SQL Server Assertion error On Availability Groups

2 votes
1 answer
79 views

When to rerun CLUSTER?

1 vote
1 answer
74 views

Error: unable to find network path in Microsoft SQL Server Management Studio

2 votes
1 answer
57 views

Should I delete index before bulk-loading data with COPY?

1 vote
1 answer
88 views

Split intervals with two tables

-1 votes
1 answer
53 views

How is basic availability group able to auto failover without a cluster?

0 votes
2 answers
53 views

Restore local database backup to remote server

-1 votes
1 answer
64 views

Does anyone have a resolution for this: metadata is inconsistent error when restoring a backed up database to a higher level SQL server

-1 votes
1 answer
81 views

Using CURRENT_USER in Dynamic SQL Adds a Dot to the End of the Username [closed]

-1 votes
3 answers
49 views

How are columnar databases faster for querying?

-1 votes
1 answer
38 views

AlwaysOn Availability Secondary replica not work as read only

0 votes
1 answer
37 views

Number of Real Months Between Two Dates

1 vote
2 answers
47 views

Access a MySQL storage with two independent instances [closed]

0 votes
1 answer
46 views

Run TSQL alter db set trustworthy on multiple times

0 votes
1 answer
45 views

Will a 2-node windows server failover cluster go down if the disk witness owner crashes?

1 vote
2 answers
45 views

Insert missing rows after counting by group

0 votes
1 answer
57 views

How to generate a user-defined array of numbers on a given interval a certain number of times


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