Nice Answer

Nice Answer

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

Awarded 5951 times.

ORDER BY gives ERROR: function array_position(text[], character varying) does not exist

Awarded 8 hours ago

Evan Carroll

44.5k19 gold badges132 silver badges314 bronze badges

Microsoft SQL Server: Prepared Statements

Awarded 14 hours ago

Solomon Rutzky

59.1k6 gold badges111 silver badges228 bronze badges

SQL Server 2017 Enterprise vs Standard - Online Indexing and Online Schema Change

Awarded yesterday

LowlyDBA

9,2418 gold badges35 silver badges56 bronze badges

Which DBMS is good for super-fast reads and a simple data structure?

Awarded 2 days ago

Richard

5,9736 gold badges35 silver badges59 bronze badges

Is it possible to restore a SQL Server Linux Backup on SQL Server Windows

Awarded 2 days ago

Grant Fritchey

2,35613 silver badges17 bronze badges

Why is the auto created statistic on this column empty?

Awarded 2 days ago

Paul White 9♦

54.6k16 gold badges335 silver badges515 bronze badges

Foreign keys become untrusted after bulk insert

Awarded May 29 at 7:35

LowlyDBA

9,2418 gold badges35 silver badges56 bronze badges

Can't default date to CURRENT_TIMESTAMP in MySQL 5.5

Awarded May 29 at 4:51

jynus

12.8k1 gold badge22 silver badges36 bronze badges

Does restoring a full backup bring it to the backup START time or the backup FINISH time?

Awarded May 28 at 15:04

pacreely

9541 gold badge5 silver badges14 bronze badges

Are junction tables a good practice?

Awarded May 28 at 9:01

Federico Razzoli

4683 silver badges15 bronze badges

Getting “sqlcmd sqlcmd: command not found” in Linux?

Awarded May 27 at 6:15

Evan Carroll

44.5k19 gold badges132 silver badges314 bronze badges

Shrink database after drop table?

Awarded May 26 at 20:16

mrdenny

26.4k2 gold badges37 silver badges78 bronze badges

Msg 39011 SQL Server was unable to communicate with the LaunchPad service

Awarded May 26 at 15:25

Henrik Staun Poulsen

1,8252 gold badges11 silver badges27 bronze badges

Can mysqldump dump triggers and procedures?

Awarded May 23 at 14:57

RolandoMySQLDBA

157k26 gold badges255 silver badges428 bronze badges

Unquoting JSON strings; print JSON strings without quotes

Awarded May 22 at 18:01

Evan Carroll

44.5k19 gold badges132 silver badges314 bronze badges

Permutation and Combination of words

Awarded May 22 at 10:50

George.Palacios

5,19814 silver badges40 bronze badges

Why the instance name of SQL Server Express is changing?

Awarded May 21 at 23:27

AMtwo

8,5021 gold badge17 silver badges38 bronze badges

Does it make sense to use SQL Server's bracket notation in hand written code?

Awarded May 21 at 20:25

Nick Chammas

13.4k16 gold badges66 silver badges115 bronze badges

What does the Postgres <-> operator do?

Awarded May 21 at 14:08

Erwin Brandstetter

116k16 gold badges260 silver badges399 bronze badges

Execute Sql statement and send result to email

Awarded May 21 at 13:18

Max Vernon

61.4k13 gold badges131 silver badges266 bronze badges

What is the point of outer in a join?

Awarded May 20 at 20:25

Martin Smith

73.6k10 gold badges203 silver badges292 bronze badges

How can I convert a key in a SQL Server deadlock report to the value?

Awarded May 20 at 16:10

BateTech

6961 gold badge5 silver badges13 bronze badges

Do schema changes “break” Availability Groups or are they handled transparently?

Awarded May 20 at 7:35

Aaron Bertrand♦

166k22 gold badges342 silver badges546 bronze badges

MySQL console: Ctrl+C driving me nuts

Awarded May 19 at 18:30

Damien Ó Ceallaigh

2012 silver badges4 bronze badges

Apply INNER JOIN only if there is a row available otherwise use NULL

Awarded May 19 at 14:16

Joe W

8735 silver badges16 bronze badges

Pivot rows into multiple columns

Awarded May 18 at 4:46

billinkc

14.6k4 gold badges41 silver badges81 bronze badges

GROUPING SETS returning unexpected results with calculated expression

Awarded May 17 at 21:55

Martin Smith

73.6k10 gold badges203 silver badges292 bronze badges

Good Resources on Operating/Administering MongoDB

Awarded May 17 at 9:27

Justin Jenkins

3711 silver badge6 bronze badges

How to get the difference in days between 2 timestamps in PostgreSQL

Awarded May 17 at 4:57

Erwin Brandstetter

116k16 gold badges260 silver badges399 bronze badges

How restore from .gz backup with new database name using mongorestore r3.2.9?

Awarded May 15 at 22:20

Siraj Alam

2012 silver badges5 bronze badges

