Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: scripting

MySQL Script to automate creation of audit (history) tables and triggers?

By adminPosted on September 23, 2023

Question : For regulatory and fraud requirements, we need to record every change to most of the tables in the […]

Advice on scripting a “whitewashed” and downsized development db from main db

By adminPosted on September 17, 2023

Question : Currently we (an active opensource project) have a large PostgreSQL production database which contains all the site records. […]

Script to check CPU, memory, server type

By adminPosted on September 10, 2023

Question : Can someone please help me with the script to get CPU, total physical memory, server type(i.e. physical/VM), maxdop […]

Script to Output Tables to CSV Showing Heading Only Once [duplicate]

By adminPosted on September 2, 2023

Question : This question already has answers here: How can I unload Oracle database tables into a csv files? (4 […]

Does SQL Server / T-SQL support line-continuation to break up long strings?

By adminPosted on August 31, 2023

Question : I sometimes have a SQL script that has one or more super-long (sometimes even stupid-long) strings. Typically these […]

ORACLE_HOME / ORACLE_SID variable – why do we need to export them ?

By adminPosted on August 30, 2023

Question : I am not sure if this is a bash / shell question or oracle question. I am on […]

script all triggers in a database

By adminPosted on August 29, 2023

Question : I have a few databases involved in replication as subscribers and they have triggers and are used by […]

How to manipulate bytea data when using backup script as a template

By adminPosted on August 25, 2023

Question : I have a project with a web app that has many configurable options, with the configurations stored in […]

Use sp_Blitz to gather information on all servers in a centralized server/database

By adminPosted on August 1, 2023

Question : I am using sp_Blitz, and want to use it to execute the checks on all of my SQL […]

script to find all bigint that can be converted to int fields in postgresql performance

By adminPosted on July 25, 2023

Question : I want to compact a postgresql 11 db and my idea is to convert lots of bigint to […]

  • 1
  • 2
  • 3
  • …
  • 21

Recent Posts

  • Macroeconomic Time-Series Database
  • OUTER JOIN with join condition causes unexpected results
  • Need help with my.cnf: 32GB RAM and 3GB of InnoDB tables
  • How to model an activity feed
  • trigram matching on a jsonb array
  • Trigger to prevent update when Flag value is 1
  • SQL, SQLCLR objects & effective memory utilization
  • Queries on Mongo Secondary are not equally distributed
  • Timezone offset displayed though it shouldn’t be stored
  • Use composite type to create new table
  • what is ‘#’ in create table statement?
  • how to avoid duplicated column in two different tables?
  • RMAN – Archivelog deletion policy ignored
  • Query runs quicker when column calculation is done after initial query
  • Generating Error when data size is larger then max text repl size
  • mysql: Is mysqladmin -p create equivalent to create database?
  • Recovering from removal of ibdata1 [duplicate]
  • Reviewing all code on a SQL Server Instance
  • Select query on 8 million records with greater and less than columns (Slow)
  • Database Performance Tuning

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding