Viewing 15 posts - 2,491 through 2,505 (of 2,663 total)
128GB is max that SQL Server instance will use for its buffer pool - and this is per instance.
but as there are other things that can use the...
May 11, 2017 at 12:52 pm
Lets assume the following example
Standard process would be
- dataflow -
Input file to Final table
Approach I am suggesting is
-...
May 9, 2017 at 4:14 pm
May 9, 2017 at 2:53 pm
What is the Oracle client you are installing? link to Oracle download if you can.
And where have you seen that the 32 bit driver will only be released...
May 9, 2017 at 1:22 am
I use the following to get my dependencies.
Only works with objects within the same database - so if there are references to external databases it won't find dependencies...
May 7, 2017 at 5:33 pm
May 6, 2017 at 1:56 am
SSMS version has nothing to do with the Instance version - they are 2 independent products.
you could easily be using SSMS 2017 with a 2008 R2 database
So...
May 6, 2017 at 1:06 am
from the licensing terms at https://docs.microsoft.com/en-us/sql/ssdt/sql-server-data-tools-license-terms
Installation and Use.
You may install and use any number of copies of the software on your devices to design,...
April 24, 2017 at 4:46 am
April 21, 2017 at 3:27 pm
Setting compatibility mode is a database level permission (alter database) if not mistaken.
create user is securityadmin or alter any login (no need for sysadmin)
CLR is...
April 21, 2017 at 12:26 pm
only differences between Developer and Enterprise is that the enterprise version may be limited by the number of cores it uses.
If for some reason the Enterprise version used is...
April 21, 2017 at 12:07 pm
April 19, 2017 at 10:57 am
On the particular sample of data you supplied it seems that everything field is within double quotes without exception.
That being the case would it not be an easy...
April 19, 2017 at 10:34 am
try changing the header delimiter to LF - there is a discrepancy between the header and row delimiters.
And what I have found before is that where there is...
April 11, 2017 at 5:34 am
I would say it may require one of the following
sysadmin - but should not be granted
dbowner - should be avoided
view definition (database level) or view any...
April 8, 2017 at 9:45 am
Viewing 15 posts - 2,491 through 2,505 (of 2,663 total)