72,947 reputation
1172166
bio website
location Jersey City, NJ (USA)
age 49
visits member for 3 years, 11 months
seen 2 hours ago

15h
reviewed Leave Closed This Extended Events session works on Dev but not on Pro. Why?
15h
reviewed Reviewed Design Database for Wholesales
15h
reviewed Close How to get best mark for each Student
15h
reviewed Close How to add External data source into MySQL?
1d
revised Dropped connections, corrupted schema … is MySQL sick?
edited tags
1d
reviewed Leave Closed SQL Multiple JOINS Interpretation order
1d
reviewed Leave Closed off-site Dataguard replication status check
1d
reviewed Close Single Transaction across multiple Sql Database
1d
reviewed Close Unable to start SQL Safe service :Error 1053: Could Not Start or Stop the Service in a Timely Fashion
1d
reviewed Close Facing SQL Error 3403
1d
reviewed Close Import Data from SQL Server 2000 to SQL Server 2014
1d
reviewed Close Postgres Enable TCP/IP Connection
1d
reviewed Close Can user defined roles cause problems with colliding permissions?
1d
reviewed Close Query in mysql is not solving
1d
comment MySQL always writes simple temporary/memory tables to disk (both tmp_table_size and max_heap_table_size are set to 8GB)
Doing WHERE 0 or WHERE 1=0 could possibly force an O(n) (order-n) full table scan of website.gallery_likes (just personal fear of that happening), whereas doing LIKE is a O(1) (order 1) structure copy (including indexes). Regardless of website.gallery_likes having 1 row or 1 billion rows, LIKE will take the same amount of time to create.
1d
revised MySQL always writes simple temporary/memory tables to disk (both tmp_table_size and max_heap_table_size are set to 8GB)
edited tags
1d
answered MySQL always writes simple temporary/memory tables to disk (both tmp_table_size and max_heap_table_size are set to 8GB)
1d
revised How to select the largest value of the same column in multiple tables?
added 703 characters in body
1d
answered How to select the largest value of the same column in multiple tables?
2d
reviewed Reviewed sp_send_dbmail fails when mailing queries, but no error returned, query just hangs