Viewing 14 posts - 1 through 14 (of 14 total)
Thank you. That gives me the idea.
July 15, 2020 at 11:38 pm
The temp table #enc18mts I created is meant for contacts in past 18 minths.
Then I am extracting records that are not in #enc18mts .
And its not just "past 18 months",...
July 15, 2020 at 9:05 pm
What do you suggest?
Thank You
July 15, 2020 at 8:53 pm
I wrote a sql that does the following, But I am not getting correct results:
--get past 13 month contact records for all members/contacts in base table AllEnc.
SELECT MemberNumber,
ContactNumber
ContactDate,
INTO #enc18mts
FROM AllEnc...
July 15, 2020 at 8:46 pm
October 12, 2017 at 7:15 am
yes, I read the blog.
yes I am restoring the backup to a new server.
Where are you seeing the difference the file path?
CREATE...
June 23, 2017 at 9:39 am
That could be a typo. I have the same path:
--Query 1 : Restoring master key
-----------
Restore master key from file = '\\MyShares\Projects\UploadFolder\CLM_bkpcertificateKey.key'
decryption...
June 23, 2017 at 8:50 am
The same account can do a backup of a db to the folder location mentioned in the script, so the permissions to the folder are good. What else do I...
June 23, 2017 at 8:10 am
I am working on this analysis now. Will post it as soon as I get to know. After the update stats, a step that used to take 12 hrs, finished...
August 30, 2013 at 4:30 pm
we are dropping indexes before inserts and re-build after the inserts are complete.
My main issue is why the ETL is taking more time on Sql 2012 then it is on...
August 30, 2013 at 1:44 pm
Auto Create Statistics and Auto Update Statistics is set to true for all the Dbs that this ETL touches. On your suggestion, i also updated the statistics for all DBs...
August 30, 2013 at 9:56 am
I created another certificate with CN="Myserver" instead of "CN=myServer.MyOrg.org" and did the configuration the same way as above. It works now.:w00t:
August 20, 2013 at 5:51 am
Viewing 14 posts - 1 through 14 (of 14 total)