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]
928 questions
169
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,492
- 6
- 21
- 24
42
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
- 8,810
- 1
- 19
- 51
37
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
- 41,112
- 30
- 166
- 313
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
- 15,913
- 4
- 31
- 58
27
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,556
- 1
- 22
- 29
27
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…
NO WAR WITH RUSSIA
- 54,954
- 34
- 200
- 411
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
- 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
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,466
- 3
- 41
- 74
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,466
- 3
- 41
- 74
20
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
- 4,308
- 3
- 21
- 47
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
- 4
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
- 3
- 7
15
votes
1 answer
Cardinality estimate outside the histogram
Setup
I'm having some trouble understanding a cardinality estimate. Here's my test setup:
the 2010 version of the Stack Overflow database
SQL Server 2017 CU15+GDR (KB4505225) - 14.0.3192.2
the new CE (compatibility level 140)
I have this…
Josh Darnell
- 26,899
- 5
- 60
- 110
15
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
- 183
- 6