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

Tag: metadata

How to access the text definition of sql indexes

By adminPosted on March 21, 2023

Question : I am able to access the text definition of stored procedures, views, triggers and functions from sys.sql_modules. I […]

Where to find the OID of a newly created Schema

By adminPosted on March 20, 2023

Question : I have created a new Schema in my Postgres db. I want to replace an OID in the […]

How to GRANT or DENY access to an object based on metadata for that object in SQL Server?

By adminPosted on March 13, 2023

Question : We are in the process of reviewing our database permissions among various applications and business groups on SQL […]

Check another session’s IMPLICIT_TRANSACTIONS setting

By adminPosted on March 4, 2023

Question : In SQL Server, you can find IMPLICIT_TRANSACTIONS value for own session via @@OPTIONS. How to find the IMPLICIT_TRANSACTIONS […]

PostgreSQL – Who or what is the “PUBLIC” role?

By adminPosted on March 2, 2023

Question : I was looking at information_schema.role_table_grants when I saw public in grantee column, then I’ve checked at information_schema.enabled_roles but […]

Cleaning up orphaned metadata in information_schema

By adminPosted on February 28, 2023

Question : OK – so the server (Percona 5.6 in this case) ‘went away’ in the middle of declaring a […]

How do I list or search all the column names in my database?

By adminPosted on February 15, 2023

Question : I want to search for a string in the names of the columns present in a database. I’m […]

Is it a best practice to contrast table and dependent view metadata to target which views to refresh?

By adminPosted on February 13, 2023

Question : We have non-indexed views created on vendor tables. When they change table structure or column definitions we run […]

Postgres metadata: get a list of all MATERIALIZED VIEW columns, with data type, INCLUDING array columns

By adminPosted on January 31, 2023

Question : I need to get metadata about all MATERIALIZED VIEW columns, including their data type. I can do this […]

InnoDB row metadata size (minimum row size)

By adminPosted on January 28, 2023

Question : I’m trying to decide whether to normalize a thing further, and need to know what the smallest a […]

  • 1
  • 2
  • 3
  • …
  • 11

Recent Posts

  • Logins aren’t syncing across Availability Groups
  • Finding same values and updating rankings
  • Servers running on Microsoft Windows instead output carriage
  • Master ip has changed in postgresql replication
  • optimize design for a table with 50 columns [closed]
  • SQLServer In-Memory database and log file size unexpected increase
  • Is it worth to optimize queries with EarlyTermination Timeout?
  • Is there way to get transaction commit timestamp in Postgres?
  • MySQL/PHP Returning Blank Error Message [closed]
  • Mysql might have too many indexes
  • Database replication with ability to revert to previous states
  • Linked server to Oracle doesn’t use filters. Are there any performance changes in different versions of SQL Server?
  • Enable query store for all databases
  • SQL Server 2012 Enforce Password Policy [closed]
  • Maintenance in MYSQL when innodb_file_per_table disabled
  • SQL Server stored procedure producing data related to months between two dates [duplicate]
  • Efficient way to store multi choice in a column with few options
  • Need help tuning my.cnf file
  • Insert and select the row autoincremented id
  • Use “LEN” function in “WHERE” clause in “CREATE UNIQUE INDEX”

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