Questions tagged [split]
The split tag has no usage guidance.
19
questions
0
votes
1
answer
31
views
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 ...
- 103
0
votes
0
answers
60
views
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
0
votes
2
answers
978
views
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 ...
- 1,039
1
vote
1
answer
2k
views
Can I split text from one column into to two existing columns in My SQL [closed]
SELECT `Appointment`,
SUBSTRING_INDEX(SUBSTRING_INDEX(`Appointment`, ' ', 1), ' ', -1) AS Date,
SUBSTRING_INDEX(SUBSTRING_INDEX(`Appointment`, ' ', 2), ' ', -1) AS Time
FROM go_applicants
...
- 13
1
vote
1
answer
376
views
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 ...
0
votes
1
answer
348
views
SQL - Spilt timestamp into multiple rows
I am dealing with data that needs to be looked at on a shift-to-shift basis (8:00:00 to 20:00:00 and its reciprocal are the two shifts) There are instances where a timestamp (one row) will span longer ...
- 1
1
vote
0
answers
1k
views
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 ...
- 31
0
votes
1
answer
4k
views
Split date range (timestamp) into equal parts by Month- SQL Server
Experts,
Have a question regarding splitting a date range into equal parts by months including the time part
example - fromdate - 06/29/2020 09:00:00 and todate - 06/29/2021 09:00:00
Want to split ...
0
votes
0
answers
29
views
Count Split across Shifts
I have a table which registers orders with a PlanStartTime and PlanEndTime. The customer has three shifts in a day starting from 7 AM - 3 PM, 3 PM - 11 PM, 11 PM - 7 AM (next day)
Say an order is ...
- 11
1
vote
1
answer
312
views
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/...
- 49
1
vote
2
answers
785
views
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 ...
- 111
1
vote
1
answer
53
views
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 ...
- 21
2
votes
2
answers
2k
views
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 ...
- 1,412
1
vote
1
answer
493
views
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 ...
- 55
1
vote
1
answer
388
views
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` ...
- 11
0
votes
1
answer
203
views
Split Backup of MSSQL VS Stripe Backup of Sybase ASE
I recently came to know about concept of split backup in MSSQL Server whereas I have been working on stripe backup in Sybase ASE.
Stripe backup in Sybase ASE is faster than normal backup and if we ...
- 3,894
1
vote
2
answers
4k
views
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 ...
user172334
4
votes
4
answers
3k
views
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 ...
- 3,442
0
votes
2
answers
5k
views
string_split into multiple columns
Sorry if this question is very basic, but I just can't figure it out, and couldn't find any good answers.
I have a very long list of files, folders and Sizes. I need to Seperate the folders to ...
- 15