Database Administrators

Help Center > Badges > Scholar

 Scholar
Ask a question and accept an answer.
Awarded 19994 times.
How can I see the plan for ONE statement in a stored procedure?
Awarded 4 hours ago
We need to do encryption in transit in mongodb so which one is recommended ssl or tsl ? and what is the difference between ssl and tls? [closed]
Awarded 6 hours ago
What are the real life uses of role based authentication control in a database?
Awarded 6 hours ago
Determine Order Streak
Awarded 22 hours ago
order of inserting record is mismatching
Awarded yesterday
Virtualized SQL Server hits 100% CPU and 0 Active Memory
Awarded yesterday
What is the `TABLE example` syntax called?
Awarded yesterday
You do not have permission [closed]
Awarded yesterday
i want fetch json data in mysql [closed]
Awarded yesterday
How to denote separate records as “one and the same”?
Awarded yesterday
Is there any workaround to make Firebird v2.5 under Arch Linux attach existing databases and open them?
Awarded yesterday
Database in postgresql with missing rows, how to fill the missing rows with a backup copy?
Awarded yesterday
In Oracle 12c, is there an alternative to CREATE TYPE when I only have read-only privileges?
Awarded yesterday
SQL Server White Papers vs Books Online - What's the difference and where are the white papers? [closed]
Awarded 2 days ago
Why mysql throws “invalid default value for field” only when two or more timestamp fields exist in the create statement?
Awarded 2 days ago
Why MongoDB needs to disable majority read concern for PSA architecture?
Awarded 2 days ago
Is there a server option which limits the amount of rows returned by a remote query?
Awarded 2 days ago
Additional Select statement within Cursor terminates looping unless Select statement returns a results for all cursor rows
Awarded 2 days ago
Share single index for multiple linearly correlated columns
Awarded 2 days ago
SQL Server strategy for high availability with batch drop/create updates [closed]
Awarded Jan 21 at 17:55
Microsoft SQL Server equivalent to Oracle Enterprise Manger Top Activity Interface?
Awarded Jan 21 at 17:15
Query data that does not fulfill constraints in table in Oracle DB
Awarded Jan 21 at 16:15
Is it Possible To Take Full And Differential Backup in Postgresql Like Sql Server?
Awarded Jan 21 at 12:50
Finding Missing Inverse Relationships
Awarded Jan 21 at 9:05
Oracle: Connects with sqlplus but not from perl
Awarded Jan 21 at 7:40
postgresql count null and blank value from jsonb column
Awarded Jan 21 at 2:35
Missing data for one schema in pg_dump
Awarded Jan 20 at 15:15
Is it possible to accidentally use some paid feature in Oracle XE database while in an Enterprise environment?
Awarded Jan 20 at 13:25
Oracle EM 13c automatically logged in as dbsnmp
Awarded Jan 20 at 10:30
How to force mysqldump to produce /*!40101 SET character_set_client = utf8mb4 */;
Awarded Jan 20 at 10:20
Retrieving users by their age efficiently
Awarded Jan 20 at 9:40
MSSQL Join between big and empty tables
Awarded Jan 20 at 9:05
PostgreSQL dump distinct column without memory consumption
Awarded Jan 20 at 7:25
Multiplexing control files error
Awarded Jan 20 at 4:20
SQL Server 2017 - Parameter Sniffing
Awarded Jan 17 at 20:20
Calculating tsrange based on parent/child created dates
Awarded Jan 17 at 18:55
SQL Server Log Shipping for Server Migration - What's the final step?
Awarded Jan 17 at 18:20
GUID vs Identity on a table performance [duplicate]
Awarded Jan 17 at 17:35
Running a query on the results of another query?
Awarded Jan 17 at 13:55
Meaning of FETCH_CURSOR jconnect_implicit_1 in Sybase
Awarded Jan 17 at 13:55
Copy database removed source - Cannot acces mdf file
Awarded Jan 17 at 13:50
How to split field and run sub query using it?
Awarded Jan 17 at 12:50
SQL Server Agent crashes when scheduled procedures make select in DBLink on an offline Oracle database
Awarded Jan 17 at 12:25
Looking up which record(s) correspond to a specific resource description in dm_tran_locks
Awarded Jan 16 at 16:20
Cannot connect to Postgres DB
Awarded Jan 16 at 14:45
PostgreSQL remove numbers before first comma
Awarded Jan 16 at 14:05
Modify table by squashing rows by truncated hour
Awarded Jan 16 at 10:45
Clustered index and Non clustered index [duplicate]
Awarded Jan 16 at 9:15
Generated DDL doesn't match with CREATE TABLE statement
Awarded Jan 16 at 7:00
How do I insert a limited number records to TableA from TableB , where TableC contains the list of records to insert? [closed]
Awarded Jan 15 at 18:30
How to upgrade SQL Server 2016 and 2017 Standard to 2017 Enterprise edition
Awarded Jan 15 at 17:05
Getting one record per Emp_ID
Awarded Jan 15 at 16:35
Create a view with distributed Lobs
Awarded Jan 15 at 16:00
Delete Data in Two Tables Based on Date in One Table
Awarded Jan 15 at 15:20
Handling Big Data
Awarded Jan 15 at 2:40
Table Partitioning Using Inheritance and Triggers
Awarded Jan 14 at 21:40
Add timestamp to field automatically in PostgreSQL
Awarded Jan 14 at 20:25
sqlite: attached database doesn't work properly
Awarded Jan 14 at 17:05
See UPDATE permissions at column-level for all tables in a database [closed]
Awarded Jan 14 at 15:15
Microsoft SQL Server 2014 Nested From Query in Cross-Apply
Awarded Jan 14 at 10:30
1 2 3 4 5 … 334