Questions tagged [split]
The split tag has no usage guidance.
11
questions
4
votes
4answers
2k 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 ...
2
votes
2answers
200 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
vote
1answer
48 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/...
1
vote
2answers
908 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 ...
1
vote
2answers
71 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 ...
0
votes
1answer
53 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 ...
0
votes
2answers
3k 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 ...
0
votes
0answers
14 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 ...
0
votes
1answer
26 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 ...
0
votes
1answer
53 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 ...
0
votes
1answer
131 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` ...
