Nice Answer - Badge - Database Administrators Stack Exchange

Nice Answer

Answer score of 10 or more. This badge can be awarded multiple times.

Awarded 7259 times.

MS SQL Server DB Transaction Log Growth Rate

Awarded 3 hours ago

Zikato

2,31510 silver badges23 bronze badges

Postgres full text search on words, not lexemes

Awarded yesterday

Erwin Brandstetter

156k19 gold badges385 silver badges528 bronze badges

Does VACUUM FULL need ANALYZE

Awarded Sep 27 at 9:51

Daniel Vérité

28k3 gold badges63 silver badges73 bronze badges

How to reduce the log file size without shrinking it in SQL server

Awarded Sep 26 at 9:55

RThomas

3,3164 gold badges24 silver badges46 bronze badges

What's the use case of disabling an index?

Awarded Sep 26 at 9:42

AMtwo

15.1k1 gold badge27 silver badges60 bronze badges

How does SQL Server update lock work?

Awarded Sep 23 at 13:34

Paul White♦

73.8k26 gold badges381 silver badges596 bronze badges

Does killing an application kill the SQL connection?

Awarded Sep 23 at 0:41

Charlieface

7,6914 silver badges26 bronze badges

Error 1366: Incorrect string value: '\xF0\x9F\x98\x8A\x0AC…' for column 'text_body' at row 1

Awarded Sep 22 at 21:46

Rick James

70.4k4 gold badges40 silver badges97 bronze badges

Does killing an application kill the SQL connection?

Awarded Sep 22 at 21:02

Josh Darnell

27.7k5 gold badges61 silver badges113 bronze badges

Function Performance

Awarded Sep 22 at 12:06

Scott Marlowe

1,72111 silver badges13 bronze badges

Unique constraint to enforce max one null per item

Awarded Sep 22 at 11:47

a_horse_with_no_name

73.2k13 gold badges145 silver badges181 bronze badges

SSRS error "something went wrong please try again later" in web portal

Awarded Sep 21 at 14:15

Bartosz X

4831 gold badge4 silver badges17 bronze badges

Is there a way to insert multiple rows into a table with default values for all columns?

Awarded Sep 21 at 12:42

ypercubeᵀᴹ

93.8k13 gold badges197 silver badges293 bronze badges

Logon failed for login due to trigger execution

Awarded Sep 14 at 15:52

John K. N.

15.4k10 gold badges43 silver badges97 bronze badges

MySQL - UUID/created_at cursor based pagination?

Awarded Sep 13 at 15:30

Rick James

70.4k4 gold badges40 silver badges97 bronze badges

What is the SQL server mechanism to ensure that the page being restored isn't corrupted?

Awarded Sep 12 at 13:40

John K. N.

15.4k10 gold badges43 silver badges97 bronze badges

Restarting identity columns in Postgresql

Awarded Sep 10 at 18:25

a_horse_with_no_name

73.2k13 gold badges145 silver badges181 bronze badges

Select * Order by vs Select column Order by performance

Awarded Sep 10 at 7:57

J.D.

26.5k5 gold badges40 silver badges88 bronze badges

How to create intervals of 100 based on a column in a query?

Awarded Sep 10 at 7:57

Philipp Salvisberg

2412 silver badges5 bronze badges

What is the SQL server mechanism to ensure that the page being restored isn't corrupted?

Awarded Sep 10 at 6:16

Dominique Boucher

2,9897 silver badges22 bronze badges

How to connect to oracle 12c from sqlplus without password in command line

Awarded Sep 9 at 12:43

SHR

8142 gold badges13 silver badges31 bronze badges

Character varying index overhead & length limit

Awarded Sep 9 at 10:49

Erwin Brandstetter

156k19 gold badges385 silver badges528 bronze badges

How to use composite index in range query in mysql

Awarded Sep 9 at 3:36

ypercubeᵀᴹ

93.8k13 gold badges197 silver badges293 bronze badges

How to give a user "create any database" permission in SQL Server?

Awarded Sep 8 at 22:17

Paul White♦

73.8k26 gold badges381 silver badges596 bronze badges

Why is Full Recovery model a requirement for an Availability Group?

Awarded Sep 8 at 15:06

Shanky

18.4k4 gold badges32 silver badges55 bronze badges

PostgreSQL is running locally but I cannot connect. Why?

Awarded Sep 8 at 13:31

Daniel Vérité

28k3 gold badges63 silver badges73 bronze badges

Oracle With Statement and Delete Together

Awarded Sep 7 at 19:21

Vincent Malgrat

4,36415 silver badges21 bronze badges

Error: MySQL shutdown unexpectedly

Awarded Sep 7 at 17:27

User_beginner

1111 silver badge3 bronze badges

Can I be automatically notified of prolonged blocking in SQL server?

Awarded Sep 6 at 13:28

Remus Rusanu

51.1k3 gold badges91 silver badges170 bronze badges

Can declaring function volatility IMMUTABLE harm performance?

