Database Administrators

Enlightened

 Enlightened
First to answer and accepted with score of 10 or more. This badge can be awarded multiple times.
Awarded 3204 times.
SQL Server tempdb on RAM Disk?
Awarded Nov 13, 2020 at 16:49
SSMS - How to Enable Word Wrap for Messages Pane
Awarded Nov 13, 2020 at 9:27
Select pairs (a,b) excluding (b,a) with same value
Awarded Nov 11, 2020 at 6:17
How do I identify the column(s) responsible for "String or binary data would be truncated."
Awarded Nov 10, 2020 at 22:06
What is the relevance of 'SET default_with_oids = true' in a Postgresql dump?
Awarded Nov 6, 2020 at 12:21
Filter Condition Difference - Where Clause vs Join Condition
Awarded Nov 5, 2020 at 4:09
Adding Nullable Column To Production DB taking too much time
Awarded Nov 4, 2020 at 12:50
When are dimension tables still needed using clustered columnstore indexing?
Awarded Nov 3, 2020 at 15:43
MS SQL Server: Do multiple queries in a batch ever execute in parallel and if so what happens when the second query is dependent on the first?
Awarded Nov 3, 2020 at 6:55
Is XFS still the best choice for mongodb?
Awarded Oct 28, 2020 at 9:10
PostgreSQL multiple column foreign key
Awarded Oct 26, 2020 at 22:10
Dealing with disk space full in postgresql
Awarded Oct 26, 2020 at 17:11
Why the sudden increase of my database .mdf file size?
Awarded Oct 25, 2020 at 11:30
What is "special" about PostgreSQL update vs delete+insert
Awarded Oct 23, 2020 at 21:30
Select rows based on a minimum in one column
Awarded Oct 23, 2020 at 17:17
What are "folded" and "pivoted" tables?
Awarded Oct 23, 2020 at 0:50
Why do I get incorrect characters when decoding a Base64 string to NVARCHAR in SQL Server?
Awarded Oct 21, 2020 at 20:34
Looking for simple contains method when searching text in postgresql
Awarded Oct 21, 2020 at 5:55
Text string stored in SQLite Integer column?
Awarded Oct 19, 2020 at 17:06
How to get a list of global temporary tables in the current database?
Awarded Oct 19, 2020 at 17:06
How to get the ID of the conflicting row in upsert?
Awarded Oct 18, 2020 at 23:06
Can't create table, but table doesn't exist
Awarded Oct 17, 2020 at 3:06
How do I prevent SQLite database locks?
Awarded Oct 16, 2020 at 13:33
Is left hash join always better than left outer join?
Awarded Oct 16, 2020 at 12:35
Colleague says to never use an OR statement in SQL, is this true?
Awarded Oct 16, 2020 at 8:26
What is the proper event in Extended Events to track stored procedure executions?
Awarded Oct 15, 2020 at 15:05
SQL Server - Order by case statement very slow
Awarded Oct 14, 2020 at 18:16
SELECT LIMIT 1 per column value?
Awarded Oct 12, 2020 at 22:50
Do temporal tables log changes when there are none?
Awarded Oct 12, 2020 at 21:10
postgresql insert from select query, plus static values
Awarded Oct 8, 2020 at 15:05
Why does SET ROWCOUNT not reset after GO?
Awarded Oct 6, 2020 at 22:47
PostgreSQL 9.3: Dump a database excluding the data of some tables
Awarded Oct 6, 2020 at 1:48
high PAGEIOLATCH_SH waits on server
Awarded Oct 3, 2020 at 16:10
Check if the trigger was fired by INSERT or DELETE
Awarded Sep 30, 2020 at 17:32
while restoring mysql database, views changed into tables
Awarded Sep 29, 2020 at 10:12
Postgres: Difference between Tuples inserted and Live tuples
Awarded Sep 22, 2020 at 7:18
How do pages get updated checksum when switching page verification mode from torn page to checksum?
Awarded Sep 20, 2020 at 16:55
What's the impact of running sp_updatestats in production server?
Awarded Sep 19, 2020 at 13:48
Changing ANSI_NULLS setting on a table
Awarded Sep 17, 2020 at 20:15
MS SQL Page split confusion
Awarded Sep 16, 2020 at 15:36
MariaDB: disable foreign key checks
Awarded Sep 14, 2020 at 13:51
Why is GROUP BY clause missing rows
Awarded Sep 13, 2020 at 20:21
In PostgreSQL is the row ordering preserved in functions and CTEs?
Awarded Sep 12, 2020 at 20:42
Is it possible to gain the precise position of a live mysql database when performing full backup
Awarded Sep 9, 2020 at 22:05
Do you have to run nodetool repair on every node?
Awarded Sep 7, 2020 at 17:27
DATEADD and DATEPART with milliseconds yields strange results
Awarded Sep 4, 2020 at 11:26
Update request using table alias
Awarded Sep 3, 2020 at 14:43
Database "frozen" on ALTER TABLE
Awarded Sep 2, 2020 at 16:00
Is the query optimizer able to optimize away IS NOT NULL conditions if the column has a NOT NULL constraint?
Awarded Sep 2, 2020 at 9:08
Divide, round and replace in one select statement - tranformation from bytes to GB in SQL Server
Awarded Sep 1, 2020 at 11:48
Use NOLOCK hint when calling table valued function
Awarded Aug 27, 2020 at 17:20
Which are the minimum privileges required to get a backup of a MySQL database schema?
Awarded Aug 26, 2020 at 19:16
Apply cardinality estimation problem in SQL Server
Awarded Aug 26, 2020 at 14:16
sp_msforeachdb in a stored procedure does not work well
Awarded Aug 21, 2020 at 18:27
Improving performance when ordering by a column of a joined table
Awarded Aug 19, 2020 at 12:37
ALLOW FILTERING vs NOT; Cassandra Data Model Question
Awarded Aug 17, 2020 at 23:32
Stored procedures vs. inline SQL
Awarded Aug 12, 2020 at 16:51
How can I request a flush of the postgresql transaction logs?
Awarded Aug 10, 2020 at 20:12
Change path for binary logs and scheduling
Awarded Aug 8, 2020 at 15:12
MERGE deadlocking prevention
Awarded Aug 7, 2020 at 6:00
1
…
9 10
11
12 13
…
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.