Cleanup - Badge - Database Administrators Stack Exchange

Cleanup

First rollback.

Awarded 337 times.

How do I list all schemas in PostgreSQL?

Awarded 5 hours ago

Super Kai - Kazuya Ito

1257 bronze badges

Using Kerberos Constrained Delegation with an ADSI Linked Server

Awarded Aug 21 at 10:31

DamonDCD

716 bronze badges

How can I make (game_id, user_id) unique, yet (game_id, score) indexed/clustered, in ScyllaDB?

Awarded Jul 18 at 8:10

Nuno

8091 gold badge8 silver badges21 bronze badges

XML datatype instance has too many levels of nested nodes. Maximum allowed depth is 128 levels

Awarded Jul 5 at 18:47

Marcello Miorelli

15.7k51 gold badges153 silver badges283 bronze badges

How to create alias in SQL Server 2022

Awarded Jun 26 at 14:47

Tom Pažourek

3933 silver badges18 bronze badges

Awarded May 22 at 21:15

Aashishkebab

1413 bronze badges

How prepare and transfer database from mysql 5.7 to 8.0.19 since mysql_upgrade has been removed

Awarded Apr 25 at 22:40

Quintabug598

114 bronze badges

Indexes and performance

Awarded Mar 27 at 10:41

comment-answers

115 bronze badges

MySQL 8 install doesn't include mysql.exe (Windows). Where to get it from? [closed]

Awarded Mar 22 at 7:04

Buffalo

1014 bronze badges

When does Oracle still treat empty strings as NULL?

Awarded Mar 19 at 7:17

Balazs Papp

39.8k2 gold badges24 silver badges44 bronze badges

Apache Cassandra 3.11.2 unable to start Centos 7

Awarded Feb 23 at 6:04

Dmitrij

235 bronze badges

Change Tracking across several Tables

Awarded Feb 22 at 9:28

Obsidian Phoenix

4234 silver badges17 bronze badges

Mirroring Databases in MySQL

Awarded Feb 8 at 9:32

Lloyd Banks

8823 gold badges9 silver badges15 bronze badges

Avoiding deadlocks when locking multiple rows without using NOWAIT

Awarded Feb 6 at 20:57

ChrisJ

5811 gold badge6 silver badges20 bronze badges

(post deleted or otherwise unavailable)

Awarded Feb 4 at 14:21

Edward Hayrabedian

415 bronze badges

dbatools, DbcCheck Does not use Saved credential

Awarded Feb 3 at 16:17

kedar

234 bronze badges

(post deleted or otherwise unavailable)

Awarded Dec 28, 2022 at 14:32

Alexanderd Degterev

11 bronze badge

(post deleted or otherwise unavailable)

Awarded Dec 25, 2022 at 19:49

Supertwister

12 bronze badges

PgSql: how could I achive a group by that checks any match on any of two columns?

Awarded Oct 29, 2022 at 23:04

J Pablo F

517 bronze badges

Why does an inequality search on an indexed column give constant scans

Awarded Sep 21, 2022 at 8:37

Charlieface

11.4k11 silver badges34 bronze badges

Delete but keep x amount of rows per input

Awarded Jul 2, 2022 at 11:48

Robin Jonsson

1437 bronze badges

Will SQLNET.EXPIRE_TIME=5 prevent AWS Gateway Load Balancer from timing out after 350 seconds?

Awarded Jun 15, 2022 at 23:12

Bobby Durrett

2212 silver badges10 bronze badges

(post deleted or otherwise unavailable)

Awarded Mar 16, 2022 at 22:18

Tautvydas Adomavičius

12 bronze badges

Expanding existing column results in 'minimum row size would be XXXX' error, but creating a new table with the desired data length does not

Awarded Mar 2, 2022 at 20:16

AMtwo

16.1k1 gold badge30 silver badges61 bronze badges

Populating an Oracle database, using GCC or TOC, does anybody know this?

Awarded Feb 24, 2022 at 13:06

J.D.

34k8 gold badges47 silver badges108 bronze badges

How can I mimic full outer join in mysql with multiple columns

Awarded Feb 16, 2022 at 9:57

user3069332

33 bronze badges

How to recompile all stored procedures and table valued functions in SQL Server database?

Awarded Jan 14, 2022 at 23:48

SQL Police

3635 silver badges12 bronze badges

Update query with nested subquery

Awarded Oct 5, 2021 at 3:55

Upali Wijeratne

114 bronze badges

(post deleted or otherwise unavailable)

Awarded Oct 3, 2021 at 13:30

bharathi m

134 bronze badges

(post deleted or otherwise unavailable)

Awarded Sep 20, 2021 at 21:40

