Announcer - Badge - Database Administrators Stack Exchange

Announcer

Share a link to a post later visited by 25 unique IP addresses. This badge can be awarded multiple times.

Awarded 1848 times.

Shall I use enum when are too many "categories" with PostgreSQL?

Awarded Jul 15 at 13:35

ceving

3393 silver badges12 bronze badges

Why is SQL Server spliting it's (JSON) response into multiple rows?

Awarded Jul 8 at 17:14

joeldesante

3112 silver badges9 bronze badges

TSQL command to delete backup files older than N hours

Awarded Jul 4 at 15:43

Kin Shah

62.4k6 gold badges121 silver badges238 bronze badges

Setting up replication for MyISAM tables?

Awarded Jun 27 at 12:56

RolandoMySQLDBA

183k33 gold badges320 silver badges525 bronze badges

SQL Server 2012 indirect checkpoint

Awarded Jun 26 at 9:58

Kin Shah

62.4k6 gold badges121 silver badges238 bronze badges

Is "ROW_NUMBER() OVER(ORDER BY xml.node)" well defined?

Awarded Jun 25 at 20:35

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Is sys.dm_os_memory_clerks a good source to use when setting max server memory (MB)?

Awarded Jun 19 at 18:18

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

How should MAXDOP be configured on stacked instances?

Awarded Jun 14 at 16:40

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

EVENTDATA() function is giving only null values in sql server

Awarded Jun 11 at 17:40

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

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

Awarded Jun 11 at 1:02

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

How can I verify if Read Committed Snapshot Isolation is causing application problems that Read Committed would not?

Awarded Jun 11 at 1:02

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Is the Query Store Parallelism the same as CX_Packet?

Awarded Jun 10 at 20:26

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Can Query Store Show Spills To Tempdb?

Awarded Jun 10 at 16:26

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Run TSQL alter db set trustworthy on multiple times

Awarded Jun 10 at 16:26

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Can't see table partitions after adding PK

Awarded Jun 10 at 16:26

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Is default ordering affected by clustered index?

Awarded Jun 10 at 13:21

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Effect on execution plans when a table variable has a primary key

Awarded Jun 10 at 13:21

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Is it bad practice to have a "most_recent" boolean column in addition to a "create_at" timestamp column to track the latest version of a record?

Awarded Jun 10 at 11:41

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

What do developers need to know about Read Committed Snapshot Isolation?

Awarded Jun 10 at 9:05

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

IndexOptimize Question

Awarded Jun 10 at 9:05

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

SQL Server 2012 Backup Timeline Cannot find file

Awarded Jun 10 at 9:05

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

SQL Server: Max memory same as Min memory?

Awarded Jun 10 at 7:49

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Comparing an aggregate function's result against a column

Awarded Jun 10 at 2:49

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

sp_whoisactive is showing a Blocking Session ID of -5

Awarded Jun 8 at 10:56

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Multi-Column Indexes with a Low Variance Column

Awarded Jun 6 at 11:42

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

What type of resource locks are shown in sp_who2?

Awarded Jun 5 at 20:16

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

how do I decide which duplicate statistics should delete?

Awarded Jun 5 at 20:16

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

When should I inspect the Error Log?

Awarded Jun 5 at 20:16

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Understanding and Optimizing Duplicate Query Hashes Across Multiple Databases in SQL Server

Awarded Jun 5 at 16:20

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

PostgreSQL equivalent of SQL Server SQL_VARIANT_PROPERTY

Awarded Jun 4 at 15:56

Evan Carroll

63.9k48 gold badges246 silver badges486 bronze badges

MySQL gives "Out of Memory" error when inserting a large file. From where is this filesize limitation arising?

Awarded May 31 at 6:52

RolandoMySQLDBA

183k33 gold badges320 silver badges525 bronze badges

Removing/overwriting sensitive data located in already deleted records in ibdata files

Awarded May 30 at 4:45

RolandoMySQLDBA

183k33 gold badges320 silver badges525 bronze badges

