All Questions

Filter by
Sorted by
Tagged with
1
vote
1answer
90 views

Directory Verification with For Each Loop in SSIS

How can we check if a directory is valid or not inside for each loop . I am having multiple files at some location and i want to load that file but before this i want to check if the directory is ...
1
vote
1answer
26 views

How to select functions that belong in a given extension in PostgreSQL?

I am trying to compose a SELECT from pg_catalog that pulls function name, its schema name and the name of extension that created this function. To pull function list I use (a simplified version) ...
0
votes
2answers
149 views

First Responder Kit Power BI Dashboard - New Databases

With the PowerBi and sp_blitz scripts running in a scheduled task I can get the great dashboard and reports. However when I add a new database to the server they don't show up in the reports later ...
2
votes
3answers
57 views

Is it possible to add a DB to an Always On AG and setup replicas at different time?

I have a 3-node SQL Server Always On availability group. 2 nodes are on the same LAN, and the third one is on a remote site with high latency. I will add a huge DB (10TB) to the AG, so I would like ...
0
votes
1answer
210 views

Mysql not writing to binlog

Mysql is not writing events to binlog, I have tried change the binlog configurations, but can't solve. Conf: server_id = 2 log-bin = master binlog_format = row replicate-do-db = our_db log-slave-...
0
votes
0answers
20 views

Error importing MySQL/Percon server tablespace for individual tables

I am using Percona-Server 8.0.x and I am following percona xtraback documentation. https://www.percona.com/doc/percona-xtrabackup/8.0/xtrabackup_bin/restoring_individual_tables.html I am exporting ...
-1
votes
0answers
20 views

How could we bring all database vendors to offer free developer licenses? [closed]

If you're like me and develop multi-platform database tools, you understand how frustrating it is to still find database vendors with no free dev or at least "express" editions that do not expire in ...
1
vote
0answers
26 views

Database - limit of reading a table with a lot of concurrent batch read and writes

We have this table. It contains data which will be picked up by an hourly batch job for processing. Five times a day, there are also multiple batch ETL jobs which get data from other source table and ...
4
votes
1answer
624 views

What can I do to monitor “out of shared memory” issues?

I'm new to database administration and I would really like some advice on what tools I could use or what I could do to monitor "out of shared memory" issues. I've been seeing these "out of shared ...
0
votes
1answer
9 views

Json append results in error of - “No operator matches the given name and argument types”

clusters_v2=# UPDATE cluster SET "clusterCALogs" = "clusterCALogs" || '["test"]'::jsonb WHERE "clusterId" = 9; ERROR: operator does not exist: json || jsonb LINE 1: ...ATE cluster SET "clusterCALogs" ...
0
votes
0answers
11 views

Is it possible to disable strict mode per user

I have a host that I use for running some data import scripts. These are pretty old / legacy scripts that aren't important to anything and aren't sensitive. The host recently upgraded mariaDB and now ...
0
votes
1answer
134 views

How to get x amount of latest inserted rows in a table mssql

I have a remote db with some tables with over 1 million records. I need to export these tables, however, I have a number of records already from these tables in my local db instance. I would like to ...
0
votes
1answer
91 views

Table scan estimates when there are no stats on the table

Suppose I create a table with 1000 rows but don't gather statistics on the table or run a query that should trigger an automatic statistics creation: create table test( a int ) go insert into test ...
1
vote
0answers
16 views

Get durations from time series table where some condition holds consecutively

Given a table where each row has a timestamp and some measurement, how can I get all of the intervals during which the measurement consecutively satisfies some condition? Here's a jsfiddle (not sure ...
11
votes
1answer
2k views

Why is casting a DATE field to VARCHAR datatype non-deterministic and is there a way to make it deterministic?

I'm trying to create an indexed view where the index is on a field in the view which is a hash of a bunch of the columns of the underlying table in the view. Here's an example: CREATE VIEW ...
0
votes
1answer
98 views

Maximum or suggested number of bound query-parameters in InnoDB (MySQL)?

We have code that adds thousands of parameters to a query as members of an IN (...) criterion. My aesthetics say to bucket it into multiple queries, but I want an objective reason. Does InnoDB have a ...
1
vote
2answers
33 views

Alternative to slow [LEFT JOIN + OR] without UNION?

