Questions tagged [sql-server-2017]
SQL Server 2017 (major build version 14.00.xxxx). Please also tag sql-server.
765
questions
1
vote
1answer
34 views
Does SQL Server Support Parallel Bulk Inserts From Multiple Connections?
Does SQL Server support parallel bulk inserts into the same database table?
Some clarifications for my particular use case:
The table has a clustered index composed of two distinct index keys, and ...
0
votes
0answers
26 views
A simple question about TDE
I have a question regarding TDE on SQL Server 2017 for example.
I created the master key
Created the certificate
Created the database encryption key ( now the database is encrypted)
Backed up the ...
0
votes
1answer
28 views
How can I figure out what the minimum MaxMem value could be without causing issues. MSSQL 2017 Enterprise CU18
I am running several 2017 CU18 instances in failover clusters with "standby" instances for planned growth. I want to configure those standby instances with the least amount of RAM (lowest ...
0
votes
1answer
31 views
SQL Server Extended Events to Capture Objects access by a User [duplicate]
I am in for a requirement where I need to use EE to capture the Objects Accessed by a particular SQL User.
I want to avoid the action sqlserver.sql_text, if I use this, I will need to manually scan ...
0
votes
2answers
34 views
Two backup programs, diff and log out of sync
I am running encrypted backup on SQL Server 2017.
Doing a test restore, it failed:
RESTORE DATABASE [test]
FROM DISK = N'\\DPH-DD-SLI-001\SLI_SQL_Backups\Encrypted\DPH-SQL-SLI-12P\BTBLEAD\FULL\DPH-...
-4
votes
0answers
41 views
MS SQL Server multiple threads updating same table [closed]
So this is the scenario. In my app I have a queue of the requests that should be written to a single table in db. Each request is a update request, but along each update request I do selects.
So ...
2
votes
1answer
34 views
log send queue size and redo queue size in AG
I am trying to figure out the way to monitor these 2 events
log send queue size - I can see this in perfmon
Redo queue size - I can see in dmv but not in perfmon counter
Is there any way of using ...
2
votes
1answer
75 views
Basic alternative to fn_LocalTimeToUTC
My cloud provider has prevented me accessing fn_LocalTimeToUTC and fn_UTCToLocalTime.
How would I go about getting the same functionality that these two functions offer manually and directly in SQL ...
0
votes
0answers
81 views
Yet another SQL Server calendar table question
After the wonderful help I received on my original question, we have discovered that our current method of calculating our fiscal calendar is wrong.
Fiscal calendar rules:
fiscal year starts 2 ...
0
votes
1answer
28 views
Building a custom SQL Server 2017/2019 container on a windows server without internet
I am in bit of a predicament,and would appreciate any help to move forward from my current situation
I have been given a VM running on Windows Server 2016 with Docker Enterprise installed. My ...
0
votes
1answer
30 views
Only a sysadmin can specify '@output_file_name'
I have developed an async batch system using the Agent Jobs in SQL Server 2017. It is working really well. I have one issue with setting up the operations staff to run this. We get the following error
...
0
votes
0answers
34 views
After a reboot and latest CU for sqlserver 2017 I get this annoying message
After a reboot and latest CU for sqlserver 2017 I get this annoying message (the xxxxx was a number)
SSBDT: Dialog timer delete during registration (did:
xxxxxxxxxxxxxxxxxxxxxxxxxxxx:Initiator, ...
0
votes
1answer
48 views
migrating to a bigger server - how to copy over differences
We have a very large database, one table (logs) contains the majority of the data (around 13 billion rows) total database size is approx 6.5TB and I have 900gb of space remaining before server is full....
4
votes
2answers
412 views
Multiple volumes vs single volumes for SQL Server CHECKDB performance
We have a ~10TB database with dozens of data files on SQL Server 2017 Enterprise CU21. We're seeing slower CHECKDB performance when all of the files are on a single volume as opposed to multiple ...
0
votes
1answer
22 views
Transactional replication upgrade from SQL Server 2017
We would like to inplace upgrade of transactional replication topology from SQL Server 2017 to SQL2019 with minimal downtime. The following is the setup. All the all current instances are on SQL ...
2
votes
0answers
40 views
Problems with Distributed Availability Group( DAG)
I have 2 servers in AWS Central joined with AWSCentralAG and I have 2 servers in AWS West joined with AWSWestAG. Obviously, I have the listener name and listener IP address and I able to connect to ...
0
votes
1answer
17 views
Getting VLF info with least privileged to run across multiple servers of different version
Per our monitoring scripts i am thinking to add monitor the status of VLF for each database across different SQL servers in our organization:
We have mix of servers from 2012 to 2019: I've found a ...
0
votes
0answers
11 views
Can Reporting Services be installed on a clean remote server, then create new SSRS databases on existing SQL Instance with SSRS installed?
Can Reporting Services be installed on a clean remote server, then create new SSRS databases on existing SQL Instance with SSRS installed?
Have a SQL Instance with Reporting Services working - Lets ...
0
votes
0answers
32 views
How to write a complex logic in SQL that should work two main cases (unfiltered and filtered by one dimension)?
This question is slightly related to this one.
I am dealing with a legacy business logic that computes several DocumentXUser security tables. This logic is very complex (a single query with lots of ...
0
votes
2answers
33 views
SQL Server logshipping: Extend the LS_Alert window
We have a logshipping setup, where the LS_Restore job on the secondary database is switched off every night for the datawarehouse to grab its data. The restore cycle is set to 15 minutes and if ...
6
votes
1answer
506 views
How to avoid Table Lock Escalation?
I've got a task to update 5 million rows in a production table, without locking down the whole table for extended time
So, I used approach that helped me before many times - updating top (N) rows at a ...
1
vote
1answer
27 views
SQL Server Agent Alerts and Severity Errors
I've setup alerts in SQL Agent for errors of severity level 15-16 for testing, and found out that these are not always triggered
To be more exact, these seem to trigger only when given error number ...
0
votes
3answers
141 views
How to efficiently recompute the data in a rather large X table?
I have recently noticed performance issues for the main application I am developing right now (it is a legacy one). A job triggers a stored procedure that computes the security for all the documents ...
0
votes
0answers
12 views
SQL Server HA Design (FCI) - Windows Storage Replication - Test-SRTopology - Physical Memory Error - AWS EC2
I'm trying to set up AlwaysOn Failover Cluster Instance (Not Availability Groups) on 2 VMs(each on different AWS Availability Zone) in AWS-EC2 instances.
To make this happen, I've to set up Windows ...
0
votes
1answer
53 views
Any issue encountered after implementing SQL Server 2017 CU22? [closed]
We all are aware of SQL Server 2019 CU7 issue (Microsoft recalled the patch). Now I am cautiously optimistic to apply SQL Server 2017 CU22. I wanted to reach out to the SQL Server Community to know if ...
1
vote
0answers
15 views
CREATE or ALTER when using replication
I am using CREATE OR ALTER in the scripts for all of my views and stored procedures, as they are pushed frequently from a CD pipeline. I am also using replication to push certain tables, views, and ...
0
votes
1answer
18 views
Reaching a Microsoft SQL Server 2017 cluster from an other device
Let say I have a python service in one instance. This service needs to reach a MSSQL cluster of 5 nodes that is in an other location, with different IP addresses. Cluster creds:
user: my_user
password:...
0
votes
0answers
10 views
Deploying schema changes to AWS RDS hosted Databases
With a database hosted in AWS's RDS, the database is only accessible externally if publicly accessible is set to true and the relevant ingress rules are configured to allow connection from a known ...
2
votes
1answer
73 views
VARCHAR missing index not showing up in missing index dmv or query plan suggestions
I have a table with 307200 records, with f_column being VARCHAR(30). No missing index are shown in the missing indexes dmv or suggested in the execution plan.
SELECT f_column, f_column2 FROM t_table ...
0
votes
2answers
32 views
User cannot query cross-database, despite having permissions for both databases
SQL Server 2017 Enterprise (14.0.3356.20), running on Windows Server 2016.
I have a situation where an application's user needs to join on a table in a separate database in the same instance, but I'm ...
0
votes
1answer
19 views
replace user defined functions (UDF) and tabled value functions(TVF)
Are there techniques to replace
UDF
tabled value functions
with something else?
or techniques to make them acceptable? (fast, multithreading and with good estimations)
1
vote
1answer
81 views
Eliminate filter operator before columnstore index scan operator
I have a large fact table with millions of rows called MyLargeFactTable,
and its a clustered column store table.
There is a composite primary key constraint on it there as well
(customer_id,...
0
votes
1answer
19 views
SQL Server 2017 MLS - cant add python package
I'm new-ish to MLS and have been trying to add new python packages like attrs to the python but it hasn't been working.
Our set up is SQL Server 2017 with CU14 on Win 2016.
Python version is 3.5.2
...
1
vote
2answers
82 views
SQL Database size incorrect and database file growing while empty
RESOLVED - SOLUTION AT BOTTOM OF POST
PROBLEM
I have a database data file showing as 200GB on disk, and 200GB allocated space in the database properties. sp_spaceused also shows 200GB allocated. All ...
0
votes
0answers
9 views
db_datawriter and db_ddladmin on a server-level? [duplicate]
Ok, since SQL Server 2016 we have new server-level permissions that allow to grant connect and select to/on any exising or future databases on the server instance
use master
grant connect any ...
0
votes
1answer
17 views
SQL Server 2017 installation unauthorized error
I'm getting the below errors while installing SQL Server on a Windows machine.
I'm using my admin account which has permissions (I’m in Administrations group. Verified here -> Computer management -&...
0
votes
0answers
21 views
An unexpected error occurred in function 'XMTMStorageFileHelper::CreateOrModifyStorageFile' when processing SSAS tabular model
I'm trying to process partitioned table in SSAS tabular model and I got following error multiple times:
An unexpected error occurred (file 'xmutiltm.cpp', line 444, function 'XMTMStorageFileHelper::...
3
votes
2answers
210 views
SQL Errorlog Constant FlushCache Messages
A server that is part of a SQL 2017 Always on availability group (BAG) I have noticed an increase of these messages. I understand these are messages that appear in the log as standard since 2012 (...
1
vote
1answer
31 views
SQL Server Application paths to include in server backup?
I have an instance of SQL Server 2017 Standard installed on a physical server running Windows Server 2019. I'm currently working with our server administrator to configure the server backup, which he ...
2
votes
0answers
36 views
Problem with decimal point setting in Windows
I am using bcp.exe from a SQL Server 2017 installation on Windows 10 (build 19041). The OS language is English (US) but I use scandinavian settings for date, time, currency and decimal delimiter - the ...
0
votes
2answers
30 views
Service Broker “Broker Enabled” option goes from true to false when performing backup/restore of DB
We have two production servers joined by an AAG, and for a specific database, the Service Broker is enabled (Options -> Service Broker -> Broker Enabled : true. We use this for SignalR.
However, ...
0
votes
0answers
41 views
Installing CU21 on SQL Server 2017 Enterprise
Please give me advise if you have any, related to my case. Problem appears on stage of CU21 installation. Update process stops services, installing updates, but after installation completes and ...
2
votes
1answer
45 views
What can cause delay in SELECT statement execution and high ASYNC_NETWORK_IO even with “disregard results after execution”
We are facing performance problems on our SQL Servers.
7 servers, all running the same application, all have the same problem.
SELECT @@VERSION
Microsoft SQL Server 2017 (RTM-CU19) (KB4535007) - 14.0....
0
votes
1answer
25 views
Handling Reporting Services and SharePoint Integration considering deprecation
With one of our clients, we're currently faced with a dilemma. SQL Server Reporting Services Report Server (SharePoint mode) seems to have been deprecated, since the last version to support it is SQL ...
0
votes
0answers
9 views
VDI OpenDevice fails Mostly observed in SQL Server 2017 U19 and above on Linux
What are the changes Microsoft has made changes to SQL Server 2017 CU19 (February 2020) that is preventing the Plug-in for SQL Server (third-party )to protect SQL Server 2017 CU19?
Environment :
The ...
0
votes
0answers
43 views
Logon Trigger unable to send Email
I have a logon trigger that is designed to block certain logins (like 'Login%', or = 'Login1', etc.), if they come from:
certain IP
certain hosts
SSMS
Example code can be found here:
https://paste....
0
votes
0answers
17 views
Is it possible to Auto Archive Old Data into ReadOnly partitions on a large table with existing PS/PF and auto drop old read only partitions
Is it possible to Auto Archive Old Data into Read Only partitions on a very large table with existing PS/PF but then also allow continued automatic pruning/dropping of those read only partitions i.e. ...
0
votes
0answers
33 views
Adding Python package to Sql Server 2017 machine learning services breaks it
I am trying to get started running python inside of Sql Server 2017 with Python Machine Learning Services.
Out of the box it works and I can run simple scripts like listing the installed packages:
...
1
vote
1answer
172 views
Should simultaneous bulk inserts cause deadlocks, with a PK being an identity column, in SQL Server?
When analyzing a deadlock graph, it looks like the victim is a bulk insert, and the blockers are the same bulk insert. Using a message bus, many subscribers can end up doing a bulk insert at roughly ...
0
votes
1answer
25 views
Storage accounts not showing up when creating Azure Storage Credential
I'm trying to setup a Back Up Database Task in a Maintenance Plan on SQL Server 2017 (Web Edition) using SSMS 18.6 and when I get to the step to create an Azure credential I select my management ...
