Skip to main content
Database Administrators

Nice Question

 Nice Question
Question score of 10 or more. This badge can be awarded multiple times.
Awarded 4720 times.
Mysql Workbench crashing when connecting
Awarded yesterday
postgresql: How to disable all indexes of a table
Awarded Sep 15 at 21:57
Why is the serial primary key incrementing despite a using "On Conflict Do Nothing?
Awarded Sep 6 at 14:46
Could not obtain exclusive lock on database 'model' - who is using it?
Awarded Sep 5 at 19:35
How to get the next value of sequence?
Awarded Sep 2 at 8:56
What is meant by DDBB?
Awarded Aug 30 at 15:16
Blocked sessions waiting with PAGELATCH_* wait types?
Awarded Aug 28 at 10:48
Broken Query Store
Awarded Aug 26 at 16:56
SQL Server - RangeX-X and RangeI-N locks
Awarded Aug 23 at 23:37
I can't select a certain record with like %value%
Awarded Aug 23 at 13:27
List all parents/ascendants of all nodes
Awarded Aug 21 at 18:32
Is there a performance penalty when there are two unique indexes on a table with all of the colums in one index are also in the other index?
Awarded Aug 20 at 18:49
Why is a datetime value returned that matches the predicate value when using greater than comparison
Awarded Aug 19 at 7:55
MySQL: How to drop all tables starting with a prefix?
Awarded Aug 12 at 21:47
Automatically Execute Stored Procedure After Any RESTORE DATABASE Event
Awarded Aug 9 at 12:56
ADD PERIOD FOR SYSTEM_TIME on table failed
Awarded Aug 8 at 10:02
How can I resolve SSIS Excel Connection Manager Error 0xC0209303?
Awarded Aug 6 at 8:06
How to check if the current connection is in a transaction?
Awarded Aug 5 at 0:53
How do I drop a database which has brackets in its name?
Awarded Aug 2 at 23:21
postgres; do indexes automatically reindex new data?
Awarded Aug 2 at 8:51
Multi-row insert vs transactional single row inserts
Awarded Jul 31 at 11:49
pg_restore --clean not working because cascade drop
Awarded Jul 30 at 16:54
Why is GETUTCDATE earlier than SYSDATETIMEOFFSET?
Awarded Jul 29 at 9:50
Recommended way: "SELECT *" vs "SELECT COLUMN_LIST" from same table, multiple times
Awarded Jul 28 at 9:12
Key-range RangeI-N lock compatibility in SQL Server
Awarded Jul 22 at 11:41
What are some common and useful fields for a users table in a database?
Awarded Jul 21 at 10:49
Is table partitioning improving performance? Is it worth it?
Awarded Jul 21 at 5:30
Inherit default privileges: every table created by *any member of* role A is readable by role B
Awarded Jul 19 at 8:50
SQL Server alerts not sending notification emails to the operator
Awarded Jul 17 at 0:21
Lots of "FETCH API_CURSOR0000..." on sp_WhoIsActive ( SQL Server 2008 R2 )
Awarded Jul 12 at 18:55
Truncate with where clause
Awarded Jul 10 at 9:48
Differences between .dump and .sql in pg_dump PostgreSQL
Awarded Jul 9 at 11:45
How to list all grants per user/role on PostgreSQL
Awarded Jul 3 at 6:37
MySQL :: How to run ANALYZE TABLE for all tables in a database
Awarded Jul 2 at 13:27
Error: "The certificate cannot be dropped because one or more entities are either signed or encrypted using it."
Awarded Jun 28 at 14:48
Implicit privileges for schema owner
Awarded Jun 28 at 7:31
Postgres Dump To TXT File
Awarded Jun 27 at 17:40
self-joins in recursive CTE: `recursive reference must not appear more than once`?
Awarded Jun 26 at 14:16
Is "ROW_NUMBER() OVER(ORDER BY xml.node)" well defined?
Awarded Jun 26 at 11:48
Slow JOIN on tables with millions of rows
Awarded Jun 24 at 4:37
Importing large SQL dump with millions of INSERT statements
Awarded Jun 24 at 2:26
jsonb_array_elements() fails with "ERROR: cannot extract elements from an object"
Awarded Jun 20 at 16:28
Select MIN value from multiple columns
Awarded Jun 20 at 15:49
Why can I select all fields when grouping by primary key but not when grouping by another column
Awarded Jun 17 at 14:02
Storing CREATE EXTERNAL DATA SOURCE in a SSDT project without exposing the DATABASE SCOPED CREDENTIAL or MASTER KEY secret;
Awarded Jun 12 at 3:18
Enforce a column as unique based on another column value
Awarded Jun 4 at 7:49
Kill all sessions for ONE user in MS SQL
Awarded Jun 3 at 17:25
Is the size limit of a json field before or after compression in Postgres?
Awarded Jun 2 at 16:06
Clustered Index Scan (Clustered) vs. Index Seek (NonClustered) + Key Lookup (Clustered)
Awarded May 29 at 9:08
How to change only time while keeping the date same in timestamp type
Awarded May 28 at 11:26
Does ordering by auto-incrementing PK ensure chronological order?
Awarded May 25 at 10:25
Pros and Cons of Checking if value exist for unique column or let db raise unique error on inserting
Awarded May 24 at 13:03
How to grant set the replication attribute on RDS PostgreSQL?
Awarded May 21 at 4:05
Postgres choosing a filter instead of index cond when OR is involved
Awarded May 20 at 16:30
How to speed up query with anti-joins
Awarded May 17 at 8:51
How to understand "object-relational"?
Awarded May 15 at 11:50
What does PostgreSQL Status active (exited) mean?
Awarded May 14 at 11:56
Why exactly doesn't PostgreSQL allow reordering the columns? [closed]
Awarded May 10 at 13:58
Use NOLOCK hint when calling table valued function
Awarded May 8 at 13:04
DBCC SHRINKFILE works with file_id but not with logical name
Awarded May 2 at 18:42
1
2 3 4 5
…
79