All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
4 views

SQL Server Merge Replication Error: The format of a message during Web synchronization was invalid

I am doing Merge Replication using Web Synchronization. On Subscriber end, there is SQL Express 2012 on Windows 10 Pro. On publisher end, there is SQL Server 2016 on Windows Server 2016. Web ...
0
votes
0answers
3 views

StorageEngineUsed set to TabularMetadata. For databases in this mode, you must use Tabular APIs to administer the database

I am an administrator in SSAS. I have many data warehouse servers. In some servers I have SQL Server and SSAS on the same machine. I successfully backup the SSAS databases and even check if the ...
0
votes
1answer
10 views

Postgres value that never goes below zero

For my application i need to make a row with a value that can never go below zero. I know about check but this one can't fail the query if i do for example: update table set special_row = special_row -...
0
votes
0answers
8 views

Modelling dynamic data types in relational database

I'm about to start work on a fresh project where we want to allow users to create new fields with one of multiple data types and attach those fields to items in the system. This is to make the system ...
0
votes
1answer
22 views

SQL rounding last zeros

I need to store the exact value of a decimal: For example 0.00500 and 0.0050. If I use decimal (10, 5), I receive 0.00500 every time. If I enter 0.0050, I still get 0.00500
1
vote
2answers
10 views

Aggregate results from select queries

I have a table with three columns: id, date, state. For each unique value of id, I would like to select date and state, multiply the state array by a scalar variable for each id defined from else, ...
0
votes
0answers
12 views

ORA-01031: insufficient privileges to a newly created user

I have installed 18C Enterprise Edition. I just created a new user with a prefix of c##. And when I tried to login through the newly created user it says... ORA-01031: insufficient privileges 01031. ...
0
votes
1answer
11 views

Reached maximum possible value for auto_increment function set on column

I'm using a MySQL database. I have set an auto_increment function on "ID" column (which is also set as Primary key). What will happen when it reaches its maximum possible value, according to the data ...
0
votes
0answers
16 views

Changing schema removes replication subscription

I have a replication publication of a database. When I change a table schema that is included in the publication, it removes the active subscription for it. However, the subscriber itself still think ...
-1
votes
0answers
44 views

Performance Issue with Top, Order By and where condition - with million + records

I have a query which looks something like below: Declare @CompanyID as int = 10; Select Top 50 UserID, AuditTypeID , [Action], ActionDate , [Description] , RecordID, S.ID as SiteUserID from ...
0
votes
0answers
7 views

How to find out all the postgresql database cluster data directories (running and Shutdown instances) on linux server

Could you please help us to find below details. How to find out all the Postgresql database cluster data directories (running and Shutdown instances) on Linux server. Regards, Siva.
0
votes
1answer
10 views

Why is a connection via an SSH tunnel presenting as 127.0.0.1 and not localhost?

I have defined a MariaDB user test@localhost and I have skip-name-resolve ON as recommended for performance reasons. I'm able to connect with -hlocalhost -P3306 and so is my web application using the ...
0
votes
0answers
11 views

exceeds the maximum allowed database size when export database oracle 18c

I have worked on Oracle Database 18c Express Edition, while I try to export database schema by using expd command, I have an issues ORA-12954: The request exceeds the maximum allowed database size ...
0
votes
0answers
13 views

Design issue in transitive dependencies between tables

This is a made-up scenario, but I imagine that it can be of general interest, so I'll post it here. Imagine the following business rule: A course has a grade scale that determines what grades a ...
0
votes
1answer
14 views

How to find out unused port on Linux server

We are trying to use port 5444 for our new PostgreSQL instance and we are not sure whether 5444 is used or unused. Could you please help us to find the answers to the below questions. We want to ...
0
votes
1answer
14 views

Dump pglogical Config to files

We use the tool etckeeper to keep track of the configuration of servers. I would like to dump the configuration of pglogical to files for this purpose. I tried this: db@host:~$ pg_dump -t '...
0
votes
1answer
8 views

how to change the driver of a ole_dbconnection from oracle_32bit to oracle_64bit

i have the connection string of: connection= new OleDbConnection("Provider=OraOLEDB.Oracle;UserId=userid;Password=password; Data Source=database;OLEDB.NET=true"); However after Oracle_64bit driver ...
0
votes
0answers
6 views

