Find answers to your questions about Database Administrators or help others by answering their Database Administrators questions.
I have a maintenance plan that runs on SQL Server agent as a the job and finishes with error. However the error is not visible in job history in SSMS,...
Asked on 09/02/2020 by Vojtěch Dohnal
1 answerI'm using WordPress to host a website, and for years, I've been using plugins to perform maintenance (delete revisions, expired transits, optimizing table, etc.) on the msyqls database, but I've...
Asked on 08/26/2020 by mhweb
0 answerI want to get 00:00:00 of a day. Should be done without using CONCAT. What options are there? We can use CURDATE() function in select query but need to...
Asked on 08/25/2020 by Logu
4 answerWhich would generally be more efficient, or does it not matter?Option 1 is incrementing a count in a table that stores counts by the unique id, and resetting the...
Asked on 08/24/2020
0 answerI'm working on an app that imports spreadsheets from Google Sheets API and I've been struggling for days with an efficient way to model the data. As you know PostgreSQL...
Asked on 08/23/2020 by Ivor
0 answerDoes anyone know if it's possible for two different backup utilities to be used to backup the same Oracle database? Both utilities would use RMAN. So, for example, take an...
Asked on 08/21/2020 by Franco
1 answerI want to compare and check whether the values in columnA of table A exist in column A of Table B. But the columnA consist of duplicate values in both...
Asked on 08/18/2020 by deepak garg
3 answerI have a database which now needs to support 4 byte characters (Chinese). Luckily I already have MySQL 5.5 in production. So I would just like to make all collations...
Asked on 08/14/2020 by geoaxis
10 answerI have an issue with an SSIS package, that when deployed via VS2017 to the integration services catalog is not actually being deployed. This is an individual package deployment, and...
Asked on 08/14/2020 by SteveG
1 answerI have two availability group on the same SQL Server 2012 Instance (synchronous commit).Trace flags 1118 and 1117 are both enabled.TempDB has been growing for about two weeks:...
Asked on 08/13/2020 by Gio
1 answerGet help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP