Questions tagged [sql-server-core]

SQL Server Core is a subset of the SQL Server binaries designed to be used on Windows Server Core. Window Server Core provides a minimal environment with limited attack surface.

Filter by
Sorted by
Tagged with
0
votes
1answer
24 views

SQL Server license from AWS Marketplace with ? cores

We are planning to buy a SQL Server 2012 Enterprise edition license from AWS Marketplace for our company. We have exhausted our previous licenses and we need to add a new region with SQL Server in ...
2
votes
1answer
141 views

CPU usage among Numa nodes in sql server

I need to understand the below scenario On Sql server 2014 with compatibility mode of 2008R2, having 80 logical processors with 20 distributed amongst 4 numa nodes. I. E numa node 1 has 0-19 , numa ...
0
votes
0answers
53 views

Does splitting 1 tempdb file into 4 require a SQL Server restart? [duplicate]

please can anyone help? I have a SQL 2008R2 instance with 4 cores, configured with 1 tempdb data file and 1 logfile. I want to change this setup as per best practices by adding 3 additional euqally ...
2
votes
1answer
52 views

Log Shipping with Failover Cluster Server Cores

Failover Over Cluster 2 Node - 6 Cores- Enterprise Edition 2014 Log Shipping with Cluster with 4 Core License- Enterprise Edition 2014 My question is if I need to log ship do I need to match the ...
1
vote
2answers
1k views

Adding Full Text Search via command line

I'm trying to add the full-text search to sql server via command line since we got a core-server. I already searched the web but all I get is adding it with GUI or re-installing the complete SQL-...
1
vote
2answers
157 views

Service Packs and CUs for SQL Server, do these patches make any changes to user database files? or just instance level binaries?

I am curious about patching on SQL Server. Does anyone know if SPs and CUs make any changes to user database files or is it just the database engine and instance level binaries that get modified/...
1
vote
1answer
1k views

Multi-thread Informatica connections to use different processors on target database server

See this question for reference. Can data streams from Informatica to SQL Server be multi-threaded? I've got most of my problem figured out. I've split up the one large table into four smaller ...
1
vote
1answer
2k views

Failed installation of SQL 2012 on Windows Server Core

I'm in the process of building the lab for 70-462 exam. On page 49 of the text, it provides the command to install SQL 2012 on Windows Server Core: Setup.exe /qs /Action=install /Features=SQLEngine,...
3
votes
1answer
4k views

How to obtain SQL feature list from the command line

Is there a command at the CLI or in PowerShell that will list the components installed for SQL? I'm looking for something like the Feature List you can get from running the discovery report from ...
1
vote
2answers
1k views

SQL Server Core - Installed SQL Server features

When using a traditional installation of SQL Server one has the Installed SQL Server features discovery report. Googled and found no info if some equivalent was available for the core installation. ...