How to deal with unicode data in SymmetricDs

I have a postgresql data have some unicode tables. I have already setup successful for replication but can not send origin unicode data to SQL server. I have already tried using : mssql.use.ntypes....
0
votes
0answers
10 views

Connection Error while connecting SQL Developer with DB2

I am trying to connect Oracle SQL Developer with DB2 Database. I have added db2jcc4.jar, db2jcc.jar and db2jcc_license_cu.jar Libraries in "Third Party JDBC Driver" DB2 tabs appears Entered Username ...
1
vote
1answer
24 views

How to find out if an index is aligned

I'm struggling to find any confirmation within sql server or sql management studio that my index is in fact aligned with my partition. I'm creating a primary key constraint on a partitioned table: ...
0
votes
1answer
16 views

Postgres backup PITR strategies

Note:-Might be the question sounds too broad. But, I believe ,it's very good platform(stackexchange) and I can get advice from worldwide expert DBA here. Since, I'm not able to make decision or choose ...
0
votes
0answers
7 views

show extended index equivalent for MySQL 5.7

If you look at this documentation for show index in version 8.0, it says SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] The ...
0
votes
0answers
17 views

How do I completely remove MySQL from macOS Mojave?

I'm new to SQL and have only started learning. I've recently installed MySQL on macOS Mojave but found it difficult to use for some reason (given that I'm new to the tool and language). Wanted to ...
1
vote
1answer
18 views

Expressing the largest floating point value in PostgreSQL?

How to express the largest floating point value (for FLOAT8) in PostgreSQL? I need it to replace 'Infinity'::FLOAT8 during conversion to jsonb field values, because json does not allow NaN and ...
0
votes
0answers
7 views

Secure-file-priv error message

I'm using MySql 8 community server on windows 8. Exporting or importing files have been a major challenge. Each time I tried exporting file to the default folder, the "secure-file-priv" error message ...
0
votes
0answers
10 views

can delete manually a .ibd file and .frm file?

I have the following trouble in a mysql server database: 190919 17:35:30 [ERROR] Cannot find or open table abril2017/mexico from the internal data dictionary of InnoDB though the .frm file for ...
1
vote
1answer
5 views

Inherit default privileges: every table created by *any member of* role A is readable by role B

If I do this ... ALTER DEFAULT PRIVILEGES FOR ROLE engineering IN SCHEMA reference GRANT SELECT ON TABLES to analytics; I get ... This syntax runs and has a valid meaning. The way it is ...
0
votes
0answers
6 views

How to log/view remote calls/queries to DB in Toad Data Point?

I am running an Apache Sqoop job from a local computer against an Oracle DB that we connect to via a virtual tunnel and find that for certain large sqoop jobs, the process hangs after a certain X% ...
1
vote
2answers
21 views

Suppress some output from PL/SQL script in Toad for Oracle

Question: In PL/SQL for Oracle running in Toad, can I suppress script output except for certain lines I want to see? e.g. I don't want create table, insert record, drop table. I do want my own ...
1
vote
0answers
22 views

ODBC connects but authentication fails on users table

We have sql 2008 running in mixed mode. The site where sql is running the ODBC connection works and ms access authenticates against the user table. We have an IPSec vpn to a satellite office using ...
0
votes
1answer
24 views

INSERT values from .csv into database

We have a sybase database running an application our users use which contains client info. The situation is that address information for maybe 1000 clients or so is out of date. We were given a .csv ...
1
vote
3answers
55 views

Creating temp tables SQL Server 13.0.5426 with dynamic SQL doesn't work

I'm trying to create a temp table using dynamic sql (MS SQL Server 13.0.5426). This is a simplified example: Using straight SQL works: DROP TABLE #tmp_ts; -- will error, but ignored on the first ...
1
vote
0answers
22 views

Does this have a name?

Does this have a name? I dont really know how to describe the situation, and furthermore, is this a desing-flaw? T4 has a FK to T3, and to T1, but I can get to T1 by T3. The T1, T2 refers to MUST ...
0
votes
0answers
4 views

MariaDB Master / Slave failover / failback automation

Good day all, I'm hoping someone might be able to point me in the right direction. I'm working on a new dual data center project, and I'm trying to come up with a plan for failover (for patching and ...
0
votes
0answers
17 views

Oracle 12c query performance varies based on schema/user

I have a strange (to me) performance issue. Based on the schema that runs the query I received very different performance. Here's my setup. Oracle 12c DB SAMPLE schema/user WIDGET table (...
1
vote
1answer
18 views

Unable to update a record with a trigger using a dynamic column on a PostgreSQL DB

I'm trying to get a column named XXX_LASTCHANGE updated whenever a record is updated. As the XXX would suggest, this is a dynamic value I want to pass with the trigger definition rather than creating ...
0
votes
1answer
40 views

Split time in intervals of 15

This is my table with data: I want to select it as: Where 0=office, 1=home,2 = telemedice The time will always be a multiple of 5. How can i do that? I have tried this: WITH CTE AS (SELECT ...
0
votes
1answer
54 views

Same Query plan, no new query competition, same hardware, but stored procedure runs slowly

We have an SSRS report that is based on about 8 stored procedures which was running fine up until a few days ago. The report used to run in about 2 hours. Last Sunday (September 15 2019) it suddenly ...
0
votes
0answers
11 views

Find and work with all values found in a BLOB?

So i was asked to do the following. In our Oracle 12.1 instance we have a table used to store files. The request is to run a procedure to find patterns in these blobs and when found, store these ...
0
votes
1answer
11 views

What is the default column name given to a TABLE() type with a single column

CREATE OR REPLACE TYPE MISSING_KEYS AS TABLE OF VARCHAR2(256); SELECT [¿what goes here?] as missing_key FROM TABLE (MISSING_KEYS('A','B','C','D')) What is the default column name that should be in [¿...
0
votes
0answers
9 views

Very High “Failed Attempts” On DB, Records Not Being Saved!

I have a PHP file that is supposed to add entries into my localhost MySQL database. The issue is that although many of these entries are correctly entered, there are some that simply do not get ...
0
votes
1answer
31 views

Correct way to restore dbs to new server

We are migrating from sql server 2008 to 2017 and will do the following install sql server 2017 on the new machine make backups of all dbs on old server RESTORE DATABASE DbName FROM DISK = 'C:\temp\...
0
votes
0answers
31 views

Sudden performance degradation on SQL Server [on hold]

I have an Azure SQL Database that's been up for about a year with a PowerBI dashboard/report sitting on top of it. Last week all of a sudden, I started getting query timeout notifications from PowerBI ...
0
votes
2answers
49 views

Conversion failed when converting the nvarchar value 'value' to int

I have the following code to pull a number of values from several rows into a single column and pipe-delimit the values. SELECT DISTINCT P2.PatientID, SUBSTRING( ( SELECT '| '+ CAST(P1....
0
votes
0answers
14 views

What software/installations are required on a server hosting a Oracle schema only; not a database instance? [on hold]

Planning to setup a server that hosts a Oracle schema only; not the database itself. What software installations would this require? Does it require a full/standard Oracle instance installation?
0
votes
1answer
27 views

Design a table of items with many features; how to group those features

I have this table Storeswhich represents stores. Those stores are managed for many types of persons, like Administrators, Managers, Supervisors and so on, i.e. Each store has an administrator, a ...
1
vote
2answers
40 views

Is it possible to refer to alias before it is assigned?

Does the query shown below work? (Sorry for this type of question, but I am a novice and it is not possible for me to run it right now). SELECT table.id SUM(10/ta.value) AS amount JOIN tableA ...
1
vote
1answer
16 views

Ignore a database in an Availability group when using @AvailabilityGroups = instead of @Databases with ola-hallengren backup solution

I’m using the @AvailabilityGroups= parameter to backup availability groups, is it possible to NOT backup (exclude) a database in the Availability group? If using the @Databases parameter I could use -...
0
votes
1answer
29 views

SQL Server Maintenance plan that goes to next step when the condition passes

I am trying to create a maintenance plan in SQL Server. What I want to do is I have an Execute T-SQL Task and inside the task I have condition below: Use master go DECLARE @dbname varchar(1000) set @...
9
votes
1answer
86 views

Sparse columns, cpu time & filtered indexes

Sparsing When doing some tests on sparse columns, as you do, there was a performance setback that I would like to know the direct cause of. DDL I created two identical tables, one with 4 sparse ...

15 30 50 per page