Nice Answer

Nice Answer

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

Awarded 7102 times.

Going out of disk space in the course of querying a postgres database

Awarded 20 hours ago

Evan Carroll

55.7k38 gold badges202 silver badges416 bronze badges

How to escape '%' inside varchar @params for RAISERROR funcion in SQL Server 2012

Awarded yesterday

Ruutsa

2112 silver badges3 bronze badges

Is the system column "ctid" legitimate for identifying rows to delete?

Awarded yesterday

Erwin Brandstetter

151k19 gold badges361 silver badges507 bronze badges

Difference between Physical Reads and Read-Ahead Reads

Awarded yesterday

Paul White♦

69.2k25 gold badges372 silver badges578 bronze badges

Is there a deterministic relation between the page life expectancy and disk IO throughput?

Awarded 2 days ago

sqL_handLe

1,1588 silver badges13 bronze badges

In PostgreSQL URL I can't use a password containing special characters

Awarded 2 days ago

Laurenz Albe

32.2k3 gold badges28 silver badges52 bronze badges

How to create a synonym for a column in SQL Server?

Awarded May 20 at 16:46

Michael Green

22.8k12 gold badges47 silver badges89 bronze badges

How to increase column size in Redshift database tables?

Awarded May 20 at 15:41

enri

2012 silver badges4 bronze badges

What is the difference between a "record" and a "row" in SQL Server?

Awarded May 20 at 4:46

A-K

7,1143 gold badges30 silver badges50 bronze badges

Restore mysql database with different name

Awarded May 19 at 9:32

Sverre

2012 silver badges5 bronze badges

How to view tuples changed in a PostgreSQL transaction?

Awarded May 18 at 11:55

Erwin Brandstetter

151k19 gold badges361 silver badges507 bronze badges

how to find out the `Key Lookups` in the current query plan?

Awarded May 18 at 7:11

Erik Darling

33.4k13 gold badges111 silver badges266 bronze badges

Is it okay to put dots in SQL Server database names?

Awarded May 18 at 2:11

user48235

1011 silver badge2 bronze badges

Query memory grant and tempdb spill

Awarded May 18 at 1:32

Paul White♦

69.2k25 gold badges372 silver badges578 bronze badges

Is Mysql ACID Compliant?

Awarded May 17 at 18:26

David Spillett

30.1k3 gold badges44 silver badges84 bronze badges

How can I create a gapless sequence?

Awarded May 17 at 9:34

Craig Ringer

51.8k3 gold badges140 silver badges178 bronze badges

Can ransomware embed itself in to a SQL backup file?

Awarded May 14 at 5:27

Brendan McCaffrey

2,8801 gold badge3 silver badges26 bronze badges

How to add 1100 columns in SQL Server

Awarded May 13 at 9:05

AMtwo

14.4k1 gold badge26 silver badges57 bronze badges

Can ransomware embed itself in to a SQL backup file?

Awarded May 12 at 19:42

pmdba

2,1452 gold badges4 silver badges9 bronze badges

Do datatypes of columns affect query performance?

Awarded May 12 at 18:25

Erwin Brandstetter

151k19 gold badges361 silver badges507 bronze badges

Always On FCI vs Always On Availability Groups

Awarded May 12 at 0:34

Gavin Belson

2463 silver badges5 bronze badges

Before and After update trigger on same table

Awarded May 11 at 10:22

Dan Guzman

24.2k2 gold badges38 silver badges66 bronze badges

Should I not use camelCase in my column names?

Awarded May 11 at 6:11

Morris de Oryx

7192 silver badges13 bronze badges

Availability Group how to determine last Failover time

Awarded May 11 at 4:56

mashrur

1261 silver badge2 bronze badges

Awarded May 10 at 1:36

Sergey Kalinichenko

2163 silver badges6 bronze badges

SQL Datetime / datetimeoffset(2) comparison & implicit cast wierdness

Awarded May 9 at 15:11

souplex

8131 gold badge8 silver badges10 bronze badges

What does SQL server do with the query output once it is read by the client?

Awarded May 5 at 2:27

Charlieface

5,2142 silver badges20 bronze badges

mysql multi threading for a single query

Awarded May 4 at 21:15

Shlomi Noach

7,2071 gold badge22 silver badges24 bronze badges

How to views all documents in a particular collection of database in MongoDB through mongo Shell?

Awarded May 4 at 13:15

JJussi

5,1531 gold badge12 silver badges18 bronze badges

Optimize MYSQL Select query in large table

Awarded May 3 at 11:56

Andrew Sayer

2,3241 gold badge4 silver badges9 bronze badges

postgres: how can I allow index creation but no table mutations or table drops by the same user?

Awarded May 3 at 7:12

Craig Ringer

51.8k3 gold badges140 silver badges178 bronze badges

Does it make sense to store a couple of Boolean values as array?

Awarded May 3 at 6:41

Erwin Brandstetter