John

14 bronze badges

OBJECT_ID(...) function vs join on sys.tables and sys.schemas

Awarded Sep 17, 2021 at 21:04

mv ٠〳comment ٠〳answer

6923 silver badges10 bronze badges

Does WITH SCHEMABINDING on a multi-statement TVF improve cardinality estimates?

Awarded Aug 15, 2021 at 14:56

Glorfindel

2,1815 gold badges17 silver badges26 bronze badges

Should arrays of IDs stored in Postgres use varchar, int, or another type?

Awarded Jul 20, 2021 at 0:42

tim-montague

1013 bronze badges

Where to download SQL Server 2019 Express LocalDB Installer MSI from

Awarded Jun 29, 2021 at 11:06

Ivan Zlatanov

4464 silver badges5 bronze badges

Insert into table if column <> "Text" for each project

Awarded May 7, 2021 at 12:07

user229088

263 bronze badges

Does postgres optimise repeated expressions?

Awarded Apr 28, 2021 at 21:38

Tobi Akinyemi

1837 bronze badges

Binlog commits and flushes on SQL Server (compared to MySQL)

Awarded Apr 27, 2021 at 7:13

Halfgaar

19114 bronze badges

Management Data Warehouse SQL Server data collection reports [closed]

Awarded Apr 25, 2021 at 13:59

user1930901

3491 gold badge7 silver badges16 bronze badges

How to exclude the id in My Store procedure, when status change [closed]

Awarded Apr 19, 2021 at 9:42

Aakhash

32 bronze badges

Are SQL unit tests supposed to be so long?

Awarded Apr 7, 2021 at 14:35

IvanLoginov

1036 bronze badges

Unable to understand correlation between MaxWorkers created and CPU utilization

Awarded Mar 20, 2021 at 17:57

Ronaldo

5,0391 gold badge11 silver badges40 bronze badges

Can you index on a field that isn't in your table?

Awarded Mar 15, 2021 at 18:47

James

2,6125 gold badges25 silver badges48 bronze badges

22046 "Impersonation error" running SQL Server Agent job

Awarded Mar 13, 2021 at 13:30

Paul Suart

1015 bronze badges

Clean Code - On which side to place the key

Awarded Feb 16, 2021 at 0:33

Gayani

1012 bronze badges

(post deleted or otherwise unavailable)

Awarded Jan 13, 2021 at 19:27

Vishal

12 bronze badges

(post deleted or otherwise unavailable)

Awarded Oct 19, 2020 at 11:06

Mihai Cristian

36 bronze badges

(post deleted or otherwise unavailable)

Awarded Oct 16, 2020 at 1:25

var

13 bronze badges

calculate running balance of debit credit using union all

Awarded Sep 7, 2020 at 6:51

NikitaSerbskiy

2,0281 gold badge6 silver badges13 bronze badges

Using NEW on tables with generated columns

Awarded Aug 25, 2020 at 10:12

Micael

335 bronze badges

Results are varying with same query

Awarded Jul 24, 2020 at 18:32

humberto herrara

731 gold badge1 silver badge8 bronze badges

how to count second col if first col value is null and avoid duplicate count

Awarded Jun 24, 2020 at 11:05

Osama Rizwan

1091 silver badge7 bronze badges

How do I move SQL Server database files?

Awarded May 24, 2020 at 12:45

abhay sreekumar

911 silver badge4 bronze badges

(post deleted or otherwise unavailable)

Awarded May 21, 2020 at 17:21

Ravul

12 bronze badges

Differences between .out and .sql in pg_dump PostgreSQL

Awarded Apr 8, 2020 at 18:00

ncica

1134 bronze badges

postgresql cumulative counts in date range

Awarded Mar 22, 2020 at 22:25

jacaetevha

12 bronze badges

Stored Procedure null parameter within where clause

Awarded Feb 29, 2020 at 23:10

Weihui Guo

1511 gold badge2 silver badges12 bronze badges

(post deleted or otherwise unavailable)

Awarded Feb 27, 2020 at 6:20

Shailendra Mishra

12 bronze badges

SQL Server Encrypted Connections - Configuration Manager does not see Certificate

Awarded Feb 26, 2020 at 16:25

Aleksey Vitsko

5,3025 gold badges31 silver badges60 bronze badges

(post deleted or otherwise unavailable)

Awarded Feb 16, 2020 at 6:15

user3198603

3891 gold badge5 silver badges14 bronze badges

(post deleted or otherwise unavailable)

Awarded Feb 9, 2020 at 18:35

Peter Vandivier

4,5211 gold badge22 silver badges44 bronze badges

2 3 4 5 6 Next