All Questions

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 ...

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, ...

How to define schedule to rebuild all database index in SQL Server 2008 R2.

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 ...

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?

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 ...

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 ...

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:...

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 ...

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 ...

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 ...

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. ...

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, ...

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 ...

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. ...

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 ...

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 ...

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 ...

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, ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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? ...

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....

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 ...

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 (...

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 ...

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 ...

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 ...

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 ...

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 ...

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. ...

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 ...

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 ...

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 ...

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-...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 -...

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-...