All Questions

Filter by
Sorted by
Tagged with
1
vote
1answer
26 views

SQL Server sys.dm_tran_active_transactions long running transaction worktable

today I used the system object sys.dm_tran_active_transactions (to be honest for the first time). I had an issue with distributed transactions (Microsoft DTC) and went digging there after I had no ...
2
votes
1answer
26 views

Job completes successfully and logs the errors to a text file

I am using Ola's scripts for our database backups, I am trying to come up with a way to be notified if any of the database backup fails. Job completes successfully and logs the errors to text file, ...
0
votes
0answers
25 views

Oracle Model Clause and For Iteration Constraints

I have a multidimensional model which I am trying to apply a FOR iteration against. However, I need to add a constraint to one of the dimensions in the FOR iteration (e.g. stop the MODEL from ...
1
vote
1answer
13 views

Redshift throws Value too long for character type character varying(100) even when values are within the range

I am aware what this error message Value too long for character type character varying(100) means. So I often look for the rows which cause the trouble and fix them appropriately as deemed fit by the ...
0
votes
1answer
17 views

Query to get the number of errors reported by PostgreSQL

Is there any internal table recording the number of errors produced by Postgres? I was expecting something like: select database, count(*) from pg_errors where type='error' and date ...
0
votes
2answers
19 views

How to get count of each column data

I am trying the fetch the data of the each user of each month. The table looks like below ---------------------------------------------------------------------------------- | user | pm_jan ...
1
vote
3answers
104 views

Obtain a “list” of stored procedures which include INSERTs without naming the columns involved

As part of some enhancement, a new column has been added to over 750 tables. Now my problem is within almost 3000+ of stored procedures, some old INSERTs do not name columns. Is there any way I can ...
0
votes
1answer
28 views

Split oracle dump file into multiple parts [on hold]

I've an oracle dump of about 85G, I'd like to split this into multiple parts and download it via ftp. Is there any solution for this. I know I can export the dump into parts using expdp, but that's ...
0
votes
1answer
18 views

mongodb - Replica set creation error: Quorum check failed because not enough voting nodes responded

I am configuring a mongodb replica set. From my current primary node, when rs.add('host1:27017'), it yields this error Quorum check failed because not enough voting nodes responded; required 2 but ...
0
votes
2answers
26 views

Create a row based on a condition (column value)

I have a table that contains the following data; EmpNo | GivenName | PreferredName --------------------------------- 1 | Paris | Paris 2 | Ashley | Ash I am trying to get an output ...
0
votes
0answers
11 views

IO scheduler for Oracle RAC on Linux

All the documentation I have seen says that Oracle recommends the deadline scheduler. This seems very counter-intuitive when using a mini-SAN (with persistent write caching) - in such a scenario, and ...
0
votes
0answers
6 views

How to change charset for find different md5 with mysql [on hold]

I merge 2 db with some columns have md5 based on another columns of this db. The problem is for the same input I have 2 differents md5 (like in picture)... I am trying to import the inputs in new db ...
0
votes
0answers
18 views

Adding rows that share a foreign key ID from the same table *in a new row*

My goal is as follows (simplified): find the newest record from table events use a FK events_meta_id to find all records from that same table (events) that have the same value in that field, if they ...
0
votes
1answer
22 views

Line breaks handled inconsistently by SSMS

Probably more of a SQL Management Studio question than SQL, per se, but when I run the following simple query: SELECT results = 'Foo' + CHAR(13) + CHAR(10) + 'Bar' I appear to get different results ...
0
votes
2answers
25 views

How to move old data to cheap hard drive

I have a quite big PostgreSQL database (with timescale plugin). Right now it is consuming about 500Gb on a SSD. Most of the data is in the form of time series. In most cases data older than a few ...
1
vote
0answers
23 views

Different results returned when ignoring Primary Key index. Daylight Savings Time related bug?

I'm hoping you can help explain this behavior or try to reproduce the issue so I can be confident filing a bug report. Essentially, I get different results from these queries: # returns 0 select ...
0
votes
1answer
15 views

Options and best practices for Multiple Result Sets in Postgres11

I want to get two (small) result sets and have the benefit of precompilation and 1 round trip to the database. SQL Server allows a stored procedure to contain multiple select statements. SELECT u....
1
vote
0answers
11 views

Connecting a SOAP web service (XML) with a Solr Database

I've stood up a Solr Database in Cloud mode in our Cloudera stack using Cloudera manager and ZooKeeper. I know how to ingest data via pysolr and also through the local browser GUI, but that's usually ...
1
vote
1answer
40 views

SSDT Publish failing with an error without even running any statements

My publish attempts are failing with this error Msg 205, Level 16, State 1, Line 7572 All queries combined using a UNION, INTERSECT or EXCEPT operator must have an equal number of expressions in ...
-2
votes
2answers
59 views

Which database should I be using if I need to store 100Gbs of data daily? [on hold]

I need suggestions from experts about which database I should use and which hosting to use for that data which will be best for me in terms of price and reliability. I am downloading Youtube video ...
0
votes
3answers
37 views

Add windows user to a particular database in SQL Server

I have a windows user who I want to add to just one database SalesDeals on the server. I added them in SalesDeals-> Security -> Users section of the Database and gave them db_datareader ...
0
votes
1answer
31 views

How can I find the longest record (in characters) for each column in a table in PostgreSQL

I couldn't find the answer to this on here so sorry if repeated. I'm looking to query a table to find the longest record in characters for each column in a specific table. I have a table which is ...
0
votes
1answer
37 views

Login permission on Availability group database

We have an availability group database. Just wanted to check on the below statement whether it needs to be run on all replica (By failing over and making it primary)or it can be run on the primary ...
0
votes
1answer
40 views
+50

Monthly Date and Hour wise report generation using PHP MYSQL

Attendance Portal in PHP I am facing problem at Final Attendance Report Generation I'm stuck at the final stage of the Project: I have a Table- attendance, If a student is Present I mark it as 1 if ...
0
votes
3answers
55 views

How to use REPLACE in a dynamic way

How can I make the REPLACE function dynamic, by dynamic I mean that if for example one entry has 3 quotes and an other on has 5, I want it to cater for all situations BEGIN TRAN update ...
-1
votes
2answers
30 views

SQL Procedure error [on hold]

I am having an issue with an sql query used in job automation The procedure inserts data from a source table(48 columns) to destination table(49 columns where the 49th/last column is NOT in ...
0
votes
2answers
22 views

In PostgreSQL URL I can't use a password containing special characters

I have a postgresql database in Azure The passwd string has special characters like these: )mvd99/iyH_=ag=Por/W}%%aKY^ygt+,sC7%%P?APOU psql --dbname=postgresql://db_user@mydemoserver:)mvd99/iyH_=ag=...
0
votes
0answers
11 views

PostgreSQL multi-pivot with keys as column names rather than categories?

I am trying to use crosstab() to generate a tricky pivot which is not really a true pivot. I am looking to get the key names as column names rather than the category. E.g. create table pivot (id ...
1
vote
0answers
15 views

Error while trying to process dimension in SSAS

I am getting the below error when I try to process my dimension in Analysis services from SQL Server Management Studio. Errors in the OLAP storage engine: The attribute key cannot be found when ...
0
votes
0answers
16 views

Date between intervals dynamic

I have a table with all employee licenses and two dates in relation to a period of 2 years. I have to verify if have someone period sum of 30 days of license in one range 12 months For example: data ...
1
vote
1answer
20 views

Replacing IN condition in Oracle

Oracle here. I have the following tables: [orders] === order_id : integer constraint pk_orders primary key using index order_name : varchar2(40 char) order_ordered_by : integer constraint fk_shoppers ...
0
votes
0answers
28 views

Service Broker Error - The conversation handle is not found

All, A new third party application using Service Broker on SQL Server 2017 is causing the error log to report numerous failed query delivery notifications due to conversation handle not found. I've ...
0
votes
0answers
16 views

Are Data Quality Services (DQS) included in SQL Standard 2016 Edition license? [closed]

Are Data Quality Services (DQS) included in SQL Standard 2016 Edition license? While reading Microsoft SQL Service 2016 Licensing Guide I could say NO. BUT While looking on Standard Edition Setup ...
4
votes
1answer
56 views

DMVs - Relating tasks to branches

In this excellent article, Paul White demonstrates branches in parallel plans. https://sqlperformance.com/2013/10/sql-plan/parallel-plans-branches-threads At the most fine grained level, we can look ...
1
vote
1answer
17 views

How to skip prefix column check in multi column index in MySQL?

Below is my demo table structure: CREATE TABLE `table1` ( `postType` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0-for rent, 1-to rent', `postLocation` smallint(6) NOT NULL, `postArea` smallint(6) ...
0
votes
0answers
15 views

MySQL Workbench 8.0 data filling using foreign key

As you see in the picture below, I have some kind of information like this. The main information in Regions_other will be the following (in short): NA AMS LATAM AMS APAC APJ As I will be ...
0
votes
3answers
76 views

What is the standard way to make a invoice system database tables?

I'm confused how to create tables for invoicing system, because when one invoice have more products, I can't repeat same invoice id for the each product in the invoice table as PK cannot repeat. so ...
1
vote
0answers
9 views

Using AWS RDS Postgres: Create a superuser with access to all tables (also future created ones)

In AWS RDS (A managed Database service), we cannot create real superusers. There is a user RDS calls Master User, which can create new users, databases, tables, etc. However, when another user has ...
0
votes
0answers
19 views

SSRS using performance counters [closed]

I need to create a report using Statistical Process Control to show the 'health' of a server. I have counters from a previous DBA being collected every hour, and have a BlitzFirst counting system ...
1
vote
0answers
18 views

Does restarting Mongodb config servers restart the mongos?

Our environment is a 2 node Shard of 5 node replica set with a 3 node replica set config servers and 6 mongos. We happened to change the hostname(short to FQDN) of 1 of the config server and we ...
1
vote
2answers
30 views

Does oracle client 12c requires Java on windows

if I install Oracle 12c client on window server, does it get Java installed? can we install oracle driver/client without Java?
0
votes
1answer
44 views

How to Query Which Table Is Inserted Mostly In SQL Server?

I have a database and there is not any trigger which follows the transactions in said database. Now, I have to make a report that shows which table has mostly inserted so far. How can I do that?
0
votes
0answers
14 views

Mysql auto sharding

I am trying to understand the automatic way of Sharding. I understand there is a way to do sharding through application logic (for example, id > 100 go to DB B, < 100 go to DB A) However, is there ...
0
votes
0answers
10 views

How to group by a field in a certain time range in Cassandra

I have a big Cassandra table with around 15 fields, and I wanted to create many materialized views to support all of my queries. The Primary Key on the base table is (CompanyName, ctime) where ctime ...
4
votes
4answers
569 views

Software need db owner permission to master database (sql2016)

We have a manufacturer whose software requires authorization for the master database (only db owner working). Unfortunately, the manufacturer can not tell us why this access to the master database is ...
0
votes
0answers
13 views

questionnaire selection model

I'm currently working on modeling a database to "recommend" products based on a questionnaire (it's not a recommendation system) so I have my products with some characteristics like the ones bellow (...
0
votes
1answer
20 views

Is individual column and row-level encryption possible in SQL Server?

I know about complete column level encryption techniques and complete database encryption. But is it possible to encrypt individual rows and columns in SQL Server? Thanks
-1
votes
0answers
26 views

how to install debugger

how to install debugger postgresql 9.5 on windows 7? To the page https://www.postgresql.org/message-id/1328980004.2250.14.camel@localhost.localdomain it's written to remove .dll when loading   ...
0
votes
1answer
11 views

Insufficient privileges as a definer of package

I cannot run a procedure within a package with a user that also defined it unless I specify "authid current_user" for some reason. Here is my original code that produces insufficient privileges error ...
0
votes
1answer
20 views

Database backup and restore incase Always Encrypted feature is enabled

I would like to know that How SQL database backup and its restoration on other server will work if Always Encrypted feature is implemented on most of its tables? Thanks

15 30 50 per page