All Questions

0
votes
0answers
7 views

Blocked Process Report

I have tons of BPR in .xel file (XE) and I want to be able to view them in a graph form and dump them all in SQL Server table, is there any way to do so? Instead of the 5 sec threshold is there any ...
0
votes
0answers
11 views

Lock pages in memory for system accounts

Yes, well where to start? If you really enjoy installing and fine-tuning Microsoft SQL Server or Oracle RDBMS instances on Microsoft Windows Server, then at some point you will all come across the ...
0
votes
0answers
13 views

MySQL Internals: SQL Execution Flow

This is a descriptive question regarding MySQL SQL flow architecture. I need a flow chart on the complete steps regarding MySQL SQL flow using the following components. eg the sequence an UPDATE query ...
0
votes
0answers
10 views

How to set up alert emails SAP HANA?

I want to configure emails for alerts(when backups fail) in SAP HANA Database. From Cockpit -> Configure Alerts, I've set up SMTP information and also created default recipients. Now alerts run but ...
0
votes
0answers
17 views

SQL-Server schema audit trigger - possible to get old view/sp/function definition?

I'm using the below database-level trigger for schema-change-auditing. It works fine, but if I do (drop view - create view), it only stores the sql that created the view, not the one that is dropped. ...
-1
votes
0answers
35 views

SQL Server select query performance improvement [on hold]

We have a requirement of creating a query by joining more than 50+ tables and display the results. However it is taking more than 30 seconds to get the results. All data to be mandatorily retrieved. ...
0
votes
0answers
13 views

Blog database, and multiple categories

I have 3 tables. A table called blog_posts which has your traditional blog fields like content, image, .etc. and a table called blog_categories which stores a number of categories a blog can be ...
0
votes
0answers
9 views

Copy OID field into remote postgresql DB

We have configure postgres_fdw to move data from a db to remote db. It works fine but the OID field's data in source db not getting copied to remote DB. INSERT INTO archive_remote.target_db(id, ...
2
votes
2answers
21 views

Breaking out of a recursive query in Postgres 11

I'm having some trouble getting the correct data out of a tree structure, where I only want the first nodes in a branch matching criteria to be the result of the query. I have this table of domains: ...
-1
votes
0answers
22 views

How to use “group by” while joining two tables with one to many relationship for the many (70+) columns?

I have 2 tables: A: |c1 |c2 |start |end | ----------------------------- |a |11 | | | |b |11 | | | |c |11 | | | B: |d1 |pos |d3 |.....
0
votes
0answers
7 views

How to create a data history in a dimension without using slowly changing dimension?

I'm working on my fact table and I want to create history table for each dimension without using slowly changing dimension because my data flows are bulky and it will take too much time to finish the ...
-1
votes
0answers
10 views

Installing Postgresql ODBC driver in AIX box [duplicate]

I am installing postgresql ODBC driver in AIX 7.1 box. PsqlODBC driver - psqlodbc-10.03.0000 After installing the psqlODBC driver, we will be connecting to our database postgresql 10.6 which is ...
0
votes
0answers
9 views

mysql 8 innodb clustering - adding instance fails with error “Unknown database 'mysql_innodb_cluster_metadata'”

I'm setting up my first mysql innodb cluster, following the instructions here: https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-production-deployment.html I've configured the instances ...
0
votes
1answer
19 views

How to fetch the string from the column of table in postgresql?

I have the following table Userid District_code 1 05 1 03 2 03 2 04 3 06 and want to get this output: userid=1 dist_code(05,03)
0
votes
1answer
12 views

How to store token in postgresql?

I have a column in table with type character varying here is the query: update logins set access_token='l38r8cfjm31b38ye91yjn1956vr3n74tc5sc0btholj0iain77' and uuid='123456789' where username = '...
0
votes
0answers
16 views

Cannot connect securely to enterprise manager

I'm working on my classwork and had a problem with connecting to the enterprise manager. After running the DBCA the address given to me was https://10.0.2.15:5500/em, pulling it up on IE I get cannot ...
0
votes
0answers
9 views

How to sync easily between a master database from Google Cloud SQL and a master database from Amazon RDS

I've created a master - slave (replication) in Google Cloud SQL. I've also created a master - slave (replication) in Amazon RDS. I want to sync two master MysQL from Google Cloud SQL and Amazon RDS....
0
votes
1answer
43 views

