Database Administrators Questions, Problems & Solutions : TransWikia.com ~ Page 25

How to sort query filename output like Windows explorer?

i would like to order my query output the way Windows Explorer does. First special characters like _, then the numbers, and the letters last._ttt.bmp0.gifbbb.png...

Asked on 10/28/2021 by Gunnar

1 answer

mysql upgrade 5.0.45 to 5.1.7 and problem query

Have been working on a migration the past few weeks, and we have run into a mysql specific problem. After creating a new VM, faster server than the old, we...

Asked on 10/28/2021 by vivvvi

1 answer

should I select columns before or after join?

I have a join that takes a lot of time: select t1.*, t.b from t1 join (select id, b from t2) t on t1.id = t.id I have an index...

Asked on 10/28/2021

0 answer

How to log into a fresh MariaDB install?

I am usually using Postgres, now I have had to install MySQL/MariaDB to help a friend with some issues. The problem is just - I am not able to log...

Asked on 10/28/2021

2 answer

Query tables with information_schema in pgsql

I am trying to query the tables contained in a schema from an insert trigger on another table. My process is :Manually create the schema with DB Manager inside...

Asked on 10/28/2021 by Boodoo

1 answer

Designing golf pro scheduling into POS

I have an existing Point of Sale app that is used for golf courses. I have a new feature request from one of my courses that would allow users of...

Asked on 10/28/2021 by Jarrette

0 answer

Linked server returned message "Query timeout expired."

We have two separate SQL Servers. On one server we have a data warehouse (DWH), on the other we have sales information database. Now on the DWH server there is...

Asked on 10/28/2021

2 answer

Unable to Create new Maintenance plan in SSMS 2017

Hi I have reinstalled SQL Server 2016 in my database server last day.I am able to connect to SQL Instance(SQL-02) using the SSMS 2017 i had earlier in the...

Asked on 10/28/2021 by user9516827

1 answer

Mysql self Join query with Limit never terminates

I'm running an experiment with the querySelect Distinct table_1.id1, table_2.id1 FROM image as table_1, image as table_2 WHERE table_1.id2 =...

Asked on 10/28/2021 by Rainer Yuan

1 answer

Why is index not being used? Can I replicate plan?

I have been tuning a query/ indexes in a dev environment, but cannot replicate the new query plan when applying the same changes to a UAT environment. Specifically, in the...

Asked on 10/28/2021 by JShark

2 answer

Ask a Question

Get help from others!

Database Administrators : Recent Questions and Answers (Page 25)

Ask a Question