All Questions

Filter by
Sorted by
Tagged with
0
votes
2answers
39 views

on deleting a row, the update logic is run also

I am using a after insert, update delete trigger. When I insert a record in my application called as clarity, it inserts a row in the test table with the value as 'Insert' When I update the record ...
2
votes
1answer
43 views

RMAN - How to add date in backup tag

I know that the default of the RMAN is to add the date in the following format: TAGYYYYMMDDTHHMMSS, But if I wanted something like this: BKP_FULL_11112019. How I do this? I tried using %T but it does'...
0
votes
1answer
19 views

MySQL Partial Transactions

I am experiencing some strange behavior in MySQL using transactions. We have a PHP site that runs ~100 workstations inserting thousands of items (table 1) daily, with 4 to 7 logged events (table 2) ...
4
votes
4answers
193 views

Is fragmention limited to indexes in sql server?

As far as I can see with research the only thing that fragments is indexes no other objects in SQL can fragment. I have to keep track of fragmentation within multiple databases, would it be correct ...
0
votes
0answers
25 views

Need to move ssis package from SQL server 2008 to 2012

We have to move ssis package from SQL server 2008 to 2012 on another server. Package on source is stored in msdb. What is the best way to move the packages to 2012?
1
vote
1answer
335 views

How to use postgresql service file in pgadmin4 [on hold]

My service file is working well in PgAdmin3 and in QGIS. I'm trying to use the same service file in PgAdmin4. But no luck, I still have the same message: Unable to connect to server: definition of ...
3
votes
0answers
22 views

Migrate large (200GB) mysql databases to new hosts with as little downtime as possible

My question is about migrating large amounts of mysql data with as little downtime as possible. I have 3 mysql databases that need to be moved from one RDS instance inside a VPC into a brand new AWS ...
8
votes
1answer
366 views

Is there a way to easily validate that a SQL Script is compatible with a specific SQL Server version?

I am currently working on a project that needs to operate in different SQL environments. Most of my developers have SQL Server 2017. The application runs in SQL Azure, and the client has recently ...
1
vote
2answers
152 views

Online Schema change when DB has existing triggers

I'm doing some due diligence before attempting a MariaDB schema change that really needs to be performed online, but seems like I'm going to have issues with the existing DB triggers in using a tool ...
2
votes
1answer
20 views

How can I successfully decrypt column data through the whole database safely?

We're moving to Azure SqlDb but as part of that, we're needing to migrate away from EncryptByPassPhrase as it's not supported. As such, we tried the process on the weekend but we ran into the log ...
1
vote
3answers
36 views

Why is != not working? how to compare with null values? [duplicate]

I am having a hard time understanding why the following query is not working? select id,sold_dealer_id from myi_corporate where sold_dealer_id != 36; When I do the following I am getting the result ...
0
votes
0answers
10 views

MySQL Connection Error for TDV

I am trying to connect to a MySQL database using Tibco Data Virtualization Studio (TDV). I was able to connect to the database using MySQLWorkbench. I checked my.cnf and skip-networking is not ...
1
vote
2answers
209 views

How can I decide Rebuilding Index with DETAILED or SAMPLED on SQL Server

