Database Administrators

Help Center > Badges > Scholar

 Scholar
Ask a question and accept an answer.
Awarded 19132 times.
Correct data types for my database
Awarded 1 hour ago
Schedule Full, Differential and Transnational Backup in SQL Server 2016
Awarded 5 hours ago
How to get all tables in informix database and their sizes in GB?
Awarded 6 hours ago
How can I update the roles for all logins using T-SQL?
Awarded 6 hours ago
How to get all records where a joined column contains some value (at least once)
Awarded 6 hours ago
P2P message system design
Awarded 8 hours ago
How to fetch transaction details for Logs Table in SQL Server
Awarded 15 hours ago
Is there a way to alias columns for reference in subqueries?
Awarded 18 hours ago
In Postgres 9.6, why is the GIN index not used for a JSONB column with text/int array?
Awarded yesterday
Specifying Order of Executing Stored Procedures [on hold]
Awarded yesterday
Application/MS SQL Server Express Installer
Awarded yesterday
Oracle function based index with empty function name
Awarded yesterday
Change postgres default behavior for connection to database when dbname not supplied
Awarded yesterday
Return rows that meet a condition in two different columns
Awarded yesterday
SQL Server Plan Cache and Batch Request ration to Compiles [on hold]
Awarded yesterday
Is there a good reason to put the company name at the beginning of the table names? [on hold]
Awarded yesterday
Is there a way to group the output of a query based on two rows
Awarded yesterday
composite clustered index with partitioning
Awarded yesterday
Is there a possibility of data corruption/lost when inserting large blob data from one table to another table in the same database?
Awarded yesterday
How do I intentionally fragment a SQL Server Index?
Awarded yesterday
SQL Server query scanning more partitions than expected
Awarded 2 days ago
Postgres Initial Setup and User Login
Awarded 2 days ago
Postgres permission issues for new views
Awarded 2 days ago
Group by arbitary monthly time period
Awarded Aug 18 at 15:15
Get the full text of a long request
Awarded Aug 18 at 12:20
PostgreSQL naming conventions
Awarded Aug 18 at 11:35
SQL Server Always On Availability Group [on hold]
Awarded Aug 18 at 4:10
Why does updating our database take so long?
Awarded Aug 17 at 23:10
Identifier that starts with is too long. Max length is 128
Awarded Aug 17 at 17:15
Are views treated like a subquery in SQL SERVER?
Awarded Aug 16 at 21:50
Is it bad practice to automate the updating of statistics and re-making of query plans on a relatively small SQL Azure database?
Awarded Aug 16 at 16:30
How to have a “kinda” unique column
Awarded Aug 16 at 16:25
insert results from store procedure with parameters into table
Awarded Aug 16 at 15:15
Is it possible to prevent data loss with Postgres WAL archiving?
Awarded Aug 16 at 15:00
Optimize postgresql query with multiple subqueries
Awarded Aug 16 at 11:25
Select another row if NULL
Awarded Aug 16 at 10:15
Speed up DB restore from file (mysql)
Awarded Aug 16 at 4:20
Ola Hallengren Transaction Log Backups of System Databases
Awarded Aug 15 at 13:40
How to use left join with a subquery
Awarded Aug 15 at 12:15
Efficient SELECT for array of tuples in PostgreSQL
Awarded Aug 15 at 11:05
Displaying data horizontally in mysql [duplicate]
Awarded Aug 15 at 8:05
JSON field saves as longtext datatype
Awarded Aug 15 at 6:05
Trying to count the number of character in a string
Awarded Aug 15 at 4:05
Why do I get “Truncated incorrect date value” when using str_to_date()?
Awarded Aug 14 at 19:25
Any benefit to having multiple filtered indexes?
Awarded Aug 14 at 17:40
Cannot login in as root user after MySQL installation (RHEL)
Awarded Aug 14 at 16:40
Prevent COUNT() Subquery using window functions
Awarded Aug 14 at 14:15
Help defining a chained one-to-many relationship tables
Awarded Aug 14 at 14:10
Multiple versions of PostGIS and PgRouting on CentOS 7
Awarded Aug 14 at 12:45
Configuring SQL Server for SSL Encryption
Awarded Aug 14 at 10:25
Converting SELECT subquery to LEFT JOIN doesnt return same value
Awarded Aug 14 at 8:05
Impact of changing server machines names with SQL Server 2016 Standard in mirror state
Awarded Aug 14 at 6:35
Is it possible to commit a transaction that is waiting to RollBack?
Awarded Aug 13 at 14:45
Upgrade from MariaDB 10.3 to MariaDB 10.4 with Galera Cluster - mysql.global_priv table
Awarded Aug 13 at 14:30
Can I bulk insert into an empty page-compressed table and get full compression?
Awarded Aug 13 at 14:25
Cannot set READ_COMMITTED_SNAPSHOT to OFF on Azure SQL
Awarded Aug 13 at 12:15
Disable dbo schema fallback when table doesn't exist in default schema
Awarded Aug 13 at 11:30
History of cluster failover
Awarded Aug 13 at 8:00
Count two different columns from two different tables and throw into a single variable
Awarded Aug 13 at 6:20
Summing the count of two columns in postgres that contain the same value
Awarded Aug 12 at 23:05
1 2 3 4 5 … 319