0
votes
0answers
2 views

How can I transfer a list of tables from SQL Server to Jet in SSIS

When supplied with a table name in a variable (e.g. "SHIPPING"), how can I use SSIS to pull data from that table in SQL Server and push it to a Jet database into a table with the same name and data ...
0
votes
0answers
4 views

Unable to rename table due to metadata lock

I am trying to rename a table but it always just hangs with a Waiting for table metadata lock. Here is how I am trying to do it: start transaction; RENAME TABLE `main_territorypricing` TO `...
0
votes
0answers
7 views

How to join to the same table multiple times?

I have two tables, "hierarchy_table" and "name_table". The hierarchy table contains an object which has multiple parents and children. Each parent and child is referenced by id. | object_id | ...
0
votes
0answers
5 views

oracle sql developer

this is my script...i don't know why this is not running.thank in advance for those who will help to solve my problem :) .. the eff_year and the from_year is not the same btw... select bracket, ...
0
votes
1answer
12 views

differences between SPID and session_id

I'm configuring a job to get the SPID of an offending process and kill it. I'm using a mix between the great sp_Whoiscative from @AdamMachanic and joining with sysprocesses on login name and SPID and ...
0
votes
0answers
3 views

Best way to get the latest Identity when inserting through View

I am using View and View trigger to insert data into multiple tables. In this case, how can I get the inserted ID of the specific table? I was using IDENT_CURRENT but it's not recommended. How can I ...
0
votes
1answer
8 views

How to find out to which roles tables belong?

I was wondering if there is a way to find out what roles 2 tables reside? I have 2 tables and I want to find out to which role they belong? Is there a way to find out? Thanks
0
votes
0answers
5 views

regarding creating two colums using the CONCAT and CONCAT_WS function

Complete newbie here using SQL. Sorry if i don't make much sense here. Basically i'm trying to combine fields on a database that would keep customer's details. For example: fields: customer_title,...
0
votes
1answer
12 views

Question when designing a database

I have started to design a database for a company which I work for. I am curious how the professionals would design such a database and what advice you might carry. Information about the database: ...
1
vote
1answer
10 views

Using floats for PKs. Is it a good idea?

Let's say I have an entity PizzaStore which has a location as part of its attributes Now a PizzaStore can have N of other PizzaStore that are close by. So seems to be a self referencing relationship 1-...
0
votes
1answer
17 views

SELECT * Returns 1 Record, But SELECT COUNT(*) Shows 3k+ Records

I imported a csv file that had more than 3k records into a database table in SQL Server using the Import Wizard. I do not receive any errors, and the import wizard shows success, with 3217 records ...
1
vote
2answers
19 views

Select if colA='A1' is followed by colA='A2' [SQL]

I have a set of entries like: Id ColA 1 A1 2 A2 3 B 4 A2 5 A1 6 C 7 A1 8 A1 9 A2 10 D In pairs 1, 2 and 8, 9 the first line has A1 in colA and the following line has ...
0
votes
0answers
5 views

View-Specific MySQL Replication

I'm trying to replicate only a portion of a table on Computer A (running an instance of MySQL) to a MySQL instance on Computer B, something that could easily be represented by a view. I know it is not ...
0
votes
0answers
6 views

Finding the most commonly used non-stop words in a column

Simply put, I have a postgres column containing ordinary prose and would like to determine the x most commonly used words ("word" being a group of characters deliminated by a space, but not a stop ...
0
votes
1answer
10 views

Pressing Ctrl+C during UPDATE query in Postgres, was the query partially run?

I accidentally launched unwanted UPDATE query inside psql (9.4) and killed it with CTRL+C a few seconds later. Were there any records modified, or it's all or nothing?
0
votes
1answer
12 views

adding a column with default value to slow in mysq 5.1

I am adding a char(1) column to a table with this: mysql> alter table TransaccionesConvenio add Test2 char(1) default 's'; Query OK, 6711062 rows affected (52 min 27.75 sec) Records: ...
1
vote
3answers
55 views

10+ minute query time with DATEPART in WHERE clause

I have a list of records with datetimes over more than 1 year. My goal is to compare the count of today's records with the count of records from last year, where the week # and day of the week from ...
1
vote
2answers
123 views

SQL Server INNER REMOTE JOIN returns more rows than INNER JOIN

I'm trying to join a few rows from a remote view to a local table. The view has about 300 million rows, so I want to use the REMOTE query hint so that all 3 million rows don't have to be transferred ...
1
vote
1answer
14 views

Map ASM files to physical Linux Devices

We are having problems with log file sync waits periodically. We have a 2 node RAC cluster using ASM. I'd like to monitor the physical device(s) containing the REDO log files using iostat, but I'm ...
0
votes
0answers
11 views

NT SERVICE\MSSQL$SQLEXPRESS user cannot be found when added to network drive

For SQLEXPRESS 2016 I would like to backup/restore directly to/from network storage I have mapped to drive S:. SQLEXPRESS runs under the (virtual?) account NT SERVICE\MSSQL$SQLEXPRESS as it should, ...
0
votes
1answer
11 views

Postgres - fast way to enforce AND across multiple rows

I've got a 4 column table with ~25M rows: tweetifai=> \d core_tagusage; Table "public.core_tagusage" Column | Type | ...
1
vote
0answers
10 views

SSRS 2016 Mobile Report Color Settings

In SSRS 2016 Mobile reports are a new option for Native mode report server. I have created several now and there appear to be consistencies between colors on different charts and graphs if the same ...
0
votes
0answers
13 views

Trigger not working error column “G:\Work Orders\Work Orders” does not exist

PSQL 9.5, OS Win7 Using information I gained from; Set a column's default value to the concatenation of two other columns' values? I built a trigger that is suppose to create a hyperlink in ...
0
votes
0answers
3 views

Recommended maximum memory setting for PostgreSQL 9.4+ with Huge Pages

Since PostgreSQL 9.4+ supports Linux Huge Pages, I have configured a Ubuntu 16.04 server with 16GB of RAM and 8 CPU cores to use Huge Pages with a dedicated PostgreSQL 9.5 instance. The estimate in ...
0
votes
2answers
29 views

Storing multiple contact addresses for a person

Simplified diagram for reference. My database stores information about people in the following way. There is a Person table containing common personal information fields; name, date of birth, ...
0
votes
0answers
15 views

Select all from table where ColA equal to (get list of ColA values that correspond to ColB = 'NOT')

I have an SQL table that has entries like: RuleID Symbol 1 OR 1 123 1 363 2 AND 2 847 2 287 3 AND 3 NOT 3 234 3 ...
0
votes
0answers
9 views

Is there a way to compare very short periods of activity in Oracle?

I am having a problem with an application that requires very low latency (less than 100 ms per txn.) Every once in a while we will see spikes where transactions take 20-30 SECONDS. We looked at the ...
0
votes
0answers
8 views

which is better firebase or mysql in developing a android application using android studio? [on hold]

i am thinking of the database software application and which of these is better to use as a database application for android studio? and easier to connect to android studio? thanks for your answer :)
0
votes
1answer
22 views

Default Value Of Table

In my example syntax below I want the field delayed to be the difference in days between gotitdate and dunitdate I know that this syntax will get me the result, and I was going to set this up as an ...
1
vote
0answers
9 views

How to create ROW VALUE index

I have a table, lets call it mytable: CREATE TABLE mytable { id INTEGER, ts TIMESTAMP WITHOUT TIME ZONE, .. ) and I have following query in multiple client applications: SELECT ... ...
0
votes
0answers
13 views

Unable to connect to any of the specified MySQL hosts [on hold]

I have an app we use at my company, this app works well, but the problem is not in the code of my app because this works fine, so the problem is because yesterday i used a query: Update mytable set ...
0
votes
0answers
2 views

How can I log an error from a MariaDB scheduled event?

I've written a lot of Oracle PL/SQL, but I'm relatively new to MariaDB. My code looks like this: drop event if exists scs_system.persistent_jobs_processor; delimiter // create event scs_system....
0
votes
1answer
15 views

Postgres - Multiple commands on table at the same time

How robust is Postgres when it comes to running multiple commands on a table at the same time? Can I for instance, set a primary key and create a couple of indexes using multiple separate commands at ...
0
votes
0answers
22 views

SQL SERVER - “ApplicationIntent=ReadOnly”Listener redirect to fully qualified domain name

Hi all my DBA has setup a primary myNodeA and secondary node myNodeB and I'm trying to access the secondary node using "ApplicationIntent=ReadOnly" in JDBC connection string. The problem we are ...
-1
votes
1answer
12 views

How can we migrate Data with MySQL 5.1 - MyISAM to another server with MySQL 5.6 - InnoDB

Currently we have a MySQL 5.1 - MyISAM database on a physical server. We need to move it to another server with MySQL 5.6 - InnoDB at another location. DB size is quite large - 210GB Can someone ...
0
votes
0answers
23 views

Split string and and compare parts in WHERE

I had table with string column like 'One Two Three'. A need to split this string by space and use parts in WHERE clause. For example: SELECT * FROM records WHERE regexp_split_to_array(client_name, ...
0
votes
0answers
9 views

Issue with Relationships in Access Overview

I am currently working within Access 2013. I have a simple task that has been really driving me crazy these past few days, as I thought my relationships where correct. But when adding more data into ...
0
votes
1answer
26 views

Finding the row with the latest date for each row type

I've got an SQL database (SQLAzure V12 version running on Azure) that looks like the following: DECLARE @VehicleData TABLE ( id int PRIMARY KEY, Registration nvarchar(50) NOT NULL, [...
0
votes
0answers
11 views

Database and internal website [on hold]

I wanted to know what are the different possible ways of creating a database using an internal website. I want to make workers enter some data in a form on a tablet and that the data is directly ...
0
votes
1answer
26 views

Review the Design of My RDBMS (MySQL 5.6)

I am developing a web application for conducting Phishing Awareness testing (Github Repo). I have been getting tons of feedback on CR.SE to this project. It can be referenced if you want to get a more ...
0
votes
1answer
36 views

how to take output from second table by joining in SQL [on hold]

table 1 table 2 id Name value id status 1 a 1000 1 open 2 b 2000 2 closed 3 c 3000 ...
0
votes
0answers
9 views

Counting entites based on status in rolling interval

Given the following table: CREATE TABLE status_log ( entity_id bigint NOT NULL, user_id bigint NOT NULL, status character varying(128), "timestamp" timestamp(6) without time zone ) I want ...
0
votes
1answer
28 views

Attaching / creating database on network drive - Access is denied

I have two computers, computer A is with SQL Server but has no space left, the other is computer B which has free space. I'd like to create a new database on computer B. This is what I've done so far:...
1
vote
0answers
9 views

Restoring MariaDB Galera cluster fails (IST/SST)

A few days ago we experienced a crash with one of our MariaDB Galera nodes. I'm having serious problems with syncing the offline node with it's master again. For now, the 2 nodes are running ...
0
votes
3answers
36 views

How to select duplicates into new columns?

I am trying to select distinct data in new columns! My Table productID | imageURL 1 | a1.jpg 1 | a2.jpg 2 | a3.jpg Target Table productID | imageURL1 | ...
5
votes
2answers
402 views

Brent Ozar First Responder Kit filter

About once a week the query sp_Blitz @IgnorePrioritiesAbove = 50, @CheckUserDatabaseObjects = 0 shows "errors" with DB backups that are very old. It's correct to show this, but is it possible to ...
0
votes
1answer
15 views

Mysqldump failing while restoring database - MySQL 5.6

I have dumped one of my databases of size 5-6GB. I'm trying to restore to another instance but the same is getting failed after sometime with the following error: ERROR 2013 (HY000) at line 12006: ...
1
vote
1answer
10 views

Ternary Relationship or (n-ary)

I'm trying to find the difference in terms of modeling a ternary relationship v/s a binary relationship in the following case. Any piece of advise would help me a lot. Company has editors who are ...
1
vote
1answer
34 views

sys.dm_exec_query_stats - what causes total_worker_time to be reset? How to work around that?

I am monitoring stored procedure executions, mainly the execution times and the CPU usage, using sys.dm_exec_query_stats in the script below. SET NOCOUNT ON; declare @lastex datetime select @lastex =...
0
votes
0answers
15 views

In-memory file group and log are growing huge and fast

We have a DB in stress environment: SQL Server 2014 (SP1-CU3) + Always ON The whole db is around 850GB, but in some point something happens and in memory FG is growing to 250GB and a log to 450GB (...

15 30 50 per page