All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
5 views

Can I implement Temporal Tables in SQL 2008 in a way that is painless to migrate to SQL 2016?

We have a system that is currently used by customers that have versions of SQL from 2008 R2 all the way to 2019. We want to start introducing, in a limited way, Temporal Tables, even for customers ...
0
votes
0answers
6 views

SQL Server Table Partitioning

Looking for documentation about partitioning tables in SQL Server. The last white paper I found was for SQL Server 2008 (12 years old). https://docs.microsoft.com/en-us/previous-versions/sql/sql-...
0
votes
0answers
5 views

RDS Oracle 11G ORA-01031: insufficient privileges on create materialized view

Here is my situation. Was sent to me a RDS Oracle 11g to manager. This resource was create through a terraform script and the "sysadmin" credentials delivered to me To me everything is fine to work ...
0
votes
1answer
24 views

How is it possible that some people are able to juggle several different SQL variations in their heads at once? [closed]

I have spent the last 20 years dealing with first MySQL (for about 6 years), then 14 years old PostgreSQL. In 2006, I naively thought that it was going to be painless, "because both use SQL"... man, I ...
1
vote
2answers
18 views

Is there any performance issue with including the “COLLATE” as part of the query as opposed to setting it for the column/table?

PostgreSQL has this "collate" concept. You can either tell a table's column to always have a "collate", or you can do it in the query. If I do it in the query, does PG punish me somehow performance-...
0
votes
2answers
28 views

Oracle License question - migration

Oracle EE 12.1.0.2. I need to migrate an existing (licensed) database from Server A to Server B. Do I need to license Server B during the period of time that both servers are running? The period of ...
2
votes
1answer
11 views

What is the meaning of “-x-icu” in PostgreSQL's “collates”?

I had this query: SELECT * FROM table ORDER BY label ASC; Since the labels are not in English, they didn't get sorted in the right order (ones beginning with "ö" were not in the bottom/end). I ...
0
votes
0answers
24 views

SQL Server 2019 Performance Regression

We have recently upgraded our DEV environment from MSS 2016 (2012 Compatibility Level) to MSS 2019 (Native). We are seeing performance regressions across almost every query (approx. 12,000). Has ...
1
vote
0answers
23 views

How to prevent Dropping of tables but allow Creating of them, within a Schema

Is it possible to, within a specific Schema, allow a user to create a table, and select from it, but not allow them to Delete or update rows after initial creation, and also prevent them from dropping ...
0
votes
1answer
12 views

PostgreSQL: Save roundtrips / Network performance

For my work I often have to to large selects loading a lot of data. The connection happens with JDBC driver and high fetch size. This is not a problem when working directly on the server of the ...
0
votes
0answers
16 views

How do I know if an index has been successfully created in MySQL?

I use Capistrano to deploy a Rails app. Capistrano handles running database migrations via essentially a shell script that runs from my local computer. About 24 hours ago I started a migration that ...
3
votes
0answers
21 views

Recursivly get a Tree Via self joined table

Using other questions here & Postgresql documentation I've managed to build a many-to-many self joined table. However adding a WHERE clause is giving me trouble. Problem: A Category can have ...
0
votes
1answer
12 views

Column Terminology

I'm a MySQL student here trying to learn the proper way to call things in the SQL language. CREATE TABLE tbl_name ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, width SMALLINT ...
0
votes
1answer
10 views

Strange behavior of query with pg_sleep

I have plpgsql anonymous block. PostgreSQL 10. I store current time to variable, raise notice with value of the variable, sleep for 20 seconds, store current time to another variable, store both ...
1
vote
0answers
6 views

MySQL 8.0.18 - ST_Area returns invalid value

I have a problem with ST_Area function in MySQL 8.0.16. The result of the procedure call returns a different result than any library used to calculate the area of a polygon. Example: I have a ...
0
votes
0answers
7 views

Postgres randomly fails silently on huge CSV import

With Postgres 10.12 on Windows 10, I am importing at 67 GB CSV file into a database using a simple COPY query: COPY table_name FROM 'c:/temp/data.csv' WITH (FORMAT csv, HEADER); The import fails ...
0
votes
0answers
34 views

SQL Server 2019 Always On performance

