All Questions

0
votes
0answers
19 views

Running REINDEX in a live environment (POSTGRESQL 9.6.10)

I have a live app where I have some big tables (~100+M rows), which I recently truncated to ~20M rows. One behavior I've noticed after making the said change is that DB response time has escalated in ...
0
votes
3answers
60 views

Deprecated raiserror detection

I want to upgrade SQL server from 2008 to 2014 versiyon. I checked all of the deprecated features including raiserror syntax. But I have many stored procedures to check. Some of them use new syntax, ...
0
votes
0answers
15 views

Auto rebuild index in SQL Server 2008 R2 [duplicate]

How to define schedule to rebuild all database index in SQL Server 2008 R2.
0
votes
0answers
30 views

Reducing the number of tables used - mySQL

I have a table for tax implementation in my application, but I am not sure the design I have done for the table. Can someone review it? val_taxes is the table which has all types of tax listed in ...
1
vote
1answer
17 views

How to specify the domain of an attribute in an entity-relationship diagram (ERD)?

In an ERD (as in, rectangles for entity types, diamonds for relationship types, ovals for attributes, etc.) how would one specify that an attribute is, say, a 5-letter word?
1
vote
2answers
46 views

Why can not I get any row in a MySQL query from SQL Server?

The problem I have is that I can not visualize any row with the following query: SELECT * FROM OPENQUERY ([LINK_MYSQL], 'SELECT * FROM mysql.vw_bd_date;') The query did not show any error except ...
0
votes
1answer
16 views

jdbc equivalent to libpq “hostaddr” connection string parameter

Is there an equivalent to libpq's hostaddr parameter in the JDBC connection string? I want to connect via a local TCP proxy (on 127.0.0.1), but use ssl=verify-full with the CA bundle of the remote ...
0
votes
1answer
28 views

SQL Formatting: Add Space within query result

I need to insert a space into result set from a query, I tried using the space() function and right but I have confused myself. The Column result from the query is: 1234567891234567891 I need this:...
1
vote
1answer
48 views

Why Logical reads are high

I have a table with 999 rows in 24 blocks.Ran a sql query for the first time which does a full table scan.From the execution statistics it shows 87 LIOS I'm confused why LIOS is high it's like Oracle ...
1
vote
1answer
88 views

MAX worker thread in SQL server 2012/14/16

I was just browsing the system health extended event to come across an event with diagnostic result for query processing showing status for worker threads: Why max worker threads showing 2994 when I ...
6
votes
2answers
80 views

Solution to assigning unique values to rows with finite collaboration distance

I have a table that can be created and populated with the following code: CREATE TABLE dbo.Example(GroupKey int NOT NULL, RecordKey varchar(12) NOT NULL); ALTER TABLE dbo.Example ADD CONSTRAINT ...
0
votes
5answers
32 views

Mysql: Unable to drop a columns NULL default

Running mariadb 10.3 I have a bunch of columns that were created by default as NULL defaults. I was asked by a third party integrator to remove the NULL defaults, but so far have been unsuccessful. ...
0
votes
0answers
22 views

Adding LIMIT slows down query

