SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
SQL Server 2017 is the first version of SQL Server that runs on Linux.
Questions tagged [sql-server-2017]
1044 questions
172
votes
4 answers
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 code 1638.
For help, click:…
Jonathan Allen
- 3,612
- 7
- 25
- 25
43
votes
2 answers
Why does changing the declared join column order introduce a sort?
I have two tables with identically named, typed, and indexed key columns. One of the them has a unique clustered index, the other one has a non-unique.
The test setup
Setup script, including some realistic statistics:
DROP TABLE IF EXISTS…
Daniel Hutmacher
- 9,173
- 1
- 27
- 52
39
votes
1 answer
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
And new entries in sys.messages:
10149 – Index…
Brent Ozar
- 43,325
- 51
- 233
- 390
31
votes
1 answer
Self referencing scalar function nesting level exceeded when adding a select
Purpose
When trying to create a test example of a self referencing function, one version fails while another one succeeds.
The only difference being an added SELECT to the function body resulting in a different execution plan for both.
The function…
Randi Vertongen
- 16,593
- 4
- 36
- 64
29
votes
2 answers
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 converting expression to data type int.
Any idea on what is…
Evan Carroll
- 65,432
- 50
- 254
- 507
28
votes
6 answers
Changing the use of GETDATE() in the entire database
I need to migrate an on-premises SQL Server 2017 database to an Azure SQL database, and I'm facing some challenges since there's quite a bit of limitations to go through.
In particular, since an Azure SQL database works only in UTC time (no time…
Lamak
- 2,576
- 1
- 24
- 30
25
votes
3 answers
Why would a table with a Clustered Columnstore Index have many open rowgroups?
I was experiencing some performance issues with a query yesterday and upon further investigation, I noticed what I believe is odd behavior with a clustered columnstore index that I'm trying to get to the bottom of.
The table is
CREATE TABLE…
Taryn
- 9,746
- 4
- 48
- 74
25
votes
1 answer
SQL Server 2017 crashes when backing up because filepath is wrong
I was trying to restore my database and SQL Server kept crashing. I would get a message in SSMS that said there was a network transport error (the connection dropped bc the crash). I checked the logs and found nothing more than SQL Server closed…
Rick
- 415
- 1
- 4
- 7
24
votes
4 answers
If a database only ever has one insert, is it bad to index every possible column combination?
I am working on a reporting system that will require large select queries, but is based on a database that is only filled once. The database management system is Microsoft SQL Server 2017. There is probably a better way to design a system like this,…
Lopsided
- 365
- 2
- 7
22
votes
4 answers
SQL Server has encountered occurences of I/O requests taking longer than 15 seconds
On Production SQL Server, we have following config:
3 Dell PowerEdge R630 servers, combined into Availability Group
All 3 are connected to a single Dell SAN storage unit which is a RAID array
From time to time, on PRIMARY we are seeing messages…
Aleksey Vitsko
- 6,148
- 5
- 39
- 70
22
votes
3 answers
SQL Server Distributed Availability Group databases not syncing after a server reboot
We're getting ready to perform a large upgrade on our SQL Servers and are noticing some unusual behavior with Distributed Availability Groups that I'm trying to resolve before moving forward.
Last month, I upgraded a remote secondary server from…
Taryn
- 9,746
- 4
- 48
- 74
19
votes
2 answers
Which collation should I use for biblical Hebrew?
Which SQL Server collation should I use for biblical Hebrew? The database under consideration needs to accommodate diacritics (i.e., vowels, accents, trope, etc.).
brian12345
- 191
- 1
- 4
18
votes
1 answer
Messages about parallel redo
Parallel redo is shutdown for database '' with worker pool size [2].
Parallel redo is started for database '' with worker pool size [2].
Starting up database ''
I see this on a client PC a lot in the Windows Event Viewer (Event Id 49930 or…
juFo
- 309
- 1
- 3
- 8
17
votes
1 answer
Error starting SQL Server 2017 service. Error Code 3417
I have SQL Server 2017 installed on my computer. This is what SELECT @@VERSION returns:
Microsoft SQL Server 2017 (RTM-GDR) (KB4293803) - 14.0.2002.14 (X64) Jul 21 2018 07:47:45 Copyright (C) 2017 Microsoft Corporation Enterprise Edition…
Beginner
- 273
- 1
- 3
- 7
16
votes
5 answers
Attempts to reclaim unused space causes the used space to increase significantly in SQL Server
I have a table in a production database that has a size of 525 GB, of which 383 GB is unused:
I'd like to reclaim some of this space, but, before messing with the production DB, I'm testing some strategies on an identical table in a test DB with…
Ken
- 193
- 1
- 6