All Questions

0
votes
0answers
2 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
2 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
2 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
3 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
5 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
9 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
6 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
8 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
16 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
9 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
12 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
25 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
24 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 ...
3
votes
1answer
48 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
31 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
21 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
46 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
25 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
13 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
23 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
12 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, ...
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
15 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
22 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
15 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
56 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
32 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
32 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
20 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
285 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
17 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
38 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 ...

15 30 50 per page