I want to rebuild my indexes and statistics on DB. How can I select this option on production maintenance. SQL Server Version : Microsoft SQL Server 2012 - 11.0.2100.60 (X64) (Build 7601: Service ...
0
votes
1answer
17 views

How to convert a VARCHAR DD/MM/YYYY H:MM:SS AM into datetime and then to Json date?

So I know this question is crazy. I just spent days trying to solve this but i think it's impossible. I have a table with a CreatedDate as a VARCHAR field. 10/7/2019 7:12:59 AM What I need to to ...
0
votes
1answer
20 views

SSMS.exe Access Denied

have a new Win10 pc and need run MSSQL Management Studio as a different user. However when I do so I get error: C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Ssms.exe ...
1
vote
0answers
11 views

sysarticles Status 57

I am looking at the data kept in the various SQL Replication tables. I am trying to understand what information is available and what it means. In this example I have push replication on the ...
0
votes
2answers
328 views

SQL - referential integrity - Foreign key and Check constraint

Please let me know if below two declarations are same. create table R1 ( a INT PRIMARY KEY, b INT references K(w)); Note: K is a table with single attribute w as primary key create table R1 ( a ...
0
votes
1answer
25 views

Database Maintenance - Frontend Testing [on hold]

i would like to know your view about my current responsibilities. I am the owner of a IIS Application that only serves one purpose, to measure and answer performance related questions, these ...
0
votes
4answers
53 views

Alternative to Triggers

I am working on an oracle database and want to record the exact time of any transaction happening on a specific table in the schema. Using triggers on that table is out of question as the client do ...
0
votes
1answer
31 views

Cannot connect database as sys as sysdba using sqlplus

I am new to oracle server 18c (currently taking online course). My problem is sql*plus where I tried to use sqlplus then sys as sysdba (it did not work) and the error appeared below. However, if I ...
0
votes
3answers
38 views

Database Mirror - Host can not be reached or does not exist

I tried mirroring database with GUI and T-SQL, but I had problems in both cases. Here is some information about infrastructure and SSMS: INFRASTRUCTURE Principal server with SQL Server 2017 ...
1
vote
1answer
33 views

can I do a restore controlfile from autobackup out FAST RECOVERY AREA?

I know that I can issue the command restore controlfile from "location_here". But there is some config that can I do for issue the command restore controlfile from autobackup even whether the ...
-1
votes
1answer
2k views

PowerShell error for installation SQL Server 2012 RTM Developer on Windows 7 X64 [on hold]

I had a lot of grief with upgrading from 2008 R2 and PowerShell. Created a thread but doesn't seem to be promising to solve it, so de-installed, and now I am installing from scratch 2012 . And ...
0
votes
0answers
7 views

Database .ibd files totally lost no access to database [on hold]

A very weird problem happened yesterday to multiple db's. Most of them are restored from backup but I've left with 3 of them without data. MySql is on 5.4 version. DB's are completely missing most of ...
2
votes
0answers
22 views

SQL Server update from GDR to CU-17 [duplicate]

I'm using SQL SERVER 2017 GDR version 14.0.2002.14. I want to upgrade to the latest possible version of SQL Server 2017. My question is can I download CU-17 and directly run the latest cumulative ...
-3
votes
1answer
42 views

login not having permission to see sql server properties

I need a login and that login should not view the sql server properties i.e.,login should not have permission to execute command select @@version
1
vote
0answers
121 views

Understanding pg-pool in details

I have following problem regarding the pg-pool (3.3.3) When master fails, automatic failover happens and standby is promoted to master. But this new master don't have any replicators. Other slave ...
0
votes
1answer
10 views

Can't delete Xampp from my laptop (windows 7) [on hold]

I want to delete xampp from my laptop but its showing as I have mentioned below: the action can't be completed because the folder or a file in it is open in another program. close the folder and try ...
0
votes
1answer
29 views

Delete comment - actually delete it, or create `deleted` column and update it?

I'm really not sure if this is the right community to ask it in, but it seemed like it fits here. But anyway, I'd like to know what's the usual approach of deleting a comment from database through ...
2
votes
1answer
26 views

How to get more physical details when executing an SQL query?

I want to get some physical features about a SQL query execution with PostgreSQL, like Read/write page accesses I/O operations Response time Sequential I/O throughput rate Deadlocks Pages scanned ...
1
vote
1answer
21 views

Speeding up very slow UPDATE query (Postgresql 9.6)

In a app called Links, users post interesting content they've discovered recently and others can comment on these posts. There's also an additional functionality, one that allows users to leave a ...
4
votes
3answers
12k views

How to create a flexible table schema for storing messages from different chats?

Help please solve the following situation: There are two kinds of API where message history is stored, it's Zopim and Chat2Desc (import into Postman). While these two but can then others appear. And ...
0
votes
1answer
517 views

MySQL won't start on ubuntu 16.04 - apparmor=“DENIED”

When tried to log in to the MySQL server yesterday I received the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) When I ...
6
votes
2answers
31k views

How group with min(date) and select an another column in the same table

I have a query who return something like it : Name Gender Job date of hire John M mechanic 2012-05-08 John M electrician 2010-01-01 Vicky F scientific 2012-11-11 Bob ...
5
votes
1answer
211 views

Does the Query cost in Sql Server account for buffering?

If I am comparing 2 queries by checking their relative "Query cost" as a high level indicator of performance, does the buffer status have any effect on the values shown in the execution plan?
0
votes
0answers
7 views

Cluster or shared collections in logical aggregate groups [on hold]

We have date specific trading data for about 10M trades. Each day's data comprising ~1T data in different collections like market, trade, settlements etc. Since we would not need more than 3 days ...
9
votes
2answers
8k views

SELECT/INSERT Deadlock

This instance hosts the SharePoint 2007 databases (SP). We have been experiencing numerous SELECT/INSERT deadlocks against one heavily utilized table within SP content database. I have narrowed down ...
3
votes
2answers
92 views

Why max(id) with join not working or how to optimize it with join?

Below is my MESSAGES_THREAD table: CREATE TABLE `messages_thread` ( `id` varchar(64) NOT NULL, `creator` mediumint(9) NOT NULL, `other` mediumint(9) NOT NULL, `time` datetime DEFAULT ...
1
vote
1answer
31 views

Compatibility level of databases based on sql server version

We need to check for databases that are not in the correct compatibility level on a particular instance. For example, on a SQL Server 2016 instance, if there are databases that are not in ...
0
votes
2answers
139 views

MySQL replication - independent data update on slave

I have an unusual situation where I am migrating websites and their corresponding databases from one server to another. I have a database that is hosted on one server, A, where new records are ...
-3
votes
0answers
8 views

How to merge multiple excel sheet into one access database using access form [on hold]

I need to create one form , in that form I will put one button. If I click that button it will merge all the excel files into one access database.
1
vote
2answers
20 views

Question on conditional join or other way to create view based on two tables in Postgresql

I am trying to create a view that combines these two materialized views with following rules. if all_products.id and there is matching id (market_id not relevant) in visible_products then only ...
-8
votes
1answer
94 views

What column size should I use? [on hold]

When I design a database schema, what is the max length value I should use on my columns? Please tell me the maximum length possible for various content according to standards.
-1
votes
1answer
139 views

Syntax error near '.`value)` != '') in 5.1.73

Is the following sql statement is supported in mysql 5.1.73? error: Syntax error near '.`value)` != '') AND (`IF(address`.`value IS NULL, main_table`.`address, address' at line 4 SELECT `...
-1
votes
0answers
13 views

how to optimise update using subquery in PostgreSQL

I have got a table with just above 30million records and I have been running this query but I then realised that it is somehow taking too much time update foo_bar set bd_length =foo.total_length ...
2
votes
0answers
27 views
+100

Does timestamp protocol following thomas's write rule allow non-view-serializable schedules in some cases?

I have came across following line in text book (Database System Concepts Textbook by Avi Silberschatz, Henry F. Korth, and S. Sudarshan $6e$) page no. 686: Thomas’ write rule allows schedules that ...
1
vote
1answer
40 views

How to get First in and Last out with multiple records?

I have this records and it is attendance of each employee. I'd like to get their attendance, what i have tried Query is like this which is getting their attendance but if it has a multiple record it ...
-1
votes
1answer
503 views

pg_restore error while initializing

I am getting the error of: pg_restore: [archiver (db)] Error while INITIALIZING: pg_restore: [archiver (db)] could not execute query: ERROR: unrecognized configuration parameter "...
0
votes
1answer
169 views

Restoring a FrontBase database

I have a FrontBase database that I am trying to restore. This is a database system I have no experience up until now so this may be a basic question. I am issuing the following command to restore c:\...
0
votes
1answer
238 views

Query optimization with conditional group by and where

I've a DB with events, workshops in each event (1:N), participants in each workshop/event(N:M), role of participant in each workshop, and a table (letture) with access control for each participant in ...

15 30 50 per page