Popular Question

Popular Question

Question with 1,000 views. This badge can be awarded multiple times.

Awarded 35436 times.

MySQL Workbench: How to detach reverse-engineered EER diagram from existing database?

Awarded Nov 12 at 16:17

Jens Piegsa

1115 bronze badges

TempDB Transaction log not releasing space

Awarded Nov 12 at 13:03

Krishnp92

135 bronze badges

Function Based Index with XPATH extractValue

Awarded Nov 12 at 11:51

Andrew

335 bronze badges

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

Awarded Nov 12 at 11:02

joeldesante

1618 bronze badges

Greenplum ERROR: Canceling query because of high VMEM usage

Awarded Nov 12 at 10:25

Matias

1314 bronze badges

9 node percona xtradb cluster

Awarded Nov 12 at 9:41

roger moore

3372 silver badges17 bronze badges

Storing CREATE EXTERNAL DATA SOURCE in a SSDT project without exposing the DATABASE SCOPED CREDENTIAL or MASTER KEY secret;

Awarded Nov 12 at 5:40

Justin Dearing

2,5974 gold badges30 silver badges46 bronze badges

How to get a JSON array without JSON_ARRAYAGG in MySQL

Awarded Nov 12 at 2:51

Szymon Czembor

313 bronze badges

ID, UUID and "deleted_at" columns, How to avoid performance degradation?

Awarded Nov 12 at 0:50

DarkGhostHunter

1136 bronze badges

MySQL schedular every day in a time periode every hour

Awarded Nov 11 at 19:32

F T

114 bronze badges

mysql update query almost 5 minutes slower in 5.6 vs 5.5

Awarded Nov 11 at 14:21

Chris Muench

6114 gold badges12 silver badges33 bronze badges

Why am I not able to add a user?

Awarded Nov 11 at 13:41

Sajid Maqsood

293 bronze badges

Unfamiliar syntax - Query with Parameters in Braces at the beggining

Awarded Nov 11 at 13:41

SEarle1986

1,3072 gold badges13 silver badges36 bronze badges

get row/value by primary key number

Awarded Nov 11 at 10:21

tmdag

1636 bronze badges

Postgres: Recreate TRIGGER after replacing function?

Awarded Nov 11 at 10:02

kev

3651 gold badge2 silver badges12 bronze badges

RDS innodb_flush_log_at_trx_commit problem

Awarded Nov 11 at 9:42

Phantom

1193 bronze badges

Unable to run update_mysql in MySQL 5.5

Awarded Nov 11 at 9:42

Brian

212 bronze badges

How to SELECT a column based on a condition on the column's name?

Awarded Nov 10 at 17:20

WishIWasACoder

133 bronze badges

Pivot Multiple Columns with a Cross Apply

Awarded Nov 10 at 16:32

Raymondo

1014 bronze badges

Creating trigger from one database table to another database table postgresql

Awarded Nov 10 at 16:17

Lokesh Pandey

1571 silver badge8 bronze badges

SQL Server Profiler Exception tracing - Error procedure and line number omitted

Awarded Nov 10 at 14:36

Elaskanator

6815 silver badges20 bronze badges

Produce fixed length output to file regardless of the length of data in each column/row

Awarded Nov 10 at 12:36

Samer Ajlawi

1112 bronze badges

How do partitions handle new data?

Awarded Nov 10 at 11:07

DrDamnit

1951 gold badge2 silver badges11 bronze badges

MySQL Replication Stops, But Still Says it is Running

Awarded Nov 10 at 8:35

IGGt

1,8133 gold badges20 silver badges38 bronze badges

SqlLocalDB 2014 can not find SqlUserInstance.dll

Awarded Nov 10 at 7:43

Martacus

1115 bronze badges

Migration script fires 'The data definition language (DDL) command cannot be executed at the Subscriber'

Awarded Nov 10 at 7:43

Junior Mayhé

3271 gold badge2 silver badges12 bronze badges

How to resolve Cluster account permission issues

Awarded Nov 10 at 4:42

PTL_SQL

1637 bronze badges

Tuning a Postgres INSERT only database

Awarded Nov 10 at 3:27

Ofiris

7514 gold badges9 silver badges19 bronze badges

Huge Memory Grant resulting in RESOURCE SEMAPHORE waits for other queries

Awarded Nov 9 at 21:15

user9516827

1,2651 gold badge8 silver badges24 bronze badges

'Ungroup' data based on column

Awarded Nov 9 at 21:08

Christophe Loeys

235 bronze badges

What's the meaning of hard code query [closed]

Awarded Nov 9 at 18:45

Mei_R

631 silver badge7 bronze badges

Corrupted InnoDB still won't start even after removing corrupted tables

Awarded Nov 9 at 16:06

Dylan Wolters

112 bronze badges

How to script all the service broker elements for each database it is on, in the current server?

Awarded Nov 9 at 14:21

Marcello Miorelli

14.3k43 gold badges123 silver badges246 bronze badges

postgres notifications from inside stored procedures/triggers not immediately received by node.js listener client

Awarded Nov 9 at 13:02

chrism

534 bronze badges

Postgresql Crashed after os reboot

Awarded Nov 9 at 12:42

shalbafzadeh

1134 bronze badges

Why DBMS_METADATA.GET_DLL not work with EXEC command ?

Awarded Nov 9 at 8:05

ceinmart

3141 gold badge3 silver badges18 bronze badges

MySQL Grouping Data Together From Same User

Awarded Nov 9 at 7:55

Mars

655 bronze badges

mongodump: are 4 shards with total datasize 575 GB consider a Small Sharded Cluster?

Awarded Nov 9 at 7:27

Josefine

2,0983 gold badges28 silver badges55 bronze badges

multiple insert queries after a set of with's

Awarded Nov 9 at 7:01

Yogesch

6691 gold badge8 silver badges15 bronze badges

Create event trigger as non-superuser in Postgres

Awarded Nov 9 at 5:50

matt

1412 bronze badges

psql with '-c' option or '-f' option is not terminating properly

Awarded Nov 9 at 5:07

vfclists

8452 gold badges12 silver badges20 bronze badges

Slow performance on postgres query with count/sort

Awarded Nov 8 at 19:42

TimSpEdge

234 bronze badges

Restoring a database using Postgres data files instead of .sql files

Awarded Nov 8 at 19:06

andrewniesen

5813 gold badges9 silver badges14 bronze badges

Scheduling backup jobs for an Availability Group

Awarded Nov 8 at 16:31

syneticon-dj

4759 silver badges26 bronze badges

How can I find out if a user's password has expired in MySQL?

Awarded Nov 8 at 16:07

Anderson

216 bronze badges

Sql Server Agent fails to run batch from desktop

Awarded Nov 8 at 14:45

user20907

1632 gold badges3 silver badges10 bronze badges

SQL Server logs "blob data", viewable with journalctl

Awarded Nov 8 at 14:07

Evan Carroll

53.7k34 gold badges192 silver badges401 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 Nov 8 at 10:41

Martin Smith

76.8k14 gold badges222 silver badges314 bronze badges

Is it normal for Snapshot Replication job to be constantly running?

Awarded Nov 8 at 8:32

andrews

1752 silver badges11 bronze badges

Galera backup failing with error "mysqldump: Error 1213: Deadlock found when trying to get lock; try restarting transaction when dumping table"

Awarded Nov 8 at 7:41

Josefine

2,0983 gold badges28 silver badges55 bronze badges

What is the meaning of "minimal key"?

Awarded Nov 8 at 5:48

Stephanie Mussi

533 bronze badges

Is it okay to define a foreign key referencing a ‘user_id’ column from every table?

Awarded Nov 7 at 14:08

Night Man

355 bronze badges

Should I run multiple DBCC Shrinkfile if files are in different disk arrays?

Awarded Nov 7 at 5:34

Carlos Cuevas

414 bronze badges

before update trigger on sql server

Awarded Nov 7 at 3:55

Albert Hernández Torné

12 bronze badges

How to insert values to one table from the table stored in another database in postgresql?

Awarded Nov 7 at 1:52

Shivam Arora

1012 bronze badges

PostgreSQL results of conditional insert

Awarded Nov 6 at 17:50

Naryck

471 silver badge6 bronze badges

How to restrict SSMS to list the database of a particular user (Windows 2012 + Plesk)

Awarded Nov 6 at 16:47

Mani

1291 silver badge5 bronze badges

Why is setting open_files_limit making MySQL slow?

Awarded Nov 6 at 13:25

Jai

14310 bronze badges

How to create a check between two attributes of two different tables

Awarded Nov 6 at 12:57

Revolucion for Monica

6499 silver badges23 bronze badges

Trigger with multiple inserts based on JSON data

Awarded Nov 6 at 10:16

equaeghe

1436 bronze badges

Prev 1 2 3

…

591 Next

Stack Exchange Network

current community

your communities

more stack exchange communities