SQL CREATE TABLE actions ( action_id bigint GENERATED ALWAYS AS IDENTITY, block_time timestamptz NOT NULL DEFAULT now(), block_num int NOT NULL, trx_id text NOT NULL, ...
0
votes
0answers
14 views

Weird results when querying PostgreSQL (lower performance when requesting a small string than requesting a larger string)

I’m developing an experiment where I want to analyze the impact of the database in a web application. The experiment consists of searching for 1 string on the database according to an ID and returning ...
1
vote
1answer
31 views

How to get EstimatedRows values from SQL Server execution plan nodes

When I execute the following code in an Azure SQL Database (v12) or SQL Server 2016 instance, I get values in the EstimatedRowsRead column, but not in the EstimatedRows column, and I'm not seeing why. ...
0
votes
1answer
4 views

Dump roles on AWS without pg_dumpall -g access (postgresql 9.6.8)?

We have a system on AWS RDS Aurora, PostgreSQL v 9.6.8 option. We are trying to move its roles to a new encrypted 10.5 instance, but we don't have superuser access that's required to do pg_dumpall -g ...
0
votes
0answers
35 views

SQL Server 2012 Standard + CAL Licensing [closed]

My company runs SQL Server 2012 Standard Edition with 200 User CALs. The application connects with its own credentials (Active Directory account) to the SQL Server. No user is connecting directly to ...
-3
votes
2answers
61 views

Query not response and become extreme slow [on hold]

I already have database in SQL Server 2014 and after upgrade to 2016 and 2017 this problem happened. After this 1 year the data also increased. About my server: 2x Xeon E52670 32GB RAM 4X SSD 240 ...
1
vote
0answers
17 views

Write-Traffic Analysis

I want to assess how much data "churn" (insert, update, delete) a DB is undergoing, preferably per unit time. For example, I'd like to know how many rows were inserted in the last hour. Even better, ...
0
votes
0answers
11 views

Compute subnetwork in Oracle PL/SQL

I have a table of links with startnode and endnode as strings: create table my_links as ( select 'AZ' as nodeid, 'A' as startnode, 'Z' as endnode from dual union all select 'AB', 'A', 'B' from ...
1
vote
1answer
31 views

Select one record from LAG Query

I'm having difficulty getting data from a query using the LAG method. The issue is that I only need one record from the entire set pulled down, but when I filter out that record in the WHERE clause it ...
0
votes
0answers
3 views

php old hash password check and new password update [closed]

I am creating PHP hash password update script this script every time display your all password incorrect message I want to create old hash password check and new password update I have very tried to ...
0
votes
0answers
10 views

Your preferred HA replicated setup of PostgreSQL on Kubernetes - does this even make sense?

I'm currently looking to run a new production level PostgreSQL instance on a Kubernetes cluster. I'm just a software developer who only uses PostgreSQL on the local machine during application ...
0
votes
0answers
20 views

Sql Server - Execution Plan - Query Cost (relative to batch) calculation [duplicate]

We have a Table Value function which: Creates and Populates a table variable (@Temp) from a SELECT Runs two different UPDATE statement to change values on 2 different columns in @Temp Populates the ...
0
votes
0answers
23 views

Allowing login creations without giving Security Admin Role in SQL Server

Is there any way i can allow some user to create logins without giving Alter any Login Permission or Security Admin Role? I need to grant that access but prevent that person from giving himself ...
0
votes
0answers
13 views

Sort Output of plpgsql Script

I'm using Postgres 9.6 I'm creating a script that compares two schema which have the same tables. I want to find tables which are empty in one schema but populated in the other. I'm avoiding the ...
1
vote
1answer
26 views

SSAS Build in TFS

How do I build an SSAS Cube Project in TFS? For 1) DatabaseProjects: it is MSBuild 2) SSIS: Devenv.exe with SSIS Project directory How would I build in Team Foundation Server 2015 for SSAS cube? ...
0
votes
1answer
58 views

ORA-27102: out of memory

We're facing an Out Memory Problem with an Oracle database SE 12c Release 1 (deployed as a Docker container) ... The only information that I have is this one: Caused by: java.sql....
0
votes
1answer
39 views

Postgres how to drop table owned by another user without mirroring that user's Permissions

User A owns all of our tables and has access to all of our schemas User B needs full access including Drop and Alter permissions to some of those tables and schemas but not all of them. As is well ...
0
votes
1answer
13 views

postgresql materialized views vs versioning

