Questions tagged [sql-server-2017]
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
1,012
questions
13
votes
2
answers
10k
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
3k
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
2k
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
122k
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 ...
- 62.2k
10
votes
2
answers
36k
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?
- 62.2k
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 ...
- 62.2k
5
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 ...
- 62.2k
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?
- 62.2k
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 ...
- 62.2k
1
vote
1
answer
1k
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,779
13
votes
2
answers
23k
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