Monitoring Progress of Index Construction in PostgreSQL

Awarded May 15 at 18:10

Envek

2112 silver badges4 bronze badges

How to get a group where the count is zero?

Awarded May 15 at 8:40

McNets

20.1k7 gold badges33 silver badges69 bronze badges

PostgreSQL Change owner of all tables under a specific schema

Awarded May 14 at 14:18

Ali Saeed

2112 silver badges4 bronze badges

What does “Heap Block” in “Bitmap Heap Scan” mean?

Awarded May 13 at 19:11

jjanes

21.9k2 gold badges16 silver badges27 bronze badges

Unsuccessfully granting privileges

Awarded May 13 at 18:33

Jacob H

5925 silver badges18 bronze badges

How is data lake and polyglot persistence different?

Awarded May 13 at 3:26

Vérace

20.2k4 gold badges44 silver badges62 bronze badges

SQL Server Spill level 0 - what is it?

Awarded May 11 at 20:19

Paul White 9♦

54.6k16 gold badges335 silver badges515 bronze badges

Installing pgcrypto Extension

Awarded May 10 at 22:50

Trygve Laugstøl

5915 silver badges19 bronze badges

PostgreSQL Error: out of memory

Awarded May 9 at 21:50

Daniel Vérité

21.7k3 gold badges46 silver badges60 bronze badges

Is a single-table relational database similar to a simple NoSQL database?

Awarded May 9 at 10:40

Vérace

20.2k4 gold badges44 silver badges62 bronze badges

Getting the count and sum of distinct record from Postgres jsonb attribute

Awarded May 9 at 3:58

joanolo

11.2k6 gold badges27 silver badges58 bronze badges

List all parents/ascendants of all nodes

Awarded May 8 at 17:19

indiri

2,1314 silver badges12 bronze badges

Identity Column in Concurrency, Multithreading, Parallel Processing

Awarded May 8 at 13:56

Paul White 9♦

54.6k16 gold badges335 silver badges515 bronze badges

Security implications of enabling CLR on shared instance

Awarded May 7 at 22:40

Solomon Rutzky

59.1k6 gold badges111 silver badges228 bronze badges

Find if any of the rows partially match a string

Awarded May 6 at 15:01

ypercubeᵀᴹ

85.7k11 gold badges151 silver badges243 bronze badges

Maximum possible memory usage: 16.2G (874% of installed RAM)

Awarded May 6 at 5:51

RolandoMySQLDBA

157k26 gold badges255 silver badges428 bronze badges

Why does max_used_connections status not get refreshed automatically once it reaches max_connections, even though the Threads_connected falls down

Awarded May 5 at 22:17

Michael - sqlbot

20.4k2 gold badges35 silver badges68 bronze badges

Explicitly granting permissions to update the sequence for a serial column necessary?

Awarded May 5 at 13:38

Erwin Brandstetter

116k16 gold badges260 silver badges399 bronze badges

How can I enforce that values in a table column match the Regular Expression “[axyto0-9\s]{0,2}[\s0-9]{0,10}”?

Awarded May 4 at 18:27

Martin Smith

73.6k10 gold badges203 silver badges292 bronze badges

When you back up a database and scripts are running at the same time, at what point in time does the backup reflect?

Awarded May 4 at 14:36

Grant Fritchey

2,35613 silver badges17 bronze badges

Does ordering by auto-incrementing PK ensure chronological order?

Awarded May 4 at 7:46

mustaccio

15.1k10 gold badges37 silver badges53 bronze badges

Is it possible to get execution call stack in a trigger?

Awarded May 3 at 8:35

Marian

14.2k1 gold badge48 silver badges69 bronze badges

How many rows can a SQL Server 2012 table hold, and when should I partition it?

Awarded May 3 at 5:42

Solomon Rutzky

59.1k6 gold badges111 silver badges228 bronze badges

SQL Server: Get location of transaction log from MDF file

Awarded May 2 at 13:34

Martin Smith

73.6k10 gold badges203 silver badges292 bronze badges

What would cause a table with 80,000 records to use 145GB of space?

Awarded May 1 at 22:26

Rob Farley

14.7k2 gold badges30 silver badges54 bronze badges

How to combine date and time to datetime2 in SQL Server?

Awarded May 1 at 14:55

knuckles

1011 silver badge3 bronze badges

Use composite type to create new table

Awarded Apr 30 at 20:07

Erwin Brandstetter

116k16 gold badges260 silver badges399 bronze badges

Difference between database backup and data-tier application export

Awarded Apr 30 at 10:25

Spörri

3,96910 silver badges23 bronze badges

Using outer alias in a subquery

Awarded Apr 29 at 15:10

McNets

20.1k7 gold badges33 silver badges69 bronze badges

Error: Unable to write inside TEMP environment variable path

Awarded Apr 29 at 11:37

bspkrs

2163 silver badges6 bronze badges

2 3 4 5

…

100 Next

Stack Exchange Network

current community

your communities

more stack exchange communities