msg: Cannot execute SQL 'COPY "my_table" FROM '/path/big_file.csv': ERROR: Could not extend file "base/A/B": only C bytes of D written in block E

Awarded May 29 at 13:31

Tms91

1011 silver badge6 bronze badges

Execution slow in stored procedure; fast when run ad hoc

Awarded May 28 at 17:35

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Sampled Statistics Percentage Internal Calculation

Awarded May 23 at 18:35

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

How to prevent a PostgreSQL trigger from being fired by another trigger?

Awarded May 20 at 9:33

Erwin Brandstetter

179k27 gold badges446 silver badges610 bronze badges

Extra NESTED LOOP / INNER JOIN causing NO JOIN PREDICATE warning

Awarded May 14 at 23:47

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Suppressing the SSMS prompt to save changes

Awarded May 13 at 8:01

Martin Smith

85.4k15 gold badges248 silver badges340 bronze badges

JSON subquery using WITHOUT_ARRAY_WRAPPER returning odd data?

Awarded May 10 at 23:08

j.f.

1012 bronze badges

How large should be mysql innodb_buffer_pool_size?

Awarded May 10 at 19:16

Harry

1012 bronze badges

Performance difference for COALESCE versus ISNULL?

Awarded May 9 at 9:32

GarethD

6837 silver badges14 bronze badges

Why is COALESCE not a function?

Awarded Apr 29 at 16:22

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Why not use SQL_Latin1_General_CI_AS for a global system?

Awarded Apr 29 at 10:42

Solomon Rutzky

69.2k8 gold badges152 silver badges294 bronze badges

What is the difference between "server_lifetime" and "server_idle_timeout"?

Awarded Apr 19 at 22:33

Melkij

3,2597 silver badges13 bronze badges

InnoDB: Could not find a valid tablespace file for 'database/table'. Mariadb 10.1.40

Awarded Apr 11 at 16:47

Bojan Hrnkas

1114 bronze badges

SSMS 20 - Query Store - Configure tracked queries broken?

Awarded Apr 8 at 20:12

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

XML Query keeps converting < to < and > to >

Awarded Apr 2 at 21:51

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Set names to attributes when creating JSON with row_to_json

Awarded Mar 29 at 0:33

Konard

1215 bronze badges

Is Synonyms to tables cost effective within SQL Server 2016

Awarded Mar 28 at 19:46

Shaulinator

3,1521 gold badge12 silver badges25 bronze badges

How can I delete extended event files from within Managed Instance?

Awarded Mar 23 at 2:05

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Duplicate rows - how to remove one?

Awarded Mar 12 at 21:02

RonJohn

6472 gold badges10 silver badges30 bronze badges

Issues with module signing and SSIS catalog internal procedures

Awarded Feb 22 at 21:57

Solomon Rutzky

69.2k8 gold badges152 silver badges294 bronze badges

Are views logically redundant?

Awarded Feb 22 at 21:57

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Why Isn't Postgres Using My Functional Index?

Awarded Feb 19 at 16:41

Brent Ozar

43k47 gold badges221 silver badges376 bronze badges

First Normal Form: Definitive Definition

Awarded Feb 14 at 22:00

MDCCL

8,5303 gold badges31 silver badges61 bronze badges

SQL Server Migration restore backup vs copy data and log files

Awarded Feb 14 at 12:17

Paul White♦

87k30 gold badges414 silver badges647 bronze badges

Online Index Rebuild of large table takes exclusive lock

Awarded Feb 8 at 3:57

Kendra Little

7865 silver badges8 bronze badges

Aside from explicitly flushing the cache or demanding recompiles, what recompiles a full stored procedure in SQL Server 2019?

Awarded Feb 6 at 17:03

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

Does PostgreSQL optimize adding columns with non-NULL DEFAULTs?

Awarded Feb 6 at 17:03

rogerdpack

1,3041 gold badge15 silver badges18 bronze badges

How can I know how many tables my DELETE has changed?

Awarded Feb 2 at 12:20

Erik Darling

42.1k14 gold badges137 silver badges491 bronze badges

2 3 4 5

…

31 Next