Viewing 15 posts - 1 through 15 (of 185 total)
Hi Ral1l - Thank you for your reply. We have SQL running on EC2 instance and not Amazon RDS, there are limitations with running on RDS. Thank you.
February 26, 2020 at 2:39 pm
Thank you for the update, we ended up not using the instance storage. Our environment is an AG, saved myself some headache 🙂
July 1, 2019 at 8:05 pm
Grant, well said... Having worked with cloud and SQL DBA work, I found learning Powershell is a must. Anyone deals with cloud and managing different flavors of RDMS needs to...
April 4, 2019 at 8:04 pm
I know this is an old post, but I wanted to share my experience... I highly recommend not to place tempdb files on instance storage in a production environment because...
April 4, 2019 at 6:22 pm
You are correct, I know you can't declare variables in a view, I guess I should have said how to make this as a function or a SP and create...
March 13, 2019 at 6:40 am
I know this is a very old post, but I too wanted to do this today.. I found a PowerShell script similar to what I have below but the select...
May 16, 2018 at 10:04 am
Greetings Joe, thank you for sending the query. I followed John's query, and that worked perfectly. I was thinking of using merge, but I was wrong. I am glad I...
December 1, 2017 at 5:16 pm
Hi John,I agree, I figured my approach with using merge was incorrect. I am following your approach and see how it goes. Thank you for your input.
November 30, 2017 at 3:30 am
I have not used json, but why don't you try to use Powershell, http://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/ec2launch.html
If I have time tomorrow, I will play with it and update you. I use...
November 6, 2017 at 10:53 am
My understanding is that when you rebuild an index, only index stats gets updated but it does not update column stats. What you have is correct, you are saying do...
October 25, 2017 at 6:06 am
Great, BTW here is how to ignore truncation error with import wizard.. Thanks for replying back.
October 18, 2017 at 5:59 pm
Are you using data conversion for doing data transfer, have you tried to ignore truncation if error happened? See attachment.
October 18, 2017 at 12:30 pm
Sue,I agree, I could remove rule of CEIP by issuing Remove-ClusterResource but I preferred not do so because it was not recommended. Even though the documentation shows how to...
October 16, 2017 at 8:22 am
Hi Prettsons,My one challenge setting up the cluster is the CEIP resource, I had to deal with security issue and not having the resource failover properly to the other node. Is it...
October 13, 2017 at 7:18 am
I use Ola's solution, but try to adjust some of the default settings based on your environment, I specify below parameters:
sqlcmd -E -S $(ESCAPE_SQUOTE(SRVR)) -d Maint_DB -Q "EXECUTE...
October 13, 2017 at 7:06 am