Viewing 15 posts - 2,416 through 2,430 (of 2,651 total)
YW.
Now that it was made clear that this is a VM you may wish to rethink it - by using VM instead of physical you are loosing on...
March 14, 2018 at 3:27 pm
Ahh,...
This is a VM which has been configured incorrectly from my point of view.
What type of VM is it? VMware or Hyper-V? or other...
March 14, 2018 at 3:08 pm
what is the output of this one?
sp_readerrorlog 0,1,'licensing'
and
select @@version
March 14, 2018 at 1:50 pm
One new "feature" to the installation...
The server has 16 cores and they are using STD...
March 14, 2018 at 12:26 pm
March 8, 2018 at 1:35 pm
Pretty sure of that also - and some questions from that were not answered - and eventually the solution is easy but not what the OP wishes to be given.
March 8, 2018 at 1:30 pm
your VM guy is right. shutdown guest does not always issue a clean shutdown.
For these type of situations is normally good to have prepared in advance a powershell...
March 5, 2018 at 6:45 pm
ahh.. forgot about this detail and didn't thought of asking about it.
Resource Governor only available on the Enterprise Edition and as far as I am aware there is...
March 5, 2018 at 5:14 am
Without knowing db sizes, usage and load on the current server as well as what their customers do with the server its hard to tell you which is better.
March 3, 2018 at 7:57 am
Not really aware of it but maybe related to the fact that the latest version for 2015 had issues deploying to SSIS catalog, mainly when deploying single packages.
in...
March 2, 2018 at 8:47 am
Jeff Moden - Thursday, March 1, 2018 7:38 PMHeh... so what's wrong with a simple INSERT/SELECT???
Didn't mention this one as this is...
March 2, 2018 at 2:29 am
get sp_whoisactive and run it while the lock is happening
http://whoisactive.com/downloads/
best to do it when you manually run the proc manually as at the point you know...
March 1, 2018 at 4:38 pm
Don't use SSIS for that as it sucks with LOB types.
Powershell or C# (can be inside a SSIS package script task if you prefer) with a sql reader...
February 28, 2018 at 11:11 am
no ties - within each sqn the ldts are unique
December 12, 2017 at 5:20 pm
did you find out your self or did you find something on the net?
We have a similar problem on our shop at the moment.
Thanks
December 12, 2017 at 1:03 pm
Viewing 15 posts - 2,416 through 2,430 (of 2,651 total)