SQL: Comparing multiple dates

I got a table with multiple columns that contain DateTime namely gendate1 up to gendate8. In my stored procedure, the user will have to input a date (@date_start). Now I have to compare the inputted ...
2
votes
1answer
23 views

Why is an empty rowset not equivalent to null when assigning a query result to a variable and how best to work around?

I have a cursor. Within my loop I select a single column and assign the result to a variable. When the select returns an empty rowset, nothing is assigned to the variable. In particular, the variable ...
0
votes
3answers
32 views

Sum of decimal values that come in a string

Is there an easy way to get the sum of all decimal values in a string column. Example: "ABC $3.25, DEF $2.50, HIJ2 $0.25" "ABC1 $3.25, DEF $2.50, HIJ $0.25, KLM $4.50" I want to add only the values ...
1
vote
0answers
29 views

postgres boolean function and check constraint

I been using postgres for a while. Mostly simple stuff. Now trying to implement a small perl function to check for a single valid email address. My employees table should have either a single valid ...
0
votes
0answers
19 views

Mysql 8.0 table_rows problem

I'm doing an application and I have the following problem: I'm doing a LOAD DATA INFILE into a table from a txt file, that has 2 million rows. I want to see the table_rows of my table with: SELECT ...
0
votes
0answers
12 views

Can the same sql server geography field hold different spatial types and different coordinate systems?

I am trying to understand geography data types so I can integrate my database more closely with GIS processes. From my reading it appears that a geography data field can hold many different types of ...
0
votes
0answers
16 views

MS SQL 2017: Execution cannot continue as the language dependant resource file could not be loaded

I've just installed a fresh copy of Windows Server 2012 R2 (Polish regional settings and language) with an instance of MS SQL 2017 Server Express. When I log to the server via Management Studia (ver. ...
0
votes
0answers
13 views

SQL Server LDF is is keep growing on secondary Always on

I have configured ALways-On (Async mode) on SQL server 2017, recently LDF file has been growing on secondary (80 GB), but on the primary database it is less than 50 MB, also I have set up full back ...
0
votes
0answers
10 views

split big database to multiple db

We have giant 2.5T PostgreSQL DB (RDS) with multiple tables running in AWS. We want to drop tables which we are not using and archive old data. But keeping the DB writable state and doing these ...
7
votes
3answers
215 views

Access to the path 'c:\some\path' is denied for MSSQL CLR

I think this is a permissions problem, but I'm having trouble locating it. I have a group of CLRs on one server (SQL Server 2016) and they work as they should. All are marked UNSAFE and they do ...
0
votes
0answers
23 views

Dynamic SQL - Resource [on hold]

Can someone please recommend resources/books to learn and become efficient in Dynamic SQL for MSSQL. I have researched online but most of the content/book I am coming across has basic Dynamic SQL ...
0
votes
0answers
15 views

Help structuring a query with multiple many-to-many relationships

Assume that there are 4 tables, with association tables "between" each of them: Machines Products Option Groups Options Machines may serve many products, and a product may "belong to" many machines. ...
0
votes
1answer
33 views

How can I use Count() or Sum() with advanced criteria such as matching the most recent rows where a condition is true?

I have created a table with the following structure: | ID | RecordDate | SerialNumber | ProductID | StageID | Result | |----+------------------+--------------+-----------+---------+--------| | ...
0
votes
0answers
14 views

Stored Procedure call from Web App creates Very Large File on C drive [on hold]

We have a SP that is a Select that is creating a very large file (7GB+) on our C drive. Our Databases are stored on a separate drive. I've searched to determine the location of these files without ...
0
votes
0answers
5 views

How will client psql command need to change to connect via pgpool ? Do we always need to specify the pgpool port explicitly in the psql command?

Hi we are playing with pgpool connection pooling. We are running it in the same server where postgres is running. For local client connections , we are specifying the pgpool port in psql command to ...
0
votes
0answers
22 views

How to change MySQL 8.0 datadir to a network drive

I changed the datadir=' ' in the my.ini file but this seems to not work, the server never going up, always appers a error with the code "Can't connect to MySQL server on '127.0.0.1' (10061) (2003)" I ...
0
votes
0answers
8 views

Directory Verification with For Each Loop in SSIS

How can we check if a directory is valid or not inside for each loop . I am having multiple files at some location and i want to load that file but before this i want to check if the directory is ...
2
votes
1answer
30 views

