Database Administrators

Enlightened

 Enlightened
First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.
Awarded 3213 times.
Why is this query not using my nonclustered index, and how can I make it?
Awarded Aug 26, 2021 at 4:55
Why does a comparison between 'tr' & 'tR' fail on a SQL Server with Vietnamese_CI_AI collation?
Awarded Aug 25, 2021 at 7:51
MySQL: Safe to kill transaction that is stuck in "Waiting for table metadata lock"
Awarded Aug 24, 2021 at 12:12
node is not in primary or recovering state
Awarded Aug 24, 2021 at 7:04
Is it a good idea to Partition a table (in MS SQL) based on date, when there's a clustered index present on ID (INT)
Awarded Aug 23, 2021 at 18:48
Why can MySQL handle multiple updates concurrently and PostgreSQL can't?
Awarded Aug 23, 2021 at 1:31
Aggregate objects into a json array (subquery issues)
Awarded Aug 19, 2021 at 12:04
What are the .BCP files inside a .bacpak file?
Awarded Aug 19, 2021 at 7:04
AppDomain 2 SSISDB is Marked for Unload due to Memory Pressure
Awarded Aug 16, 2021 at 21:41
Generate Dates between Date Ranges in mysql
Awarded Aug 16, 2021 at 7:17
Postgres table partitioning "no partition of relation "parsel_part" found for row" error?
Awarded Aug 12, 2021 at 18:27
Using AD groups vs roles in SQL Server
Awarded Aug 12, 2021 at 18:27
How do uninitialized variables differ from NULL in Mysql?
Awarded Aug 10, 2021 at 20:26
When the primary key is also the foreign key, in Postgres
Awarded Aug 9, 2021 at 16:09
Postgres Refresh Materialized View Locks
Awarded Aug 5, 2021 at 19:50
Postgresql 10 create subscription hangs
Awarded Aug 3, 2021 at 17:16
What exactly is Psycopg2?
Awarded Jul 29, 2021 at 18:09
SELECT very slow when no results and a LIMIT is specified
Awarded Jul 28, 2021 at 14:26
How do you use MAXDOP in a View?
Awarded Jul 26, 2021 at 20:07
Do long names for jsonb keys use more storage?
Awarded Jul 26, 2021 at 12:57
Is there a function which the opposite of NULLIF?
Awarded Jul 23, 2021 at 19:40
Remove the log shipping configuration on the secondary server, when the primary is no longer available
Awarded Jul 23, 2021 at 19:40
Changing identity column from INT to BIGINT
Awarded Jul 23, 2021 at 14:52
How to search hyphenated words in PostgreSQL full text search?
Awarded Jul 21, 2021 at 19:42
Why does SQL Server Mangement Studio not script Indexes by default?
Awarded Jul 19, 2021 at 14:20
Analyze needed after a refresh materialized view?
Awarded Jul 12, 2021 at 14:28
Why does sqlcmd -Lc not show the local instance?
Awarded Jul 10, 2021 at 22:48
Unexpected update results on heap using SET @Variable = Field= @Variable + 1, fixed with clustered index
Awarded Jul 10, 2021 at 14:27
Recommended way: "SELECT *" vs "SELECT COLUMN_LIST" from same table, multiple times
Awarded Jul 9, 2021 at 13:15
How to copy database from server to local machine in SQL Server Management studio?
Awarded Jul 8, 2021 at 11:06
How to set the wal_level in AWS RDS Postgresql?
Awarded Jul 7, 2021 at 8:15
Is it bad to shrink + reindex after removing a significant part of data?
Awarded Jul 6, 2021 at 15:16
How do you properly remove "REQUIRE SSL" from a single user?
Awarded Jul 5, 2021 at 16:58
Solving intra parallel query deadlocks
Awarded Jul 2, 2021 at 7:49
Mysql fulltext search my.cnf optimization
Awarded Jul 1, 2021 at 20:10
default permissible datatype conversion matrix
Awarded Jul 1, 2021 at 8:45
INSERT using results of CTE INSERT to provide unique id values
Awarded Jun 30, 2021 at 22:30
Left outer join not returning all rows in a grouping query
Awarded Jun 30, 2021 at 20:51
Where to download SQL Server 2019 Express LocalDB Installer MSI from
Awarded Jun 29, 2021 at 10:46
Update by iterating table in batches faster than whole table in PostgreSQL
Awarded Jun 24, 2021 at 21:26
Why does a clustered Key Lookup on a primary key have a high estimated rows per execution?
Awarded Jun 23, 2021 at 16:32
Purpose of SQL Server Application Roles
Awarded Jun 22, 2021 at 21:22
Error ORA-12560 when trying to connect Windows SQL*Plus client to Oracle 11g Linux server
Awarded Jun 22, 2021 at 7:05
How to log verbose output from mysqldump?
Awarded Jun 21, 2021 at 23:31
Should stored financial transactions include some data redundancy?
Awarded Jun 18, 2021 at 19:12
Why is LIMIT killing performance of this Postgres query?
Awarded Jun 18, 2021 at 6:26
What is difference between Arabic_100_CS_AS_KS_WS_SC_UTF8 and Latin1_General_100_CS_AS_KS_WS_SC_UTF8?
Awarded Jun 17, 2021 at 12:16
Option to uncheck all or invert selection in SSDT?
Awarded Jun 16, 2021 at 21:55
Can I skip the intermediate table in a join?
Awarded Jun 14, 2021 at 14:42
When should the IGNORE_DUP_KEY option be used on an index?
Awarded Jun 11, 2021 at 1:36
Query detailing differences between rows for a large amount of data
Awarded Jun 10, 2021 at 23:09
Aggregated column causes full table scan even though the right index is present
Awarded Jun 9, 2021 at 17:02
Why is an OR statement slower than UNION?
Awarded Jun 8, 2021 at 16:10
How can I swap two values from particular column in a table in Postgres?
Awarded Jun 7, 2021 at 19:09
Can I safely kill OPTIMIZE TABLE on an InnoDB table?
Awarded Jun 6, 2021 at 17:55
SQL Parameter Sniffing Possible Workaround
Awarded Jun 6, 2021 at 12:36
ERROR: invalid input syntax for type money
Awarded Jun 1, 2021 at 8:28
Mysql Not Null Columns accepting null values
Awarded May 28, 2021 at 10:41
PostgeSQL 9.3: Is it safe to stop VACUUM FULL?
Awarded May 25, 2021 at 0:20
Query runs a long time in some newer MySQL versions
Awarded May 23, 2021 at 7:42
1
…
5 6
7
8 9
…
54

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.