table related queries in DbaXchanger | QueryXchanger

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

What is the meaning of minimal key?

table
Updated November 29, 2018 12:06 PM

In SQL, how many tables must be defined to save SIMILAR columns relatively to specific fields ?

relational-theory table ddl
Updated November 28, 2018 12:06 PM

Error 2013: Lost connection during Query when dumping the table

innodb backup mysql-5.6 alter-table
Updated November 28, 2018 07:06 AM

What are the advantages of using a Materialized View directly on a table?

oracle table materialized-view
Updated November 27, 2018 10:06 AM

When would exclusive lock escalate from row level to table level when I delete data from my table?

sql-server-2012 locking table delete lock-escalation
Updated November 26, 2018 13:06 PM

Pivot information - sql table

table pivot
Updated November 24, 2018 23:06 PM

Huge table: split it for 'last day table' and archive table OR a use a view for the last day?

sql-server optimization view table
Updated November 24, 2018 20:06 PM

Modifying table structure within a transaction?

oracle schema alter-table flashback
Updated November 14, 2018 09:06 AM

How to LOCK/BLOCK selected row in table to be ReadOnly?

mariadb table
Updated November 09, 2018 15:06 PM

Can I rename the values in a MySQL ENUM column in one query?

mysql alter-table
Updated November 06, 2018 17:06 PM

How costly is changing column datatype in PostgreSQL?

postgresql database-design postgresql-performance datatypes alter-table
Updated November 03, 2018 21:06 PM

How to structure table in MySQL for group chat application?

sql-server mysql database-design table mysql-8.0
Updated November 03, 2018 20:06 PM

Efficiently bulk upsert unrelated rows

sql-server transactional-replication etl upsert table-valued-parameters
Updated November 01, 2018 20:06 PM

Add NOT NULL constraint to large table without table scan

postgresql postgresql-9.3 alter-table
Updated October 31, 2018 16:06 PM

Adding a ROW_NUMBER() with no column to ORDER BY?

sql-server-2017 syntax number-table
Updated October 29, 2018 21:06 PM

Is mysql using some kind of auto repair due to "check table" warnings?

mysql mysql-5.5 table corruption debian
Updated October 27, 2018 14:06 PM

change column type from integer to varchar

postgresql alter-table
Updated October 21, 2018 13:06 PM

Display values of joined tables WHERE table 2 col equals something

sql-server sql join table split
Updated October 16, 2018 01:06 AM

Quickly change NULL column to NOT NULL

sql-server-2008 null alter-table
Updated October 14, 2018 08:06 AM

How do I add a partition to an existing table in mariadb / mysql?

mysql mariadb table
Updated October 10, 2018 12:06 PM

Galera 'ALTER TABLE .. ADD COLUMN' causes 'end of stream, read 0 bytes from 4 (socket was closed by server)' expection

replication mariadb alter-table galera mariadb-10.1
Updated October 09, 2018 13:06 PM

How to acquire a table result set from "Table - valued function" when the result set has variable structures?

sql-server t-sql set-returning-functions table-valued-parameters
Updated October 08, 2018 07:06 AM

Update two tables, each on separate MySQL servers, on two different machines in one query?

mysql replication php table
Updated October 05, 2018 19:06 PM

Converting float4 to numeric in PostgreSQL is rounding the values

sql postgresql alter-table postgresql-10
Updated October 04, 2018 13:06 PM

How to design a mobile inventory database such that new feature and feature description can be added for a particular device separately?

mysql database-design table
Updated October 03, 2018 08:06 AM

DB2 huge IREF and lots of scans

index db2 table scan
Updated October 02, 2018 22:06 PM

structuring media uploads (users, images, videos) using sequelize.js

postgresql database-design table psql
Updated October 01, 2018 02:06 AM

how to dispaly null records/rows from oracle table

oracle table null
Updated September 26, 2018 16:06 PM

Alter table on live production databases

mysql sql postgresql alter-table
Updated September 25, 2018 16:06 PM

Reasons for not Globally enabling Trace Flag 2453 - Cardinality on Table Variables

sql-server sql-server-2014 temp-tables table-variable
Updated September 24, 2018 23:06 PM

Representing lists in SQL

mysql table array
Updated September 22, 2018 10:06 AM

Trigger with a Variable Select and Order by

sql-server trigger table
Updated September 20, 2018 02:06 AM

SELECT in federated table is to slow

mysql federated-table
Updated September 14, 2018 11:06 AM

Does SQL server automatically update the foreign key relationships between tables when one of those tables is renamed?

sql-server sql-server-2008-r2 foreign-key table
Updated September 13, 2018 14:06 PM

IDB file Maximum kb limit

mysql innodb table
Updated September 12, 2018 08:06 AM

Sql Server 2017 log file growth with memory optimized table

transaction-log memory table sql-server-2017
Updated September 07, 2018 09:06 AM

How can I instantly update a table in a database with the columns values from another database?

mysql update table
Updated September 05, 2018 17:06 PM

size table ... and partitioning it?

oracle table datafile
Updated September 04, 2018 18:06 PM

InnoDB "holes" in large table 200 Million Rows?

mysql innodb table ssd
Updated September 04, 2018 18:06 PM

'DROP TABLE mysql.failover_console;' replicates to slaves, but 'Use mysql; DROP TABLE failover_console;' does not

mysql replication mysql-5.6 drop-table
Updated September 04, 2018 08:06 AM

Shrink database after drop table?

sql-server drop-table
Updated September 04, 2018 08:06 AM

Why we can FLASHBACK DROP table where it is DDL command and hence autocommited?

oracle truncate dml drop-table
Updated September 04, 2018 07:06 AM

How to drop table with all reference to this table

mysql sql dbms drop-table
Updated September 04, 2018 07:06 AM

How to export oracle tables/columns from intranet to local or PostgreSQL? Export just all tables without data

postgresql oracle table export
Updated September 03, 2018 04:06 AM

table related issues & queries in DbaXchanger