Object id error in sql server

I want to know the object referenced as an associatedObjectId in a deadlock graph, so I ran the below query: SELECT OBJECT_NAME(1234560112364076) I get the following error: Arithmetic overflow ...
-1
votes
0answers
29 views

Regarding Installing postgresql ODBC driver in AIX 7.1 server

I want to install Postgresql ODBC driver in AIX 7.1 64 bit. I went to "https://www.postgresql.org/ftp/odbc/versions/" for rpm but I see directories like 1) src 2) old 3) msi 4) mm 5) dll I am ...
1
vote
2answers
25 views

How to determine if it is necessary to increase the sga and the pga in Oracle database

How to determine if it is necessary to increase the sga and the pga in a database oracle 12c, is there any procedure, any specific view where can I be guided that indicates to me that it is necessary ...
1
vote
1answer
12 views

Get the combined row count by month from 3 tables

Using Postgres 10+, I have three tables with similar structures, where I'm trying to get a count of rows grouped by months. I have a functional query working for two tables, as below: CREATE TABLE ...
0
votes
1answer
14 views

Return results of two MySQL query in only one

I am running two seperate queries to get statistics from 3 different tables: contacts campaigns sent_messages The first query counts all contacts that are marked as "stop" in the contacts table (...
0
votes
0answers
8 views

is it possible to make multiple mongo routers connected to just one shard on a mongoDB shard cluster?

I'd like to make a mongo cluster with multiple mongo routers(mongos) with just one shard(mongod) like thses figures. So I made two mongo routers named 'mongorouter-1', 'mongorouter-2', and also ...
0
votes
0answers
11 views

Log Shipping and Transactional Replication

Is it possible to have a Log Shipping Secondary database be a publication database for transactional replication? In my research I discovered the the database for log shipping has to stay in no ...
1
vote
1answer
31 views

PostgreSQL 11 error: column p.proisagg does not exist

Using phpPgAdmin v5.6 and PostgreSQL v11.2 on CentOS v7, when I try to access the Functions tab within the public schema, I get the following error: ERROR: column p.proisagg does not exist LINE 18: ...
1
vote
0answers
23 views

Why does an UPDATE to a full-text-indexed column lock the full text index?

I'm troubleshooting a deadlock on a SQL Server full-text index. From what I can see in SentryOne's monitoring, two queries deadlocked when trying to acquire locks on the full-text index; one query was ...
1
vote
0answers
20 views

Cronjob to check when Oracle Materialized View was last updated?

I have two database users in my Oracle DB and want to create MV's in User B which get their data from User A through a database link. I plan to autorefresh the MV's every night but want to make sure ...
1
vote
1answer
22 views

How to GRANT SELECT by default to B, on tables created by A?

Background In my PostgreSQL instance (say with one unique database constituted of one table only), I have 2 users: user_A, who can create and populate my_table, user_B, who should only be able to ...
4
votes
1answer
69 views

How to control execution plans in SQL Server

I've faced a problem with SQL Server generating poor execution plans. I have 3 databases with the same structure and the same set of procedures. My query looks like this: select d.Id as DirectoryId,...
0
votes
0answers
22 views

psql: FATAL: the database system is starting up

I'm running into this message but not able to make heads or tails out of why it's throwing this: -bash-4.2$ /usr/pgsql-10/bin/postgres -D /data/patroni --config-file=/data/patroni/postgresql.conf ...
-2
votes
0answers
30 views

Full-text search (FTS) in databases, which database is the best for it? [on hold]

I have problem, I consider database(MS SQL SERVER, ORACLE, POSTGRESQL) for full text search. I saw that MS has it, POSTGRESQL too, but ORACLE not. Can you advice me which database will be the best?(...
0
votes
1answer
11 views

Temboard: when monitoring a server modifying postgresql.conf on the server is not effective?

I've installed the Temboard tool (http://temboard.io/) to start monitoring my postgresql server. I've noticed that when I modify the postgresql.conf on the server and I restart it, the change is not ...
0
votes
0answers
20 views

php mysql query returns empty result, but works fine on phpmyadmin

I have set up a query as such: $query = 'SELECT SGC.sys_id, TBL.semester, SGC.bonus, SGC.exam, SGC.ca FROM SubjectGradeComponent AS SGC, '; $query .= '(SELECT `sys_id`, `semester` FROM ...

15 30 50 per page