Questions tagged [sql-server-2017]
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
1,041 questions
7
votes
2
answers
16k
views
How do you directly modify the system catalogs in SQL Server 2017?
NOTE: I understand the risks involved, and the possibility of destroying a production system by doing this. I'm interested in doing it anyway.
Whenever I try to play with system catalogs, I gets ...
- 64.6k
2
votes
2
answers
9k
views
Where does SQL Server store the SA password and SQL Server password policy?
On Linux, where does SQL Server store the "SQL Server password policy" and the SA user's password? I get it, "password" isn't secure.
ERROR: Unable to set system administrator password: Password ...
- 64.6k
4
votes
2
answers
7k
views
How do I reset the SQL Server password on Linux?
The instructions on technet say that I either have to reset the SQL Server configuration with mssql-conf setup or run a proc which I can not run because I do not have access.
What the simplest way to ...
- 64.6k
0
votes
1
answer
814
views
SQL Server's `mssql-conf setup`, error Aborted sudo
When I run sudo /opt/mssql/bin/mssql-conf setup to configure SQL Server 2017 I get the following error,
/opt/mssql/lib/mssql-conf/invokesqlservr.sh: line 15: 12710 Aborted sudo -EH -u ...
- 64.6k
1
vote
0
answers
12k
views
Microsoft SQL Server 2017 remove all instances
I installed Microsoft SQL Server 2017 for like 4-5 with some failures. I can't manage to have a clean re-install. I think there are some residual files or configurations.
I tired uninstall & ...
- 143
0
votes
1
answer
248
views
AlwaysOn Geo Dispersed Automatic Failover
I'm looking to implement a "not quite" hub and spoke type architecture using AlwaysOn and wondered how the cluster quorum might play into this scenario if a remote site can't connect to the hub where ...
- 51
3
votes
2
answers
2k
views
Replication feature in SQL Server 2017 on Linux
We have a running production using SQL-Server 2014 in production. It has replication running and partial subscribers in several data centers.
I had a request to evaluate SQL Server 2017 on Linux so it ...
- 344
2
votes
0
answers
762
views
Can't install SQL SERVER 2017 on Centos 7.4 - mssql-conf setup error
I'm trying to install the lastest SQL Server 2017 on a Centos 7.4 VM (Vmware). I get the following error when I try running:
sudo /opt/mssql/bin/mssql-conf setup
using Bash shell. The error:
...
1
vote
1
answer
162
views
SQL Availability Group
I have a question in regards to SQL Standard availability groups. I currently have an AG setup with one primary and one secondary replica. I am using synchronous commit but was curious about ...
0
votes
2
answers
98
views
SQL 2017 Standard Availability Group
I am working on creating an AG on SQL Server 2017 Standard and Windows Server 2016. I have created the failover cluster using a file share witness and everything checks out OK with the cluster. The ...
5
votes
1
answer
6k
views
SQL Server 2017 Linux CU1 - MODIFY FILE encountered operating system error 31
I have a "VMWare RHEL 7.4" machine that I have installed "SQL Server 2017 Linux CU1" and I created a "Linux Linear Volume", see steps at the bottom, when I try to restore a database backup in the "...
172
votes
4
answers
179k
views
Help installing SQL Server 2017 - VS Shell installation has failed with exit code 1638
Any suggestions on how to deal with this error:
TITLE: Microsoft SQL Server 2017 Setup
------------------------------
The following error has occurred:
VS Shell installation has failed with exit ...
- 3,592
4
votes
1
answer
2k
views
Does SQL Server 2017 CU1 break clusterless availability groups?
Background:
My division is is doing an upgrade from SQL Server 2008R2 with mirroring to SQL Server 2017 with clusterless availability groups. Until recently the testing has surfaced no issues or red ...
- 433
0
votes
1
answer
38
views
Is there a way that we could backup the database in number of smaller parts or change the backup path?
Regards to this question that I had asked a day ago I want to know if there is any way that I could take the database backup in the number of smaller parts.
Or
If there is any way that I could ...
- 101
2
votes
0
answers
6k
views
SQL Server 2017 stand-alone stuck
My standalone install of SQL Server 2017 is stuck on the Feature Selection page. Below is what I see in the install logs, does anyone have any ideas how to get past this?
(08) 2017-10-24 11:15:20 ...
4
votes
1
answer
351
views
Removing sp_execute_external_script Start-Up Lag
On a freshly-restarted instance of SQL Server, the first time Python is executed using sp_execute_external_script, there's a lag before results are returned. After the initial Python script execution, ...
- 659
5
votes
1
answer
1k
views
SQL Server 2017 & External Python Modules
I'm doing some PoC work with Python integration in SQL Server 2017.
I have got the basic steps working, & have completed this example successfully:
https://learn.microsoft.com/en-us/sql/advanced-...
- 91
5
votes
1
answer
559
views
Is it possible to create encrypted backups using encrypted by password certificate?
I have encrypted by password certificate, which I want to use for backup encryption. The issue is I am not able to use the certificate (in T-SQL statement or maintenance plan) because I am not able to ...
- 4,318
1
vote
1
answer
378
views
Inserts via Entity Framework on server take about double the time than locally
I'm inserting lots of data into SQL Server with many of them having foreign key dependencies. Meaning if I insert 1 row in my Person table, I'm also inserting 1 row in 8 other related tables.
This ...
- 11
5
votes
1
answer
43
views
Lifespan of Launchpad-Launched Exterrnal Runtime Processes
When SQL Server uses SQL Launchpad to launch an external runtime (e.g. R or Python) when sp_execute_external_script is used, what's the lifespan of the external runtime process?
Does each ...
- 659
1
vote
2
answers
2k
views
Moving Databases between Instances of different Versions of SQL Server
I found out SQL Server Developer Edition is now free.
I would like to use my older databases from SQL Server Express 2016 to a new instance of SQL Server Developer 2017.
I want all the data objects:...
- 11
3
votes
1
answer
896
views
SQL Server 2017: How does Batch Mode Memory Grant Feedback Work?
Batch Mode Memory Grant Feedback is part of a family of features in the 2017 query processor that consists of:
Batch Mode Adaptive Joins
Interleaved Execution
Batch Mode Memory Grant Feedback
So ...
4
votes
1
answer
546
views
SQL Server 2017: How does Interleaved Execution work?
Interleaved Execution is part of a family of features in the 2017 query processor that consists of:
Batch Mode Adaptive Joins
Interleaved Execution
Batch Mode Memory Grant Feedback
So how does ...
5
votes
1
answer
2k
views
SQL Server 2017: How do Batch Mode Adaptive Joins work?
Batch Mode Adaptive Joins are part of a family of features in the 2017 query processor that consists of:
Batch Mode Adaptive Joins
Interleaved Execution
Batch Mode Memory Grant Feedback
So how do ...
39
votes
1
answer
6k
views
How do you create a view with SNAPSHOT_MATERIALIZATION in SQL Server 2017?
SQL Server 2017 has a couple new stored procedures:
sp_refresh_single_snapshot_view – input param for @view_name nvarchar(261), @rgCode int
sp_refresh_snapshot_views – input param for @rgCode int
...
- 43.2k
3
votes
2
answers
2k
views
Can I disable the spyware in SQL Server?
There are two titles for the spyware in SQL Server,
Customer Experience Improvement Program (CEIP)
Telemetry
I'm wondering how I disable them. You can see them referenced here,
My SQL Server says ...
- 64.6k
3
votes
1
answer
9k
views
Error Msg 10314, Level 16, State 11 with SAFE assembly after upgrade to SQL Server 2017
I have a pre-SQL Server 2017 database that I restored into / upgraded to SQL Server 2017. In this database I have a SQLCLR Assembly. The Assembly is marked as SAFE since it doesn't do anything ...
- 69.5k
5
votes
2
answers
232
views
How to definitively clear away database before restoring from new version of backup file
We are a team of mathematicians (i.e., no DBA experience).
We are migrating from an old server box (SQL Server 2012) to a new server box (SQL Server 2017). For each database on the old server, we ...
- 409
8
votes
1
answer
8k
views
I can't access any database diagram
My databases have been working fine on my Windows Server 2016 standard. The database management system is Microsoft SQL Server 2017 Express.
Today I added a new table and content, all is fine. I ...
- 255
14
votes
2
answers
11k
views
Will SSRS be extinct soon, and PowerBI the new model?
I read SQL Server 2017 will now include PowerBI Server. They also moved SSRS to a different installer, so it will not come packaged in the original SQL Server installation. Does this mean Microsoft ...
user129291
0
votes
2
answers
1k
views
Best option to index an application log table for quick insertion and retrieval in date order?
Suppose I have an application trace log table with three columns: (id uniqueidentifier, message nvarchar(max), and started datetime2).
The primary key (clustered) is on [id]. I need to be able to ...
- 615
0
votes
1
answer
4k
views
Create user with only SELECT and INSERT permissions
I'm working on a project that requires a database user to have only SELECT and INSERT permissions for all tables in a database.
The following question provides a solution but I'd have to run the ...
- 111
8
votes
3
answers
3k
views
What is causing this error: None of the specified replicas for availability group ag1 maps to the instance of SQL Server to which you are connected
I am configuring Always-on for SQL Server 2017 RC1 (14.0.80.90, dated 2017-7-18) for Linux as per https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-availability-group-configure-ha. This ...
Erik Brandsberg
29
votes
2
answers
130k
views
SQL Server returns "Arithmetic overflow error converting expression to data type int."
When I run this command with SUM()
SELECT COUNT(*) AS [Records], SUM(t.Amount) AS [Total]
FROM dbo.t1 AS t
WHERE t.Id > 0
AND t.Id < 101;
I'm getting,
Arithmetic overflow error ...
- 64.6k
11
votes
2
answers
46k
views
Getting "sqlcmd sqlcmd: command not found" in Linux?
Whenever I run sqlcmd I get "command not found"
sqlcmd -S localhost -U SA -P '<YourPassword>'
sqlcmd: command not found
How can I resolve that?
- 64.6k
1
vote
1
answer
1k
views
How do I bypass the typing of `GO` in `sqlcmd`?
sqlcmd has this most annoying this of having to type GO after every command, how can I get around this?
SELECT 1 AS "foo"
2> GO
foo
-----------
1
(1 rows affected)
Can I make ...
- 64.6k
6
votes
2
answers
4k
views
How do I get the Query Timing with sqlcmd?
Running SQL Server 2017, using the interactive REPL client sqlcmd how do I get the time for Query Execution?
You can sp_BlitzErik showing this in his answer here,
SQL Server Execution Times:
CPU ...
- 64.6k
14
votes
1
answer
18k
views
How do I totally remove SQL Server 2017 on Ubuntu?
The docs has instructions about how to remove SQL Server. However, this leaves certain packages behind. How can I remove all traces and uninstall SQL Server 2017?
- 64.6k
8
votes
2
answers
6k
views
Is there a developer edition of Microsoft SQL Server 2017 for Linux? [closed]
I have SQL Server 2016 Developer Edition installed on Ubuntu, whis is free for development purposes:
SQL Server 2016 SP1 Developer is a fully featured free edition licensed for use as a development ...
- 64.6k
1
vote
1
answer
2k
views
SQL Server on Linux: Case Sensitivity
I haven’t yet tried out SQL Server on Linux, but I have a question regarding case sensitivity.
In MySQL and Oracle (as far as I am aware) table names and database names are case insensitive on Mac &...
- 2,919
13
votes
2
answers
24k
views
Unable to start SQL Server on Ubuntu 16.04
I had SQL Server v.Next public preview on my Ubuntu 16.04 machine installed and working yesterday. But it's not working today.
Getting below error:
root@OraServer:/var/opt/mssql/log# systemctl ...
- 417