I have a reasonably simple query that returns all purchases for a given user, searching by his government issued id. The document could be in two different tables. The query using only left joins ...
-1
votes
1answer
16 views

What alternative sql method can I use to see more records, GROUP BY id only shows one row per unique id

What I want is per map id I want to be able to see the top highest scoring gangs (also I should be able to say from which date or a specific single day), (i thought of using GROUP BY ID, but it would ...
0
votes
2answers
41 views

SQL Server Setup Error

I'm getting the following error at the very end of SQL Server 2016 setup. Updating permission setting for file 'Local Machine' failed. Principal 'SYSTEM\CurrentControlSet\Services\Eventlog\...
0
votes
1answer
107 views

Costly HASH MATCH Aggregate

I have a view,which is slow when i query a simple select statement with a where clause.The where clause column is indexed(Non-clustered index) Here is the view and the plan. execution plan CREATE ...
0
votes
1answer
38 views

What could be the cause for my high disk IO latency (from sys.dm_io_virtual_file_stats DMV)?

These are the results from querying the sys.dm_io_virtual_file_stats DMV. (I add some calculated fields for clarity). I'm finding certain basic operations in Database 7 are bottlenecking core ...
1
vote
2answers
43 views

What realistic issues can occur from shrinking the log files on my database (either through the SSMS UI or issuing a DBCC ShrinkFile command)?

I've heard talk of potential corruption or data loss occurring from shrinking the database data or log files. I'm curious in particular about only shrinking just the log files, what are some real ...
0
votes
2answers
3k views

Unix domain socket “/var/run/postgresql/.s.PGSQL.5432” missing

I try to run an application where its database on postgresql. It won't work and I'm getting the following error whenever I try to interact with the Postgres service: could not connect to server: ...
0
votes
1answer
174 views

Restoring a FrontBase database

I have a FrontBase database that I am trying to restore. This is a database system I have no experience up until now so this may be a basic question. I am issuing the following command to restore c:\...
0
votes
1answer
24 views

Why when I JOIN to a casted field in an index view, the execution plan warns about “type conversion in expression”?

I thought an indexed view was materialized and therefor stored on disk. If that's the case, I would've thought that any type conversions I'm doing in the view would materialize as that datatype on ...
0
votes
1answer
23 views

Warehouse storage system (FIFO by BBD and date)

I have inventory table. CREATE TABLE inventory ( InventoryID int(11) unsigned PRIMARY KEY AUTO_INCREMENT, InventoryDate datetime, Quantity decimal(15,4), BBD date NULL, ItemID int(11) unsigned ...
0
votes
1answer
23 views

How do I recreate the XE database in Oracle 11g Express?

My Oracle XE database was useless mess of unused tables etc. Using SqlPlus and several google results, I finally managed to drop the XE database, but now when I connect with SqlPLus IO cannot create ...
-5
votes
1answer
25 views

Do DBAs need to work in Shifts? [closed]

My question is, do Database Administrators (DBA) have to work in Shifts always. I am currently working as a Junior DBA. I am afraid if I have to work in Shifts in future in case I work as Database ...
0
votes
1answer
34 views

SQL Server 2014 unable to connect on virtual machine

I have a problem, where I installed SQL Server Advanced Express 2014. Everything seems fine, I checked all I thought could be the issue, and everything that needs to be installed is there, but when ...
15
votes
1answer
3k views

Composite Primary Key in multi-tenant SQL Server database

I'm building a multi-tenant app (single database, single schema) using ASP Web API, Entity Framework, and SQL Server/Azure database. This app will be used by 1000-5000 customers. All the tables will ...
1
vote
1answer
44 views

Why can't the query processor produce a query plan with a FORCESEEK hint when I'm INNER JOINing by the clustered index on both indexed views?

I'm getting the following error when I try to use the FORCESEEK hint with the query below: Msg 8622, Level 16, State 1, Line 96 Query processor could not produce a query plan because of the hints ...
2
votes
1answer
648 views

Progress of mongodump operation jams at a random point

We are executing remote mongodumps to backup collections. For some time now sporadically one of these dumps stops to progress any further and remains to log out the same amount of documents processed ...
0
votes
0answers
25 views

MSSQL - Can not start snapshot agent

I'm trying to setup a replication, but the snapshot agent will not start. It tells me Error messages: Message: Data source name not found and no default driver specified Stack: at ...
-1
votes
2answers
62 views

SQL Server Agent job for LinkedServer

has anybody seen this error before? I have a job running on server A against linked server B. However linked server B is also server A. The job didn't complete successfully for the second times ...
0
votes
2answers
93 views

SSRS report does not work with multiple parameters

My data set has the following where clause: WHERE a11.PDPOID LIKE '%' + @POID + '%' My parameter @POID properties are set to single value. The report works, but if I change the parameter properties ...
1
vote
1answer
55 views

SQL Server experiencing THREADPOOL waits while still having plenty of available workers

I recently took a look at my production SQL Server's cumulative threadpool waits, and it's literally days worth of waits. So I started doing some digging. I'm on a 32 core, 64 bit server (running on ...
0
votes
1answer
669 views

Is it possible grant a PRIVATE Synonym from an the Table Owner schema to an User schema?

Is it possible grant a PRIVATE Synonym from an the Table Owner schema to an User schema? Background: We are doing microservice development and there is an sole owner schema and many different service ...
0
votes
0answers
16 views

SSHtunnelForwarder to Linux Box, then connect to Postgres RDS (AWS)

I'm trying to write a python script to update DDL in a Aurora RDS (postgres) on AWS. In Order to do this, I need to SSHTunnel to a linux box that sits at the edge of the VPC, then do another jump to ...
0
votes
0answers
18 views

ACE.OLEDB.12.0 is visible on Linked Servers Provider, still can't import EXCEL file

I just don't know what to do anymore. I've been searching in a LOT of topics. I"ve downloaded tons of providers from microsoft. I'm trying to import an Excel file to a database. I've been having this ...
2
votes
1answer
33 views

What's the best way to concatenate a multi-column foreign key?

We are expanding our data warehouse to include a new source system. In the new system, we want a single column for a primary key, but in the old system it's two columns. For exmaple: create table #...
1
vote
1answer
16 views

In place upgrade from Express 2005 SP 4 to Express 2014, does database size limitation follow?

We are currently attempting get around a file size limitation issue with our database. The database file size hovers around the 4GB mark (the database size limit is 4GB in SQL Express 2005). We always ...
1
vote
0answers
24 views

What is the best strategy to sort a table and store it in RAM periodically so that it can be served? [closed]

I have to serve a sorted leaderboard as a JSON on an endpoint. Since the data on the leaderboard would be constantly changing; instead of sorting the postgreSQL database on every request, our current ...
2
votes
1answer
3k views

MySQL SELECT query hangs - Opening Tables INNODB

On my server I have 6 MySQL databases. They all power Wordpress websites. For some reason, 2 of these databases are not accessible. To my knowledge they use INNODB, but I can't confirm it as even ...
0
votes
1answer
99 views

oracle conversion variable value to sequence name

please can someone help me? I want to call a sequence from a variable (seq_x) as in the code but I cannot. if :op.qt is not null then select BATCH_X_SEQ into seq_x from kbatchseq where ...
0
votes
0answers
32 views

MSSQL - Setting up simple Replication fails

Heads up: I'm a rookie when it comes to SQL Administration. Im seting up a simple MSSQL Replication running server '19 (developer edition). The server and agent services run as local admin on the ...
0
votes
2answers
174 views

Change naming conventions in SQL Server

In SQL Server 2014 we need to change naming convention for indexes and keys. The old naming convention is not following any standards. My questions are: How can we change the naming convention for ...
-1
votes
0answers
27 views

Merge two query table as one with all the data [closed]

I've two Query table with two column each Lets say FirstSet with column A and Column B which is derived from three different table, table1,2,3 . Column B is date when data was modified. SeconSet with ...
1
vote
1answer
101 views

How to improve query to include 2 critical pieces of employee data

I’m going to preface by saying that I’m fairly green with SQL. My code below works, however I am missing two vital pieces of my employee population: (1) those employees who have been invoiced but ...
2
votes
2answers
823 views

How to set the first row of CSV data as column name in SQL Server?

I am using BULK INSERT to read a csv file in SQL Server. Is there a way to keep the first row as column name while I am reading the file? If not, after reading the data from the csv (from second row),...
0
votes
0answers
16 views

mariaDB: store data outside the default data directory(in a new disk)

Mysql has "general tablespace"which can point to any directory outside default data path. by this we can store data to external disks. Is there similar option for marian db? Basically I want to store ...

15 30 50 per page