151k19 gold badges361 silver badges507 bronze badges

How to do a minor upgrade of PostgreSQL on Windows, e.g. 9.3.0 to 9.3.1?

Awarded May 3 at 3:17

buzz3791

3861 gold badge2 silver badges13 bronze badges

mysql innodb db full text search FTS_DOC_ID column

Awarded May 2 at 23:43

jkavalik

4,9271 gold badge11 silver badges20 bronze badges

What do the entity-relationship diagram (ERD) symbols used in DBeaver mean?

Awarded May 2 at 0:31

Dawoodjee

4183 silver badges10 bronze badges

psql: fatal database does not exist error

Awarded May 1 at 18:51

joanolo

12.4k7 gold badges31 silver badges62 bronze badges

What does this error mean when doing a pg_restore on a Postgres 9.6.2 database?

Awarded Apr 30 at 15:55

jjanes

31.6k3 gold badges30 silver badges42 bronze badges

SQL Server Error while creating User

Awarded Apr 28 at 14:32

Hannah Vernon♦

67.1k22 gold badges158 silver badges298 bronze badges

Missing Index Not Displaying In Execution Plan

Awarded Apr 28 at 10:10

Ionic

2,16113 silver badges20 bronze badges

How to easily convert utf8 tables to utf8mb4 in MySQL 5.5

Awarded Apr 27 at 15:10

Petr Stastny

1011 silver badge2 bronze badges

DateTime2 and Page Life Expectancy (PLE)

Awarded Apr 27 at 13:36

Joe Obbish

30.3k4 gold badges57 silver badges134 bronze badges

Sort order with numbers as strings

Awarded Apr 26 at 17:31

Paul White♦

69.2k25 gold badges372 silver badges578 bronze badges

SSMS clean output window with sql instruction

Awarded Apr 25 at 21:26

Solomon Rutzky

65.6k6 gold badges136 silver badges268 bronze badges

Should I call my UUID primary key column ID or not?

Awarded Apr 25 at 19:58

David Spillett

30.1k3 gold badges44 silver badges84 bronze badges

How do I set and get custom database variables?

Awarded Apr 25 at 14:21

Gergely Zsamboki

2162 silver badges2 bronze badges

Should I call my UUID primary key column ID or not?

Awarded Apr 25 at 13:06

Erwin Brandstetter

151k19 gold badges361 silver badges507 bronze badges

How to use variables in procedure (not function)?

Awarded Apr 24 at 8:35

Erwin Brandstetter

151k19 gold badges361 silver badges507 bronze badges

Sql Server, Is "Reorganize Files Before Releasing Unused Space" better or worse?

Awarded Apr 22 at 15:21

Brent Ozar

41.3k40 gold badges180 silver badges329 bronze badges

Does Microsoft SQL Server offer an Advisory Locks feature like Postgres?

Awarded Apr 21 at 11:05

Remus Rusanu

50.8k3 gold badges90 silver badges169 bronze badges

How to get non-overlapping distinct intervals from a PostgreSQL table?

Awarded Apr 18 at 21:10

Vérace - Слава Україні

27k7 gold badges63 silver badges77 bronze badges

Find rows containing a key in a JSONB array of records

Awarded Apr 17 at 7:57

Erwin Brandstetter

151k19 gold badges361 silver badges507 bronze badges

SQL Server / SSMS taking up lots of disk space

Awarded Apr 17 at 7:47

Erik Darling

33.4k13 gold badges111 silver badges266 bronze badges

Clone a database from SQL Server 2019 to 2017

Awarded Apr 16 at 10:25

serge

2512 silver badges8 bronze badges

BCP export more rows per batch to file (queryout)

Awarded Apr 15 at 13:33

Mark Storey-Smith

31.2k6 gold badges86 silver badges123 bronze badges

What is the purpose of WITH options in Sql Constraints?

Awarded Apr 14 at 12:27

SQLRaptor

3,9451 gold badge10 silver badges26 bronze badges

Postgres plpgsql - Using a variable inside of a dynamic create statement

Awarded Apr 13 at 22:11

Erwin Brandstetter

151k19 gold badges361 silver badges507 bronze badges

Is there a way to Delete inserted data, or vice versa?

Awarded Apr 12 at 12:33

Erik Darling

33.4k13 gold badges111 silver badges266 bronze badges

best way to run sql server management studio on linux

Awarded Apr 11 at 22:31

World Wide DBA

12.8k4 gold badges33 silver badges54 bronze badges

Whats SQL Server NVARCHAR(max) equivalent in MySQL?

Awarded Apr 10 at 8:31

RLF

13.8k2 gold badges30 silver badges44 bronze badges

Unused columns in WHERE clause

Awarded Apr 7 at 15:40

Laurenz Albe

32.2k3 gold badges28 silver badges52 bronze badges

2 3 4 5

…

119 Next

Stack Exchange Network

current community

your communities

more stack exchange communities