table related queries in DbaXchanger

Generate metadata file from PostgreSQL server

postgresql table metadata documentation
Updated March 18, 2019 11:06 AM

Generic TVP tradeoffs?

sql-server table-valued-parameters
Updated March 17, 2019 17:06 PM

How can one drop all default values and allow NULL for all columns of a table?

mysql php primary-key alter-table
Updated March 13, 2019 07:06 AM

Find when tables were deleted historically

sql-server-2014 drop-table
Updated March 11, 2019 16:06 PM

How to name table-variable function unique constraint?

sql-server-2012 t-sql unique-constraint table-variable table-valued-functions
Updated March 11, 2019 09:06 AM

Left join SQL Select Statement

sql-server select table
Updated March 07, 2019 03:06 AM

How to create a table in a database on a different server

sql-server database-design table
Updated March 07, 2019 02:06 AM

Combing two queries in one

query aggregate table
Updated March 06, 2019 07:06 AM

Database table not being recognized

sql-server table
Updated March 05, 2019 20:06 PM

How to create multiple tables based on existing tables in postgreSQL?

postgresql table postgresql-10
Updated March 05, 2019 19:06 PM

does index tree start to be created as soon as data is inserted into table?

index table tree data-pages
Updated March 04, 2019 14:06 PM

Should a TeamMembers table have a relationship with the Student Table or the Enrolment Table?

database-design table erd
Updated February 27, 2019 07:06 AM

Alter a serial column to bigserial on-the-spot if there's 4 bytes of padding available?

postgresql alter-table
Updated February 26, 2019 22:06 PM

How to group related information: Another table vs Same table

mysql table
Updated February 26, 2019 21:06 PM

schema of messaging system

mysql table
Updated February 26, 2019 12:06 PM

Questions on Database table and Index partitioning in SQL Server

sql-server sql-server-2008 index partitioning table
Updated February 20, 2019 11:06 AM

How can I have intensive stored procedures run on a different machine to where tables are stored?

mysql stored-procedures mariadb federated-table
Updated February 16, 2019 06:06 AM

SQL Server Database Table Partitioning Consideration

sql-server partitioning best-practices table
Updated February 10, 2019 10:06 AM

Oracle credentials format is encoded?

oracle users encoding table-valued-parameters
Updated February 07, 2019 06:06 AM

mysql table replication on just some records?

mysql replication table condition
Updated February 05, 2019 08:06 AM

Is it possible to run a trigger on Table Creation in MySQL

mysql trigger table
Updated February 03, 2019 00:06 AM

Should I create new table for each User to store their product List?

mysql postgresql table
Updated February 01, 2019 04:06 AM

Create Trigger MySql effects update or insert another table

mysql trigger table
Updated January 31, 2019 00:06 AM

MariaDB/MySQL Connecting 2 different user table into 1 table

mysql relational-theory table users
Updated January 30, 2019 05:06 AM

External Table: VARCHAR in Create but CHAR in Access Parameters

oracle-11g-r2 table varchar
Updated January 29, 2019 17:06 PM

Trigger to drop table only if there are no records

sql-server t-sql ddl drop-table
Updated January 24, 2019 18:06 PM

alternatives to passing temp table as a parameter to a stored procedure

sql-server stored-procedures dynamic-sql parameter table-valued-parameters
Updated January 22, 2019 19:06 PM

Error parsing DDL for schema.table in mysql workbench

mysql mysql-workbench alter-table
Updated January 22, 2019 11:06 AM

Error Code: 1845. ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY/INPLACE

mysql alter-table mysql-8.0
Updated January 22, 2019 06:06 AM

Performance penalty for using thousands of tables in MySQL

mysql performance table wordpress
Updated January 19, 2019 03:06 AM

What makes ALTER TABLE X SET UNLOGGED; to be slow?

postgresql transaction-log postgresql-9.6 alter-table liquibase
Updated January 18, 2019 12:06 PM

Will frequent creation and deletion of TABLE (not indexes) cause fragmentation in database?

sql-server table fragmentation
Updated January 18, 2019 11:06 AM

How to handle id's referring to multiple tables in an SQL database

mysql table
Updated January 15, 2019 17:06 PM

SQL How to show information from others tables in select requet

mysql select table
Updated January 15, 2019 00:06 AM

how to make sure pt-sync-table data is the latest?

mysql percona pt-table-checksum
Updated January 14, 2019 16:06 PM

Slow performance matching columns to lists of values

sql-server query-performance stored-procedures azure-sql-database table-valued-parameters
Updated January 13, 2019 15:06 PM

Syntax error when trying to add columns to table in DBeaver (postgresql)

postgresql errors alter-table syntax dbeaver
Updated January 13, 2019 10:06 AM

Best practise for data dump 'entry point' in DB processing chain - PostgreSQL

database-design table postgresql-10
Updated January 12, 2019 23:06 PM

Converting Varchar to Int error

alter-table varchar convert
Updated January 10, 2019 22:06 PM

database design for song position under play-list

sql-server database-design schema table
Updated January 08, 2019 11:06 AM

Statistics injection for calculating the cost of a query

postgresql table statistics
Updated January 03, 2019 11:06 AM

Creating a database for due dates

table date
Updated December 23, 2018 06:06 AM

More Best Practices To Updating Large Tables?

sql-server sql-server-2008-r2 best-practices alter-table
Updated December 19, 2018 14:06 PM

Table structure for possible duplicated data (link previews table)

database-design table duplication
Updated December 12, 2018 02:06 AM

Get Headers from SQL Table

sql-server-2012 table export bcp
Updated December 11, 2018 11:06 AM

pt-table-checksum mysql 5.6 MASTER_POS_WAIT

mysql-5.6 row gtid pt-table-checksum
Updated December 10, 2018 11:06 AM

Time taken to drop/add index is lesser than adding a column. Why is that?

mysql innodb mariadb alter-table mariadb-10.1
Updated December 10, 2018 09:06 AM

Is it possible to drop inheritance from the parent table (top down)? PostgreSQL

postgresql inheritance drop-table
Updated December 05, 2018 14:06 PM

2 tables, sorted by date specific to service

join table
Updated December 03, 2018 15:06 PM

SQL, creating a new table with auto generated passords from other tables

sql-server select table
Updated November 30, 2018 14:06 PM

table related issues & queries in DbaXchanger