All Questions

0
votes
0answers
2 views

Clarifying the connection between TimePlan and the daily routine of work

I'm creating a new database and I have an uncertainty between the two tables (Timeplan and DailyRoutine), how to make a dayiluroutine connection for each day. The idea is to write in the Timeplan ...
0
votes
1answer
8 views

How to express an empty relation (or table) in PostgreSQL?

Is there a way to express an empty relation in SQL without actually creating an empty table? For testing purposes, I want to find a way to test something like: SELECT count(*) FROM (...) ...
0
votes
0answers
6 views

Should i place Registered-Users Info in every table? to Restrict user access to his Own Data only

Database: Relational Database - MySQL I am making a database with multiple tables. In order to see his data from tables, User will need to log in. I only need to display those information(through web-...
0
votes
0answers
7 views

Insert 15 million records with data from other table

I have a table with 15 million records and 15 columns. I want to copy some of the data (2 columns) from this table to another table. My current query: INSERT INTO new_table (col1, col2, col3) SELECT ...
0
votes
1answer
14 views

What permissions are required for UPDATE STATISTICS #table WITH ROWCOUNT = xxx?

Can anyone point me to the correct documentation or additional permissions I need besides SA to do the following? When I run it, I receive the following error: Cannot find the object "#test" because ...
0
votes
0answers
10 views

FULLTEXT SEARCH IN MS SQL SERVER

now I am trying FULL TEXT SEARCH mechanism in MS. I load txt files to table ( one file - one record). Column is type nvarchar(MAX). I tested that i can store only about 42,6kB of data in one record, ...
0
votes
0answers
7 views

How can i write an update trigger between two tables

i have two tables one is called defaulters and users .defaulters has mypin and debt_amount and users has mypin and debtor .i want a trigger that update debtor in users table if mypin exist in users ...
0
votes
0answers
4 views

mongodb schema design advice

I have a users index which has fields like id, email, password, etc. A user can see all other users except the ones who had blocked him. I want to design a database schema for this problem. So I'm ...
0
votes
0answers
8 views

Mongodb Replica Set Collection Has Different Document Count

I've created a new 3 node replica set and rsync'ed data from an existing mongo database for initial population. The secondary nodes went into STARTUP2 mode and seemed to successfully sync from the ...
1
vote
1answer
10 views

mysqldump changes primary key to unique key?

While attempting to dump and restore a WordPress database in MySQL, I noticed that mysqldump seems to be changing the PRIMARY KEY on several tables to a UNIQUE KEY instead. For example, this tables: ...
0
votes
0answers
12 views

Is there any special configuration for SQL Server implementing Routing List in a heterogeneous enviroment (Client and Server in different domains)?

I had implemented successfully SQL Server Routing List Feature many times... but I have a very special scenario where our Reporting Services Node is located in a different Domain than SQL Server Nodes....
0
votes
0answers
10 views

SQL Mirroring - Application not pointing to new Primary

Im stuck with a connection string issue this is my connection string. <add name="APP01" connectionString="Server=10.169.0.2; Failover Partner=10.166.0.2; Initial Catalog=DB2017; Integrated ...
0
votes
0answers
11 views

one table or two tables

One database design question, if one table (call it "table_1") has an alternative unique combination key "field1" and "version", is it considered denormalized data, since "field1" is repeating itself ...
0
votes
0answers
21 views

How can a datatimeoffset in UTC be converted to the local time?

In SQL 2012 how can I convert a UTC datetimeoffset to local time zone?
0
votes
1answer
12 views

MYSQL - Error in After Insert trigger affects the actual insert on the trigger table

I have two tables call it - table_1 and table_2 I have an After insert trigger on table_1 and in the trigger I insert on table_2 which has some fk constraints on another table_3. When the insert on ...
0
votes
0answers
15 views

SQL agent job for long running queries

I am trying to setup an alert where the application team can get the notification on their event viewer for any queries which are running longer than 2 minutes. This is what I have so far. For some ...
3
votes
2answers
29 views

Grouping rows in ranges

Let's say I have the following (contrived) table of monitoring data: RowID DateStamp Success Error 1001 5/24/2019 11:23am 1 None 1004 5/24/...
2
votes
1answer
28 views

Proper normalization for an Orders table--whether to split or no

Each order has a unique SalesOrderNumber. An order is made up of various PartID numbers, each with an associated OrderQuantity number. I have the following table currently in my model: I'm ...
3
votes
1answer
12 views

How can I check if my user has create index permission?

I'm working on a .NET library that is used with a third-party product I support. My library may be used with many different versions of the product. I don't control the schema of that product, but I ...
0
votes
1answer
12 views

How can I import an old pgdump into an updated schema?

I'm DB newb doing a software upgrade, and my predecessor's original migration plan may not have been as well thought out as I thought... The Plan was to use our backup, created via pg_dump -U derp -...
0
votes
0answers
6 views

How to restore Postgres cluster from pg_probackup archive

I'm trying to configure continuous backup solution using pg_probackup tool. So far I did the following: Configured archive_command according to the docs Created backup using pg_probackup backup ...
2
votes
1answer
57 views

Troubleshooting a slow performing encrypted stored procedure

I have a stored procedure which is part of a vendor supplied system. The stored procedure is encrypted so we can't see the code. The stored procedure has all of a sudden started to run slow. The ...
1
vote
1answer
33 views

What are some consequences of putting quotes in where clause for an integer field?

I am using PostgreSQL 10.6 I have a table with field name some_field which is of data type integer. I've noticed that postgresql is smart enough to interpret both of the queries below as same ...
0
votes
1answer
25 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 ...
1
vote
2answers
49 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
1answer
28 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
16 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
1answer
31 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. ...
-2
votes
0answers
40 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
18 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
1answer
13 views

Copy OID field into remote postgresql DB [on hold]

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, ...
3
votes
2answers
27 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
26 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
11 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
21 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
18 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
24 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
1answer
16 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
2answers
57 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
34 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
36 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
20 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
13 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
17 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
21 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 ...
7
votes
3answers
292 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 ...

15 30 50 per page