Questions tagged [split]
20 questions
4
votes
4 answers
SQL server database backup - Destination Disk - Adding multiple files - does it duplicate or split backup into the files?
When we do full data backup (using SSMS UI), at the bottom of the window we have the option to specify the destination as Disk and also to add multiple files.
My question is - does adding multiple files create duplicate copies of the full backup? or…
variable
- 3,590
- 4
- 37
- 100
2
votes
0 answers
Export and split QUERY results in multiple files
I would like to know if it's possible to export and split query results in multiple files. Let's assume I have a query returning 100 results and I want to save the results in 5 different csv files (20 results per file). Is there any way to do…
user110366
- 41
- 6
2
votes
2 answers
How to use "regular expression" to separate specific strings in Oracle
I have a string '(1:30,2:4,52:0,8:1)', and I need to use a regular expression to have this output:
field1 field2 level
1 30 1
2 4 2
52 0 3
8 1 4
The query I've wrote so far is:
select…
Pantea
- 1,510
- 5
- 31
- 59
1
vote
1 answer
Can I split text from one column into to two existing columns in My SQL
SELECT `Appointment`,
SUBSTRING_INDEX(SUBSTRING_INDEX(`Appointment`, ' ', 1), ' ', -1) AS Date,
SUBSTRING_INDEX(SUBSTRING_INDEX(`Appointment`, ' ', 2), ' ', -1) AS Time
FROM go_applicants
which separates the date and time but creates 2 new…
Dan Hardy
- 13
- 3
1
vote
1 answer
Mysql (win) Is it possible to get databases from multiple drives in the same time?
My question would be, is there any way to read the mysql data folder from different drives in the same time (Windows) ?
For example:
I have 1TB database from the drive C:, and another 1TB from the drive D:.
So when I start mysql it will simply see…
carouselcarousel
- 13
- 2
1
vote
1 answer
Parsing URL Links
I have a large data set of over 10k+ rows and I'm trying to parse the url link
that people of clicked on
here is a table: dbo.email_list
UserID Cliked_Linked
101012 https:// amz/profile_center?qp= 8eb6cbf33cfaf2bf0f51
052469 htpps://…
learning
- 49
- 1
- 9
1
vote
2 answers
Split read/write requests over different read/write datasources
Recently I have run some performance tests on the application I work on, and it turns out that it didn't do really well ( the problem is mainly between the back and the DB). So as investigating the problem\solution, we have found out that using…
ch.E
- 111
- 4
1
vote
1 answer
msaccess split db feature linked tables
We have an Access db that has around 300 linked tables (to SQL Server tables). To switch environments, we run some VBA code that re-links all these tables to the relevant server. But this seems to be very slow. Approximately 0.25 seconds for each…
Steve
- 21
- 3
1
vote
1 answer
SSIS 2016 conditional split with multiple columns in conditions
I am having an issue in executing a conditional split for upserting records into my production table, using SSIS 2016 and MSSQL 2016 (Standard Ed.)
I am trying to load two separate files (produced from an OpenVMS database) that contain…
Kulstad
- 95
- 9
1
vote
1 answer
MySql split table on insert
I am new so please go easy on me :)
I have the following table
CREATE TABLE `send_sms` (
`sql_id` BIGINT(20) NOT NULL AUTO_INCREMENT,
`momt` ENUM('MO','MT') NULL DEFAULT NULL,
`sender` VARCHAR(20) NULL DEFAULT NULL,
`receiver`…
mcgster
- 11
- 2
1
vote
2 answers
SQL Split Row Data Separated by Spaces
I am looking for a query
to find nth value in a list. The separator is anything greater than or equal to 2 spaces. (it can be 3, or 5 spaces).
Trying to avoid scalar value functions, since performance may be slower. The sentences can have any…
user172334
0
votes
1 answer
How can I disable the MaxScale readwriterouter for specific queries?
I'm using a Galera replication and MaxScale readwriterouter.
I'm facing an issue because the application has been developed with this flow:
start transaction
update a record
commit
read that record
The result is the the record is updated using the…
Tobia
- 211
- 3
- 11
0
votes
1 answer
best practice for splitting a running db?
i have been tasked with configuring a new MySQL server and splitting half our databases to it. i want to do this well and correctly. challenge is we can't bring the system down as our clients are constantly writing machine data to it. so i'm…
WhiteRau
- 103
- 3
0
votes
0 answers
Move data from existing column to new columns in Sequel pro
I need help with my SQL table, so thank you in advance for any comments. My table in Sequel Pro (example):
Object
Time
Intensity
. A.
. 1.
. 100.
. A.
. 2.
. 150.
. A.
. 3.
. 300.
. B.
. 1.
. 150.
. B.
. 2.
. 300.
. …
Serffest
- 1
0
votes
2 answers
Split Brain scenario Always on Availability group
Due to maintenance our primary site will be offline for few hours. I have an availability group where there are 2 nodes at the primary site and one node at the DR Site.
Since the Primary site will be off so I will need to failover to the DR site…
SQL_NoExpert
- 1,107
- 1
- 21
- 37