Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
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 answerHave 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 answerI 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 answerI 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 answerI 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 answerI 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 answerWe 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 answerHi 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 answerI'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 answerI 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 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP