All Questions

0
votes
0answers
4 views

Import multi EXCEL files with relationship between them( Vlookup ) into MS SQL Server [on hold]

I have multiple Excel files that have relation between them. I want to use their data and develop a Web Application. First of all I need to import them into SQL server.( I think SQL Server is more ...
0
votes
0answers
4 views

Mongo restore slowness

while mongo restores of 300GB of database dump it was extremely slow... In mongo log only 1000 documents inserting per second .. anyone knows how to increase the inserting count per second and speed ...
0
votes
2answers
7 views

Does MSSQL Log shipping truncate the transaction log?

I have setup log shipping on a database in Microsoft SQL Server 2012. I was having issues with my secondary server and I found that this was probably due to a scheduled backup job messing up the log ...
0
votes
0answers
9 views

How to fetch all entities whose childs all match certain condition?

I have a task table, an order_table, a big_customer table and a preferred_sender table. Here is the relationship between those tables: ` task 1:N order_table ## a task has N orders ...
0
votes
2answers
10 views

How to connect Microsoft SQL Database with Active Directory Password Authentication (AD Login)

I have web application and I wanted to use Active Directory Password Authentication for Database login. I already setup user login for Active Directory, but it show the error like below. Help me! ...
0
votes
0answers
13 views

Join (UNION) x 3 SQL Tables - and issue ONE query? Is that possible?

What I mean is this: I am building THREE tables. Each of these tables will be joined. Is it "possible", or "common" to then issue a SQL Query that would address all THREE tables? I'm new as I am ...
0
votes
0answers
10 views

Table structure for possible duplicated data (link previews table)

I'm structing a table for link previews and it's pretty easy. TABLE: LinkPreviews +---------------------+--------+-----------------+--------------+ | URL | Title | Description | ...
0
votes
0answers
11 views

SQL Server Allways On Availability Groups - HA & DR

I am trying to build an architecture where we get automatic fail-over for both HA and DR for our DBs using 2016 AlwaysOn Availibilty Groups. When I tested this using only one Availability Group the ...
-1
votes
0answers
12 views

Linux - case command - ¿How to have spaces or tabs in the menu list? [migrated]

I don't know why, but a can't find the answer anywhere. I suppose that it's a very simple change. PS3='Please enter your choice: options=("Option 1" "Option 2" "Quit") select opt in "${...
0
votes
0answers
17 views

PATH settings for Oracle database

I have a laptop with Centos 7. I installed Oracle 12C database on it.The oracle user is oracle and the sid is orcl. How can a user that is not oracle user run the sqlplus program directly ? The ....
0
votes
1answer
24 views

how to calculate balance from two tables

I have two tables like that below: tbl_deposit: id,date,client_id,deposit tbl_expense: id date,client_id,expense I want to see the result when where client_id=1 like this: date---------...
0
votes
0answers
13 views

Time Series Data in MongoDB

I am writing an application that needs to store and analyze users balance in time and also keep the user events in mobile application this has to be done everyday. What es the best schema design for ...
0
votes
0answers
10 views

Copying data up in single SQL statement

I need to fix an SQL statement in MySQL that should calculate a field using values from two of the columns and I prefer to do this using set-based programming, ie not procedural. What needs to happen ...
0
votes
0answers
19 views

is this time to remove the databases from the availability group? which ones?

While patching one of my servers that is part of an availability group, as a secondary, I had some problems - the real problem was that the host machine of one of the virtual servers in the ...
0
votes
1answer
25 views

Help me to merge two queries

I have two queries in sql. First query is: select hotel_id , count(*) as NumberOfRooms from room group by hotel_id; The result is: # | hotel_id | NumberOfRooms ----------------------------- ...
1
vote
1answer
13 views

database_xml_deadlock_report or xml_deadlock_report

Is [database_xml_deadlock_report] the same as [xml_deadlock_report] just with extra fields? I'm creating a basic deadlock and blocking capture and see both. Most examples online show [...
0
votes
0answers
6 views

Mongodb default setup on Azure - connect string from local shell

I have a new Azure VM (Ubuntu 18.04.1 LTS) which has docker. dragam@USDockerVM:~$ IRE> docker --version Docker version 18.09.0, build 4d60db4 Issued the command docker pull mongo. this ran ...
1
vote
1answer
15 views

SQL Server - How to copy database daily

I have 2 separate SQL Server instances, for the purpose of the question, we will call them Source and Target. I have an ever changing database on Source called MyDatabase, this database is populated ...
0
votes
2answers
25 views

How to aggregate the number of indexes on a table and columns per index

I have a simple query that returns every table, index and the columns of the index in a database. I'd like to add two aggregate columns that return the number of indexes on a table and then the amount ...
0
votes
0answers
29 views

Whats the therm in Oracle, when I'm speaking about SCHEMAS on SQL Server

Here, We have our applications developed both for oracle and SQL Server. Devs are trying to fix their own way to be organized, using VW on views, PR on procedures and etc. they told me that they're ...
0
votes
0answers
19 views

What does “_localserver_view” mean after an MSDB Database table

What is equal to the database table [msdb]. [dbo]. [sysschedules_localserver_view], which contains the suffix _localserver_view? I am having a permissions problem with a [msdb].[Dbo].[...
0
votes
1answer
13 views

Questions to Continuous Archiving and Point-in-Time Recovery with PostgreSQL

I'm planning my database backup strategy and came across the continuous archiving concept of PostgreSQL which is exactly what I'm looking for. I have two questions on this. I'm planning to mount ...
0
votes
0answers
10 views

Fail fast blocked Cassandra Native Transport Requests (NTR)

We ran into an issue where a Cassandra node goes down in a cluster of 18 and the overall cluster read/write latencies spike up due to which the Native Transport requests threads reach maximum capacity ...
2
votes
1answer
13 views

Can I control which algorithm SQL Server uses to hash symmetric key passphrases

I will start by describing the issue / cause before asking my question: If you are using a symmetric key in SQL to encrypt data. This can be set up as follows: CREATE MASTER KEY ENCRYPTION BY ...
1
vote
1answer
19 views

utl_raw.bit_and attaches extra 0 after and operation in oracle sql

For a given binary number, say length longer than 128, I want to check whether a particular bit is on or off (say 30th bit) I am using utl_raw.bit_and function to do and between 2 binary numbers. I ...
0
votes
0answers
18 views

Postgresql set point null?

Help how to set a null value type point Postgresql ALTER TABLE masters ADD location point NULL SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type point: ""
0
votes
0answers
16 views

the difference between customer address table and address table

I was having a look at this data model to get more acknowledged for designing my own. Could someone kindly tell me what I need the Customer_Address table for? why don't we just settle with the ...
-1
votes
1answer
27 views

SQL Server 2012 Enforce Password Policy

If i would like to change the password of my SQL login, How much time i can't use with the same password?
0
votes
0answers
34 views

CPU and Hard Drive Spike for 20-30 Minutes

I'm collecting data on the performance of our Microsoft SQL 2008 server in preparation for moving it to Azure. It's a very low load server (currently max concurrent transactions max out at 3), ...
1
vote
0answers
32 views

Correct way to group by month and year?

I need to group by month (and year) and I was thinking about: GROUP BY CAST(YEAR(tDate) AS NVARCHAR(4)) + '-' + CAST(MONTH(tDate) AS NVARCHAR(2)) But I found in the web something like: GROUP BY ...
-1
votes
0answers
14 views

Making a button disappear after clicked in php [migrated]

my current code is this button type="submit" class="btn btn-primary btn-lg" name="submitbutton" value="Submit" onclick="this.style.display='none';"> Execute Procedure </button I am trying ...
0
votes
0answers
8 views

pgAdmin4 configuration files location [on hold]

I need to modify the configuration of pgadmin4 by hand but don't know where the config files are located. I cannot find them in my home directory.
0
votes
0answers
8 views

Read Excel Files wich are matching to the given template Through SSIS

Hope you are doing well . I have developed a SSIS Package with which I'm reading different Excel Files with different structures and Inserting it into different tables . I have a Table in SQL-Server ...
0
votes
1answer
47 views

Good practice for hiding primary keys from a client

Let's say I have a table like this: CREATE TABLE users ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY ); Later on in my client, I may fetch a RESTful endpoint like this: GET /v1/users/1 The ...
0
votes
0answers
18 views

Stored Procedure infinite looping after index updates

I have inherited a very old and poorly written stored procedure with nested fetch statements. This code processes a large amount of data by copying from one database into another. This process was ...
0
votes
0answers
38 views

How can I stop a long running query in SQL Azure Database

I triggered a very inefficient query against a Azure SQL Server instance that has been running now for hours. I have tried looking at the active spid and trying to kill the process that started it but ...
0
votes
1answer
19 views

Map auto increment ids on multi-row insert

I have the following table with an AUTO_INCREMENT column. CREATE TABLE animals ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ); Usually I load multiple ...
0
votes
1answer
17 views

MySQL vs. MariaDB Binary Logging Difference

I've been doing some testing with both MySQL and MariaDB and I've noticed a big difference with regards to the growth of binary logs - I can't find out much about this online. I have a test database, ...
-1
votes
0answers
15 views

How do I find out the Oracle Application Express 11g desktop name, password? [on hold]

It happens that when I fill in the Workspace, the user database and I put the password and I try to login it gives an error.
3
votes
1answer
154 views

Unique filtered index and surprising estimation

When I view the estimated execution plan for this query... SELECT * FROM tabela2 x LEFT JOIN dbo.tabela1 t with (nolock) on t.Kod = x.Kod ... the Estimated Number of Rows property for [table1]...
0
votes
0answers
23 views

Get Headers from SQL Table

I am looking for a way to dynamically get the headers from a table without having to write them (select 'header1' as "header1"...., 'header50' as "header50" from MyTable) It doesn't work above a ...
0
votes
2answers
41 views

Select fields from sub query , but I face field could not be bounded

SELECT ROW_NUMBER() OVER(ORDER BY c.FullName ASC) AS No#, a.AcctBranchName, c.FullName, c.BirthDate, c.Age, a.StartDate as 'Account Start Date', c.CustStartDate as '...
0
votes
1answer
38 views

Partition SQL Server Table by Year, 35 days rolling period

We are trying to partition SQL Server tables by year (2015, 2016, 2017, 2018) and we want to create one more partition which hold current 35 days period data always. Partitions: Part_2015, Part_2016, ...
0
votes
1answer
14 views

config file and parameters for ndb_desc

I'm trying to execute ndb_desc from API client. The config and parameters are as below: my.cnf in mysqld: [mysql_cluster] ndb-connectstring=192.168.1.1,192.168.1.2 server-id=5 log-bin=mysql-bin ...
0
votes
1answer
33 views

Handling INSERT race condition for generated unique column value

I am generating a unique slug during creation of a record like so (based in this answer) INSERT INTO ks.shares ( , slugbase , slugindex , slug , userid ) SELECT , Pslugbase , ...
0
votes
1answer
23 views

listagg in order and including a sequence of separator when missing any row of a sequence

Sorry for the long title but it's a little bit difficult to explain. We have a table | N rows | Atrib1 | Atrib2 | Atrib3 | Atrib4 | Final row | --------------------------------------------------...
0
votes
1answer
29 views

How To return null value if no records present in select query

I am querying in DB for last 72 records in Db in my Db it may happens all data will not be present for that I want to add dummy row in which I will add rank and adding null value to remaining data. ...
0
votes
0answers
3 views

migrating data pipeline to AWS Glue

I was trying AWS Glue to migrate our current data pipeline from python scripts to AWS Glue . I was able to setup a crawler to pull the schema for the different Postgres databases . However, I am ...
0
votes
0answers
16 views

SQL Server Log Reader Agent while trying to add node in p2p Replication

I am trying to add one more node in peer-to-peer cluster. In current state, I have 3 servers A, B and C. I need to add a node D with node A(only). For this, I used following steps: Took full backup ...
1
vote
1answer
14 views

Dynamically changing tables in datasource in SSRS

I have an SSRS report that I have set up to query two tables, let's call them ABC_Audit and ABC_AuditDetail. I have now added XYZ_Audit and XYZ_AuditDetail to the same database, and want to be able to ...

15 30 50 per page