Dba Help

GROUP BY with date ranges when values change but then change back

sql-server t-sql query
Updated October 19, 2019 00:06 AM

MySQL returns more than one row with AND operator match

join mysql-5.6
Updated October 18, 2019 23:06 PM

Does postgres single-user mode use postgresql.conf settings?

postgresql postgresql-9.4
Updated October 18, 2019 22:06 PM

Storing 450,000,000,000 data points in a bitemporal datastore

database-design scalability time-series-database
Updated October 18, 2019 22:06 PM

Without rewriting this query, is there a way to force the query optimizer to better estimate the amount of resources required, e.g. with query hints?

sql-server sql-server-2008-r2 query-performance optimization hints
Updated October 18, 2019 22:06 PM

Restore plan cache and buffer pool after database restore?

sql-server restore plan-cache buffer-pool
Updated October 18, 2019 21:06 PM

Is there a way to increase the speed of the following insert without having to create an unclusterd index being suggested by sql server?

sql-server insert
Updated October 18, 2019 20:06 PM

How can I import the fga_log$ table with impdp Oracle 12 R1

oracle oracle-12c audit impdp expdp
Updated October 18, 2019 20:06 PM

How to add time from a Date value to another without a varchar conversion?

oracle query datetime date
Updated October 18, 2019 20:06 PM

Analyze Table running constantly on a few tables

oracle-12c goldengate
Updated October 18, 2019 19:06 PM

Postgresql v10.1 - How to fix ERROR: duplicate key value violates unique constraint

postgresql amazon-dms
Updated October 18, 2019 18:06 PM

looking for missing indexes in the cached execution plans

sql-server index query-performance sql-server-2014 execution-plan
Updated October 18, 2019 16:06 PM

Permissions using a TYPE as a Table Valued Parameter

sql-server sql-server-2014
Updated October 18, 2019 16:06 PM

Can we copy data from 1 text file to 2 postgresql tables?

postgresql copy
Updated October 18, 2019 16:06 PM

Recommended ways to export large query result to JSON or other text format

sql-server
Updated October 18, 2019 16:06 PM

Can you edit DB content, if you can't access phpmyadmin?

mysql phpmyadmin
Updated October 18, 2019 16:06 PM

Session ID in SQLCMD running multi-batch script

sql-server sqlcmd session
Updated October 18, 2019 16:06 PM

Select data from table join or UDPATE?

postgresql performance update
Updated October 18, 2019 16:06 PM

UPDATE column to MIN of a SELECT result set - what went wrong?

sql-server select update
Updated October 18, 2019 16:06 PM

Insert set value into DB

sql-server-2017
Updated October 18, 2019 16:06 PM

Showing Page 1 of 2753