Viewing 15 posts - 16 through 30 (of 113 total)
sgmunson - Thursday, June 21, 2018 3:21 PMJust wondering if that file actually contains Unicode characters?
It does contain Unicode characters.
June 26, 2018 at 7:38 am
June 21, 2018 at 12:44 pm
June 21, 2018 at 7:06 am
Ok, so what I did was I deleted 6930 record from the flat file, ran the job again and it still stopped at 6929. Then I deleted 6929 and it...
June 5, 2018 at 1:11 pm
June 5, 2018 at 12:42 pm
May 30, 2018 at 10:26 am
sp_dropserver 'old_name'...
May 14, 2018 at 10:08 am
May 14, 2018 at 8:25 am
----------------------------------------------------------
--...
May 9, 2018 at 2:14 pm
Unless I create a temp table and then insert data. It is time consuming but should work so it should be something like thiscreate table EmailActivity05092018
([leadId]...
May 9, 2018 at 11:57 am
April 27, 2018 at 12:35 pm
Sorry to be PIB but just confirming. You create a clustered index on a column (EmpID int) and then records in this column are stored in an asc order (1,2,3....)...
April 18, 2018 at 12:48 pm
So far this is what I have. After I created a clustered index on a table which was about 14 GB in size. Before I created the index, total amount...
April 12, 2018 at 3:02 pm
I am going to change the backup script to remove the week folder so it it will be 'F:\SQL_BKP\['+@name+']\backupfile.bak' which should make my life easier. Thanks SUE_H for the help.
March 28, 2018 at 10:28 am
Viewing 15 posts - 16 through 30 (of 113 total)