All Questions

0
votes
0answers
7 views

Limiting the number of CPUs used in SQL Server 2012 Enterprise

The platform under consideration is SQL Server 2012 Ent. SP3. We are in the process of migrating a SQL Server environment to VM but highly feel the server was over spec'd to start. We want the ...
0
votes
0answers
8 views

SQL Server Threshold of Write per X when considering Indexes?

I am not entirely sure if this is even a question worth asking. However, I was curious as if there was some sort of standard, or specifically a metric, that some more seasoned DBA's use to gauge ...
1
vote
0answers
3 views

PostgreSQL error: remote query result rowtype does not match the specified FROM clause rowtype, on remote function call

This is my remote function: CREATE OR REPLACE FUNCTION public._test1() RETURNS record LANGUAGE plpgsql AS $function$ DECLARE rec record; BEGIN select 1,2 into rec; return rec; END $function$; ...
0
votes
1answer
21 views

Case Statement for on same month

i have a CASE statement, which classify my Customer-Revenue and set Flag, when Revenue <> 0 is. But my problem i should search also same month record on my case statement. Logic : if two records (...
0
votes
0answers
17 views

Find “Mystery processes” on a MS SQL Sever environment? (SSIS, databases, etc)

I inherited a collection of Instances/ MS SQL Databases/ SSIS scripts on a server. I am now the interim "accidental DBA." I thought I was familiar with everything there, but apparently not. It's all ...
0
votes
0answers
7 views

SSMS is crashing and SSMS Toolbar

I'm new in SQL Server and i have installed SQL Server on my system for testing purpose. Issue 1: I want to convert the name of all the toolbar in menu tab to icon. I have no clue from where does it ...
0
votes
0answers
6 views

How to optimize SQL query which involves GROUP_CONCAT function with ORDER BY

I wrote the following SQL query to group results and then sort results in each group by date: SELECT origin, provider, SUBSTRING_INDEX(GROUP_CONCAT(price ORDER BY departure_date ...
0
votes
0answers
11 views

InnoDB full of data dead

I have a DB in server that gives this error after filling the database with 12GB of data 2019-03-22 07:50:05 18705 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it....
0
votes
0answers
8 views

How to change the expiration date of binlog files?

I have a server with Ubuntu 18.04 and MySQL 8.0.11 I have binlog files in /var/lib/mysql that make several GO and my server will soon saturate. How to change the expiration date of binlog files ? ...
0
votes
0answers
12 views

SSRS Report - 'Go to URL' not working. Link does nothing

I have a report that I moved from one location to another. The report has several 'Go to URL' links and the location of the files has changed from the original report. The files I am trying to link ...
0
votes
0answers
18 views

Retrieving value from JSON by key returns NULL

Please help with understanding why function returns NULL? CREATE OR REPLACE FUNCTION evaluate_score(input_data anyelement, hkey VARCHAR(32)) RETURNS float AS $final_score$ DECLARE final_score ...
0
votes
0answers
7 views

How to eliminate for loop in a nested aggregate problem

I have a parsing problem that I am solving with a FOR LOOP in plpgsql, basically because I can't figure out how to solve it with subqueries and nested aggregates. My question is can the for loop be ...
0
votes
0answers
9 views

Dividend reinvestment into shares query

I'm gonna get straight to the problem: Image dividend reinvestment as this scenario: You buy 10 shares of AAPL on 2018-01-01 for $10 -- AAPL pays $1 / per share dividend on 2018-02-01 -> you get $10 ...
0
votes
1answer
19 views

My disk is full of binlog files

I just realized that my server is growing by 2 GB per day, which is not normal. I looked at my folder and the folder / var / lib / mysql reached 26 GB Normally it should be about 4 GB A month ago I ...
0
votes
0answers
24 views

How to join these queries?

So I currently have this query: SELECT v.Voorstellingsnummer, COUNT(r.Voorstellingsnummer) FROM reserveringen r, voorstelling v WHERE r.Voorstellingsnummer = v.Voorstellingsnummer GROUP BY r....
0
votes
0answers
17 views

I have one table for users, one for a collection of games. My users can own one or many games. How do i structure that in my database?

Since i can't store lists, do i add a field in my users table called 'owned games' and then just store a long string like "game1, game2..."? Or do i add another table called something like "ownership"...
1
vote
1answer
23 views

How to change SQL Server master key password?

I created a master key, then a certificate and encrypted my database. CREATE MASTER KEY ENCRYPTION BY PASSWORD='A Very Strong Password'; GO CREATE CERTIFICATE foo WITH SUBJECT='Database Encryption ...
0
votes
0answers
7 views

Do postgres autovacuum properties persist for DB replications?

I would like to understand postgres replication options more, and as I am doing my research, I have come across a concept of autovacuuming in efforts to create routine DB maintenance. My question is ...
0
votes
1answer
14 views

Limiting Common Table Recursion

I am trying to migrate from Oracle to MariaDB. At the moment, we are facing an issue with the following Oracle code. SELECT id,MK, pid,AFI FROM M A WHERE LEVEL <= 2 -- limiting iterations ...
0
votes
0answers
7 views

Logical replication - Manually triggering update of data on destination tables (after schema change)

I'm testing out Logical replication on Postgresql (10.4 at the moment) with a quite specific use case. I have some central DB (publisher) from where I need to replicate few tables to distributed DB's ...
1
vote
0answers
9 views

Is there any special meaning for numbers in braces like {0} or {1} in LDIF files of OpenLDAP?

I'm playing a bit with OpenLDAP. In the configuration LDIF files there are often numbers in braces like {0} or {1}, e.g: dn: olcDatabase={0}config,cn=config or olcAttributeTypes: {0}( 1.3.6.1.1.1....
0
votes
0answers
19 views

COUNT not working correctly

This query: SELECT Tijd, Voorstellingsnummer, COUNT( Voorstellingsnummer ) FROM voorstelling v WHERE Vestigingsnaam = 'Amsterdam' AND Filmnaam = 'Avengers' HAVING COUNT( Voorstellingsnummer ) <...
-4
votes
0answers
18 views

Require store procedure which can take inputs from .text file [on hold]

I am looking for a store procedure where I can update records in tables using .txt file which is available in d drive. Thanks in advance
2
votes
1answer
31 views

Logon Trigger Unexpected Result

I have only server logon trigger and it is being used to prevent logins coming from an application/server combination. It works appropriately for that application/server combination and gives the ...
0
votes
0answers
5 views

how to set different file system for dbpath in mongodb

how to set different file system for dbpath in mongodb- I have /data1 , /data2 , /data3 file system available for data path, I would like to use given 3 file sy
0
votes
1answer
9 views

use SQLcl with EZconnect and multiple hostnames (ADDRESS_LIST=)

this is our classic tnsnames.ora test1= (DESCRIPTION= (CONNECT_TIMEOUT=4) (TRANSPORT_CONNECT_TIMEOUT=3) (ENABLE=BROKEN) (ADDRESS_LIST= (ADDRESS=(PROTOCOL=TCP)(HOST=example1....
1
vote
2answers
24 views

Run shell script on Oracle 11g

I have an oracle database: Oracle Database 11g Release 11.2.0.1.0 - 64bit Production PL/SQL Release 11.2.0.1.0 - Production "CORE 11.2.0.1.0 Production" TNS for Linux: Version 11.2.0.1.0 - ...
0
votes
0answers
2 views

AWS DynamoDB : On-Demand vs Provisioned capacity cost comparison

Is there any calculator available which does the cost comparison of On-Demand vs Provisioned capacity? Need to know at what point, it becomes cost effective to switch to provisioned capacity from on-...
1
vote
0answers
14 views

PG4Admin “local variable 'debugger_version' ”?

My Postgres version is 9.6, running on Windows 7 Professional. I have just upgraded to pgAdmin 4.2.3 since I was not able to get the debugger to work at all with my previous pgAdmin. I installed ...
0
votes
0answers
8 views

if Operator in PHP not working as it should be

I am fetching data from excel file in php there is a field data written (Emp. Code ) when i match as it is same in php if condition like this if($Dt2 == "Emp. Code ") its not working but i tried ...
1
vote
1answer
179 views

Suggestion on Missing Index Creation

I have been using sp_blitzindex and it is very very helpful(Thanks to Brent Ozar and Team). I executed this procedure against my database and below is the finding for one table falling in Indexaphobia ...
0
votes
0answers
16 views

Self-referencing table vs Mutiple table approach

I am designing a quiz database and I have to incorporate categories into the questions. I (think) that I have a hierarchical structure that lends itself to a self-referencing table (I have only just ...
0
votes
0answers
7 views

Design question regarding location and DRY principles

I have a client that handed me some tables to create an ms access db from. The design irritates me and I think a different way would be better. Area (table name) City State Addressln1 5 other ...
0
votes
0answers
13 views

Extra tables automatically created [duplicate]

I'm seeing a lot of extra tables in oracle db. I'm wondering what or who created these tables. If anyone has any idea please share with me. Anyway to know from which ip address it got created? Also ...
0
votes
0answers
10 views

referencing id vs code in tables

We are rewriting from a huge monolithic application to smaller application using rest. While the old application had huge tables called REFERENCE tables with applicable values had all these ids and ...
0
votes
0answers
5 views

Got timeout reading communication packets

I am facing this warning continuously in my error log , [Warning] Aborted connection 27 to db: 'unconnected' user: 'xxxxx' host: 'xxxxx' (Got timeout reading communication packets) can i have some ...
0
votes
0answers
37 views

Logon failed for login <<user name>> due to trigger execution

I have the following issue for a SQL Server 2016 instance. Usually everything works fine but form time to time we are getting Error 17892 followed by error 18056. This is a selection form the error ...
0
votes
0answers
18 views

Replication or Sharding (MongoDB)

I understand each of the terms but I do not understand very well if they can work simultaneously. In my case, for example, I have a machine with 20GB and I would like to know which is the best ...
2
votes
1answer
101 views

How to lock a MSSQL (2017 Linux) account after N unsuccessful login attempts

I have to configure account lock after N unsuccessful login attempts on MSSQL 2017 Linux. That is standalone server and is not in AD. I couln'd find any valuable information so far unfortunately. ...
4
votes
1answer
35 views

Restore mongoDB by --repair and WiredTiger

We accidentally deleted the directory rm -rf /data/db which was our MongoDB path, and thanks to extundelete, we recovered it and got the directory /data/db. Here are our files in the directory, and ...
0
votes
0answers
19 views

What could cause the “Failing assertion” MySQL error

After moving to a new hosting company a few months I have experiences these database errors a handful of times on different servers with different software installed. (all Ubuntu 16 or 18). Latest on ...
-1
votes
0answers
9 views

elastic search - architecture relational data in ES

We currently have a MySQL database. We have a new solution now which will have very big amounts of data and we are checking the option to to use ES. Lets take for example this tables that we have: ...
0
votes
0answers
5 views

Cache lookup failed for function 1 while activating PostGIS

I'm using PostgreSQL 10.5 on a remote server (Debian). I created a database inside then I attempted to enable PostGIS but it wasn't successful. I had this error : cache lookup failed for function 1. ...
0
votes
0answers
8 views

Background index creation resource provisioning

I have a long running background index creation running in MongoDB. However, the CPU and RAM usage is below 30%. Is there a way to allocate more resources to the index creation process or is it ...
0
votes
1answer
10 views

sqlite3 command does not save database after creation?

I'm migrating from MySQL. I'm having trouble scripting a SQLite database creation. Similar code worked well for MySQL. It appears the database and tables are created, but then sqlite3 command does ...
0
votes
1answer
17 views

Why does mysql binlog use different isolation level?

Default isolation level: mysql> SELECT @@TX_ISOLATION; +-----------------+ | @@TX_ISOLATION | +-----------------+ | REPEATABLE-READ | +-----------------+ 1 row in set (0.00 sec) Binlog: ...
0
votes
1answer
28 views

Is there a way to speed up this update query using joins or any other method

I have an update query that selects data from a table (HST) and updates it into another table (PCLN). The PCLN table contains ~17000 rows while the HST table contains about 1.1 million rows. I have ...
0
votes
0answers
11 views

MySQL throws error while secure_installation

I am installing MySQL using link: https://www.digitalocean.com/community/tutorials/how-to-install-mysql-on-centos-7 But after installing step 3 for secure_installation sudo mysql_secure_installation. ...
0
votes
0answers
13 views

SQL Server log shipping .trn file date/time is not the same as LSCopy_ job

The LSCopy job runs at 00,15,30,45 of each hour. However, I found the .trn files in the destination folder has a datetime not 00,15,30,45 and there are more than 1 trn within 15-minute period. Why is ...
0
votes
1answer
28 views

Deleting multiple tables in a single delete query in Mysql

I have a task to delete records from multiple tables (say 4 or more). I came to know that I can do the delete in a single MySQL query as follows DELETE table1,table2,table3,table4 FROM table1 ...

15 30 50 per page