We are in process of development of project which will process around 51 000 000 records daily (~around 500-600 inserts per second). We choose Always On solution in SQL Server 2019 which will contain: ...
0
votes
2answers
20 views

PostgreSQL: Allow connection by host name and not IP?

As background when connecting from remote (eg home mostly using JDBC) due to how the VPN works I always get a different IP address and hence I can't connect because the IP isn't listed in pg_hba.conf. ...
0
votes
2answers
42 views

ORACLE TABLESPACE USERS GETS 100% USED

I am facing a problem with oracles users tablespace. It automatically grows really fast. What kind of data is stored there? And what happens when it hits 100% of space used? Is there a solution to ...
1
vote
1answer
7 views

Run Mongodb Server as Service and mongod instance

I am using ubuntu and can run mongodb server by the following command systemctl start mongodb But, if i want to run Mongodb by mongod mongod --dbpath /var/lib/mongodb it gives me Permission ...
1
vote
1answer
24 views

Composite index performance with varchar columns

I have large fact tables with composite non-clustered indexes, something like this: NONCLSUTERED INDEX (OrderDate,OrderType,ClientKey,ItemKey,CustomerKey) The columns ending with "Key" are varchar(...
0
votes
0answers
9 views

Invoke-ProcessASDatabase fails with “Cannot connect to server”

Occasionally I'm getting this error: Cannot connect to server 'myASCube'. Client with IP Address 'x.x.x.x' is not allowed to access the server. To enable access, use the Firewall settings in Azure ...
1
vote
1answer
48 views

Is it better to add a data file or better to increase the existing files (MAXSIZE)

I'm quite familiar with SQL-Server as a developer but not so much in the DBA role. Currently I'm working on a rather large DB (~7TB, living in 7 files, all equal in size and all within one single ...
2
votes
0answers
41 views

SQL Server 2019: InitPersistentVersionStore failed after installing CU2

I have installed SQL Server 2019 CU 2 over a vanilla install of SQL Server 2019 RTM. Now I am puzzled by the following messages in the error log at startup: RecoveryUnit::...
0
votes
0answers
6 views

How to set dynamic variables in hive?

The following line will return me an integer of current hour in normal hive statements: HOUR(CURRENT_TIMESTAMP) Next, I want to set above value to a dynamic variable named hour_value: set ...
-2
votes
1answer
21 views

insert one table automatically to other table reference column

How to make an insert in one table update a second table? that already insert table...... List item create table table ( id int , student-name var-char(45) ) create table table ( id int , student-...
0
votes
0answers
8 views

Postgres point type column to Spring Entity data type

I have a postgres table: CREATE TABLE public.geometry ( id serial not null primary key, coordinates point not null ); and I am trying to retrieve a row as JSON response API from a ...
-1
votes
1answer
34 views

Why is the order of `OFFSET` and `LIMIT` treated differently between PostgreSQL and MySQL?

I have a schema like this (works for both MySQL8 and PostgreSQL12) # 1. Build schema DROP TABLE IF EXISTS Employee; CREATE TABLE Employee ( Id INT, Salary DECIMAL(6, 2), PRIMARY KEY(Id) );...
0
votes
0answers
19 views

using SUM on foreign view's keys grouped on multiple key/values?

I had a question on executing SUM on rows from one table and inserting them in a column on another table where the calculated rows shared id with a row in the new table. The solution worked very well ...
-2
votes
0answers
33 views

How to use CASE statement in DROP TABLE and CREATE TABLE statement?

I know how to use CASE WHEN THEN statement in SELECT statements. But I try to do the same thing in DROP TABLE and CREATE TABLE statements: DROP TABLES IF EXIST CASE hour(CURRENT_TIMESTAMP) % 2 ...
0
votes
1answer
10 views

After change to 13306, Galera logs error: Slave I/O: error connecting to master 'repuser@<master node ID>:3306'

Working with Galera 25.3.23 on RHEL 7.3 Galera works good before. After changing the MySQL server port from 3306 to 13306, one of the node report error, after restart: Slave I/O: error connecting to ...
0
votes
0answers
19 views

Unable to create ssis db catalog

I am trying to create ssis db catalog using wizard but getting this error message: The catalog backup file 'C:\Program Files\Microsoft SQL Server\120\DTS\Binn\SSISDBBackup.bak' could not be ...
0
votes
1answer
10 views

Migration DB postgresql in windows to Red Hat(linux)

I would like to know how I could migrate a postgresql database which is currently in a Windows operating system to Red Hat? I'm a beginner and I don't know where to start. Thanks .
-1
votes
0answers
11 views

is it possible to trigger lambda AWS Postgres RDS

we are using AWS Aurora Postgres, is it possible to invoke lambda if any event was triggered in RDS, if any post already is there means please let me know Thanks in advance
0
votes
1answer
20 views

MySQL: Should I keep a running total column in one table instead of summing a second table?

I have 3 tables named users, achievements, and userAchievements. The users table contains information like username, password, e-mail, etc... and the achievements table contains a list of possible ...
1
vote
1answer
32 views

minimum space is required on disk to restore a backup in SQl Server?

Suppose I am going to restore a backup (2 GB) in my sql server, I have sufficient space (20 GB) in my disk, but is there any algorithm that SQL server follows to calculate the minimum disk space ...
0
votes
0answers
13 views

How to improve postgreSQL availability [closed]

What are the methods to improve postgreSQL's availability?
0
votes
0answers
25 views

How to reconcile databases after split-brain?

We run three on-premise datacentres with several databases. The network between the three datacentres is not constant and goes down several times a year for lengthy periods of time, but the ...
0
votes
0answers
16 views

Fast long-to-wide reshaping in PostgreSQL

I am trying to change a really long table (1955451890 rows -- 278 Gb on the DB) to a wide format using crosstab from the tablefunc extension. Following several examples from SO (i.e. Crosstab with ...
4
votes
0answers
42 views

how to remove all permissions in a database?

every time I need to either restore a database or reinitialize a replication publication I first (on the restored to be or subscription database) I script all the permissions, triggers, indexes, ...
1
vote
1answer
23 views

how to list the SSRS permissions in each folder in the reporting services server?

I have the following powershell script that downloads all the RDL from a reporting services server. I am not the author to whom I am very thankful. It has been very useful for downloading the RDLs. ...
0
votes
1answer
24 views

How can I create a table to lookup values for combinations of varying sized sets of numbers?

I have a table of products, each with it's own id (int) as primary key: product_id name 3 product1 4 product2 6 product3 10 product4 I have a table of ...
3
votes
1answer
31 views

What happens when there's no tempdb space for version store operations?

If tempdb runs out of space, do transactions that need version store space fail, or do they wait for space to be freed?
1
vote
1answer
224 views

SQL Server Agent fails after installing SQL Server 2019 CU2

After installing CU2 our SQL server agent randomly stops working. If you go to check on the status of the agent by opening Job Activity Monitor, it comes up blank for a while then throws an error: ...
0
votes
0answers
9 views

Archive enabled and disabled

Why we cannot set archive enabled and disabled in startup why in startup mount we should set the archived enabled and disabled why not in open database plz answer
0
votes
0answers
14 views

What is the difference between candidate key, super key and alternate key

I'm in IT but not in software development or database. I studied about DBMS subject 6-7 years back. I have confusion between these, candidate keys are like ideal candidates to become become primary ...
2
votes
0answers
37 views

CREATE TABLE IF NOT EXISTS fails with privilege exception when table exists

I discovered that CREATE TABLE IF NOT EXISTS will fail with insufficient_privilege if the role executing the statement does, in fact, not have the necessary privileges, but does so regardless of ...
1
vote
3answers
25 views

mysqldump interrupts always with same file size

mysqldump -h127.0.0.1 -u user -p'password' -t db mail --where 'status=3' > /var/www/project/storage/web/dump2.sql I try it on ubuntu 18.04, mysql 5.7.29. And the file is always 141.8MB. Data just ...
3
votes
1answer
98 views

sp_Blitz fails with collation error

SQL Server version (output from select @@VERSION): Microsoft SQL Server 2017 (RTM-CU19) (KB4535007) - 14.0.3281.6 (X64) (Build 14393: ) Installed sp_Blitz from Brent Ozar, stored procedure creates ...
0
votes
0answers
15 views

AWS DocumentDB vs MongoDB performance issue

I am helping to support a Node.js application which uses MongoDB on an EC2 instance as the back end. The database is about 14 GB and the largest table has a little over 15 million documents. To test, ...

15 30 50 per page
1 2 3 4 5 1625