All Questions
72,344 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-...