Viewing 15 posts - 2,326 through 2,340 (of 2,567 total)
did you install SSDT also?
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
March 26, 2018 at 11:11 am
March 20, 2018 at 6:44 pm
March 20, 2018 at 12:47 pm
If your PowerBI is loading the whole table then following will most likely apply.
Even if not some of it may still be worthwhile doing.
PowerBI uses the...
March 19, 2018 at 7:07 pm
any further char that you wish to include add them to the list
select *
from #TEMP t
where patindex('%[^A-Z ''-]%', name) = 0
[^A-Z ''-] means any...
March 16, 2018 at 8:04 am
select *
from #TEMP t
where patindex('%[^A-Z ''-]%', name) = 0
will do the trick here - but be aware that depending on your collation you may need more...
March 15, 2018 at 4:38 pm
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
Viewing 15 posts - 2,326 through 2,340 (of 2,567 total)