Awarded Sep 6 at 1:27

Erwin Brandstetter

156k19 gold badges385 silver badges528 bronze badges

how to check list of users present in all postgres database

Awarded Sep 5 at 7:42

a_horse_with_no_name

73.2k13 gold badges145 silver badges181 bronze badges

Materialized views Performance

Awarded Sep 2 at 3:17

Erwin Brandstetter

156k19 gold badges385 silver badges528 bronze badges

What is the benefit of indexing assuming that SQL server has huge memory to accomodate the entire database in memory?

Awarded Sep 1 at 17:25

Michael Green

23.6k12 gold badges48 silver badges94 bronze badges

What is the benefit of indexing assuming that SQL server has huge memory to accomodate the entire database in memory?

Awarded Sep 1 at 14:50

Paul White♦

73.8k26 gold badges381 silver badges596 bronze badges

Get SSRS Datasources from ReportServer

Awarded Sep 1 at 14:41

Cody Konior

3,44811 silver badges19 bronze badges

What actually is a SQL clause?

Awarded Sep 1 at 13:26

RDFozz

11.5k4 gold badges21 silver badges37 bronze badges

Availability Group how to determine last Failover time

Awarded Sep 1 at 12:41

DonB

1011 silver badge2 bronze badges

Why is SSIS slow to enumerate over many files in a directory and import them?

Awarded Sep 1 at 11:55

billinkc

15.6k4 gold badges48 silver badges88 bronze badges

How can I fake inet_client_addr() for unit tests in PostgreSQL?

Awarded Aug 30 at 20:57

Erwin Brandstetter

156k19 gold badges385 silver badges528 bronze badges

group by and display contents of last row for each result

Awarded Aug 29 at 1:06

ypercubeᵀᴹ

93.8k13 gold badges197 silver badges293 bronze badges

Send Multiple Attachments With Send DBMail

Awarded Aug 28 at 0:30

Randolph West

3,5559 silver badges26 bronze badges

Concurrent transactions result in race condition with unique constraint on insert

Awarded Aug 25 at 17:33

CL.

4,8751 gold badge19 silver badges23 bronze badges

Find specific query in Query Store

Awarded Aug 25 at 6:57

Josh Darnell

27.7k5 gold badges61 silver badges113 bronze badges

SQL function with SELECT vs. PLPGSQL function with RETURN QUERY SELECT?

Awarded Aug 24 at 3:35

Erwin Brandstetter

156k19 gold badges385 silver badges528 bronze badges

cannot insert multiple commands into a prepared statement

Awarded Aug 23 at 17:10

a_horse_with_no_name

73.2k13 gold badges145 silver badges181 bronze badges

In Postgres, how to select by a column of type UUID

Awarded Aug 17 at 20:07

Clint Eastwood

3411 gold badge2 silver badges6 bronze badges

List the database privileges using psql

Awarded Aug 16 at 22:57

stefannienhuis

1211 silver badge3 bronze badges

How to alter system on AWS RDS?

Awarded Aug 16 at 9:50

detzu

3362 silver badges6 bronze badges

Could not obtain exclusive lock on database 'model' - who is using it?

Awarded Aug 16 at 3:55

sepupic

10.4k14 silver badges25 bronze badges

EXEC vs SP_EXECUTESQL Performance

Awarded Aug 15 at 4:03

Aaron Bertrand

177k26 gold badges384 silver badges593 bronze badges

How to run psql on Mac OS X?

Awarded Aug 12 at 17:51

Iurii Perevertailo

2012 silver badges3 bronze badges

Request Sch-M lock on a table

Awarded Aug 12 at 17:02

Paul White♦

73.8k26 gold badges381 silver badges596 bronze badges

Order By causes a scan on a large table

Awarded Aug 10 at 9:56

Martin Smith

78.6k15 gold badges227 silver badges320 bronze badges

How to set statement timeout per user?

Awarded Aug 10 at 2:40

Erwin Brandstetter

156k19 gold badges385 silver badges528 bronze badges

Non-yielding IOCP Listener

Awarded Aug 8 at 13:43

StrayCatDBA

2,01315 silver badges21 bronze badges

NULL values appear when taking the sum of two columns taken from Lookup tables

Awarded Aug 8 at 4:56

Sabin B

3,8661 gold badge16 silver badges22 bronze badges

Retrieving all PK and FK

Awarded Aug 6 at 23:07

Evgeny Nozdrev

4331 gold badge4 silver badges8 bronze badges

Order By causes a scan on a large table

Awarded Aug 5 at 19:17

Erik Darling

34.4k13 gold badges120 silver badges310 bronze badges

Pros and cons of row level security Microsoft SQL Server

Awarded Aug 4 at 17:57

zedfoxus

2813 silver badges5 bronze badges

Connect to SQL Server without specifying port

Awarded Aug 4 at 17:33

Ste Bov

1,99110 silver badges17 bronze badges

2 3 4 5

…

121 Next