Viewing 15 posts - 2,371 through 2,385 (of 2,603 total)
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
As mentioned before Microsoft or vendor should always be consulted.
But on this case the licensing documents are pretty clear.
From the Licensing Guide on the link above
December 1, 2017 at 12:40 pm
try expanding the connections tab on the left - the DBA ones would normally be on the bottom of it
November 29, 2017 at 10:46 am
Viewing 15 posts - 2,371 through 2,385 (of 2,603 total)