I came across a pickle when dealing with question from one of our dev concerning postgresql and materialized views: can I refresh materialized view with my application user? well according to docs (...
0
votes
1answer
37 views

Replicate Postgres to Cockroach

We are planning to replicate our Postgres database to Cockroach. We are looking for a relatively simpler solution to achieve that. Currently, we are working on a Stream based replication (something ...
0
votes
1answer
14 views

How to setup Master to Master Replication with Application auto failover

I have a requirement as follows , need to setup a Multi-Master replication with automatic application failover ,if one master goes down, Can anyone share me some information regarding this. Thanks ...
3
votes
3answers
110 views

SQL Server CTE Bottom to Top Recursive with Where clause

I have an Employee Table with an EmployeeId, ManagerId and a Name field. The goal is to make a recursive With fetching all the rows from an employee to the top manager (ManagerId is null). I found ...
1
vote
0answers
18 views

Postgres 10.6: UPDATE on partially indexed column sometimes hangs

I have a table (6 small columns 2M+ rows) with a column dead. There are two indexes on this table, both are partial with dead = false. From time to time I want to scan the table and mark rows with ...
0
votes
1answer
32 views

SQL Server Files in Secondary file group updates much slower from linked server

My SQL server fact tables are incrementally being updated with reference to a linked server. The queries run routinely on a regular basis and have been executing successfully for a long time. The ...
0
votes
2answers
30 views

How to list permissions on a schema?

In SSMS, if you follow the path [Database] > Security > Schemas and view any schema properties, you have a tab "permissions" that list all the permissions that every user have on that specific schema. ...
0
votes
1answer
29 views

pg_hba error while setting up repmgr

Please help me to figure it out, help is much appreciated! ERROR: FATAL: no pg_hba.conf entry for replication connection from host "172.18.0.4", user "repmgr", SSL on The following is a list of my ...
0
votes
0answers
27 views

“GROUP BY” to keep only the first 2 rows based on date

I have a list of online robots conversation, with the time indicating when a client started a conversation and when the robot answered. I am trying to measure how long does the robot take to provide ...
-1
votes
1answer
36 views

How to do group by based on another column in SELECT? [closed]

I have a table on which I do a SELECT statement. It is joined to some other tables. With the SELECT one column is got but a sub query. like (select top 1 .. from..) for each row. Now I need to do an ...
0
votes
1answer
37 views

After Update Mysql 8.0.13 to 8.0.15 MySql Server Fails with error code = 1265

After Upgrading from MySql 8.0.13 (compiled from sourcecode) to MySql 8.0.15, the MySql Server can not start. Log: 2019-02-12T10:09:52.275336Z 1 [ERROR] [MY-013178] [Server] Execution of server-...
3
votes
1answer
107 views

How to find inputs that caused different query plans in Query Store

Query store shows that a completely parameterized query has multiple query plans: How can I find the input that is causing such long response times? Why would the same parameterized query end up ...
0
votes
0answers
11 views

How to connect to Teradata from SQL Server 2016 running on Windows 2012 R2

We have SQL 2016 running on Windows 2012 R2. Requirement is to connect to Teradata database running on another server and pull data. We tried to setup linked server using 64 bit Teradata ODBC driver(V ...
-1
votes
2answers
29 views

Table Structure for Storing multiple foreign keys

I have two tables says, val_taxes and val_tax_groups the first table has all the tax separately like so val_taxes | id | tax_name | tax_value | ----------------------------- | 1 | sgst | 2.4 ...
2
votes
0answers
50 views

Streamline MSSQL backups using Veeam

I am looking for advice on managing backups using Veeam and optimizing storage space for backups. We have about 2TB across 20 DB My current backups are Image Level (Veeam) Replication to DR ...
0
votes
0answers
23 views

Oracle Forms 6i database compatibility

I have a forms & reports 6i running with a oracle 10g database. We're considering upgrading the database to 11gR2 or 12cR2, but I cannot find documentation providing database matrix compatibility ...
0
votes
2answers
50 views

What does select * from table where column * 'value'; do?

select * from table where column * 'value'; I accidentally wrote * for my where statement instead of =, and the query returned all rows in the table. Made me wonder why an error wasn't thrown ...
1
vote
1answer
24 views

SQL Server 2008 onward - Globalization with Date Time

My application is standalone windows application. Database is SQL Server 2008 onward. The application will be deployed on systems around the globe. User should view the date/time values in their own ...
0
votes
1answer
12 views

How to pause the subscriber end of transactional replication

How do I go about pausing transactional replication on the subscriber end. We have a publisher on Server A, a distributor on Server B and a subscriber on Server C. All are in the same network. Some ...
0
votes
0answers
15 views

Correct config wal-e s3 for minio

Try run PostgreSQL + WAL-E + Minio. Minio: https://github.com/minio/ yum install -y https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm yum install -...
0
votes
1answer
22 views

how to refresh table in pg-admin 4?

When i select table with view/edit data => all Rows then i try to refresh table for newly updated data in table from object tab. it seems it's not working.this works perfectly in pg-admin 3 but in pg-...

15 30 50 per page