Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I have an extended event that tracks and filters login events from specific users. The filter is something like this:WHERE (([sqlserver].[nt_user]=N'fredJohnson') OR ([sqlserver].[nt_user]=N'sallySmith')))What I would really like to do...
Asked on 12/17/2021
1 answerI have an Oracle 12.1.0.2 database that dblinks to an Oracle 10.2.0.3.0 database.I am upgrading the Oracle 12.1.0.2 database to 19c (12.2.0.3). Will my dblinks to the Oracle 10.2.0.3.0...
Asked on 12/17/2021 by Darcy Dommer
2 answerI had to write a simple query where I go looking for people's name that start with a B or a D : SELECT s.name FROM spelers s WHERE...
Asked on 12/15/2021 by Lucas Kauffman
8 answerI am trying to upgrade an installer created with NSIS that installs postgresql. It used to install postgresql 8.3 but we want to upgrade the DB to 9.4.4. The old...
Asked on 12/15/2021 by Bertus Kruger
3 answerI have the following querySELECT SQL_NO_CACHE `table1`.*FROM `table1`LEFT JOIN `table2` ON table2.id = table1.table2_idWHERE (`table2`.`date_assigned` >= '2015-06-21') ...
Asked on 12/15/2021
1 answerWe are running PMM v1.17.0 and prometheus is causing huge cpu and mem usage (200% CPU and 100% RAM), and pmm went down because of this. We are running PMM...
Asked on 12/15/2021 by user5594148
2 answerCan I check whether a global read lock is in place? My application uses MySQL (actually MariaDB) on InnoDB. I'm going to run mysqldump --all-databases, which will impose a global...
Asked on 12/15/2021 by JellicleCat
0 answerI'm trying to grant access to my Azure SQL database (on an elastic pool) to an external developer using SQL Authentication. In the database (not master) I ran the following...
Asked on 12/15/2021 by user2637453
2 answerI have a query:Select <CASE WHEN>, myfunction(param1, <CASE WHEN>)FROM tableBoth the Case When instances are the same set of conditions. So here I am clearly repeating the same conditions....
Asked on 12/15/2021 by Binod Kalathil
1 answerI'm wondering if there is a way to do this in sql server. I have an extended event set up to track all user logins from a database with a...
Asked on 12/15/2021 by datadawg2000
1 answerGet help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP