Viewing 15 posts - 61 through 75 (of 113 total)
Thank you for your help. I have tested "LOAD DATA INFILE" from csv.
The main problem is CSV itself generating wrong data.
Ex: if I have columns like this, value is loaded...
November 7, 2022 at 10:38 am
Thank for your valuable time frederico_fonseca for testing it out.
I have tried earlier the other two methods as you said. It is bit complicated with create schema should match with...
November 7, 2022 at 2:47 am
Hi,
I do not think it is VM or resource issue. I have same setup in my local laptop as well, 8 CPU with 16 GB RAM on SSD. DB size...
November 6, 2022 at 1:04 pm
if workbench is that slow it may have to do with your server specs - or with your network.
can you tell us the specs of both servers - as...
November 6, 2022 at 2:15 am
Can you make a linked server to MYSQL ? Then use that to push data ?
I have linked server from MS to MYSQL, How to push the data? Cannot...
November 5, 2022 at 10:18 am
Question: what kind of connectivity do you have between the two instances? 😎 Migrating the data via CSV export/import is one of the most labour-intensive methods.
If you have any...
November 3, 2022 at 6:53 am
Hi,
I have created ODBC connection.
November 2, 2022 at 12:18 pm
Oh, okay, Gotcha. Something like this?
select backup_path
, LEFT(backup_path,CHARINDEX('\FULL\',backup_path,1) + LEN('FULL\'))
from #tbl_backup_path;
Thank you working perfect.
April 2, 2022 at 4:53 am
I want to return the up to last \ (OR) FULL\.
ex:
\\x.x.x.x\Database_Backup_Daily\ServerName$SQLEXPRESS\db_1\FULL\
April 1, 2022 at 4:39 pm
Thank you Brian for the note.
I have some idea now to prepare documentation.
January 31, 2022 at 3:40 pm
Thank you Ken McKelvey for sharing the TSQL code incompatibility. I will note down that as well.
Thanks for the database movement process, that really helps me. We will build maybe...
January 29, 2022 at 5:18 am
Hi All,
Cardinality estimator is very good point. Thanks for that Grant.
I have asked to upgrade from legacy to supported version.
We are planning to do side by side upgrade. No idea...
January 28, 2022 at 3:47 pm
Thanks for your response. Understood.
https://docs.microsoft.com/en-us/troubleshoot/sql/general/use-sql-server-in-windows
We will go side by side upgrade, let us say I need to do in place upgrade of SQL 2012 on windows...
January 28, 2022 at 8:50 am
Thank you, if then I can limit 4 cores to SQL by affinity and 4 cores to applications.
December 2, 2021 at 9:57 am
Viewing 15 posts - 61 through 75 (of 113 total)