All Questions
Tagged with sql-server-2017 sql-server-2019
21 questions
0
votes
0
answers
91
views
SQL Server 2016 upgrade
We need to upgrade our SQL Server 2016 to SQL Server 2019. We are also using replication for our test and production environments.
What my question is: what are the downfalls of upgrading from SQL ...
0
votes
2
answers
94
views
Do I need the MDF and LDF files when I run a script to generate my schema? [closed]
I'm migrating a database from SQL Server 2019 to SQL Server 2017. To do so, I am using the "Generate scripts" feature in the source database to generate the schema and data separately. (I ...
0
votes
1
answer
99
views
Impact of timezone change during sql server migration
We are migrating from our legacy SQL Server 2017 on Windows 2016 host to SQL Server 2019 on Windows 2019. In above migration the bigger change has been the difference in timezone between legacy and ...
1
vote
1
answer
169
views
Which Intelligent query processing features are available in the Enterprise Edition only?
Many features have been released starting from SQL Server 2017 to SQL Server 2022 as part of the 'Intelligent query processing' family. Which ones are Enterprise only, and which are available in the ...
0
votes
0
answers
49
views
Backward compatibility for filestream databases
I have a database on a filestream enabled instance and with file system tables on SQL Server 2019. I am able to generate scripts for schema and data permitting restore on earlier SQL Server versions ...
-1
votes
2
answers
235
views
Whether SQL standard edition has NUMA support?
Link: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016?view=sql-server-2017#RDBMSSP
For NUMA Aware Large Page Memory and Buffer Array Allocation the table ...
-2
votes
1
answer
819
views
when update large table it take too much time to update
I work on sql server 2019
when update table Z2DataCore.parts.SourcingNotMappedParts i found slow and long time when update
estimated execution plan
actual execution plan
Update statement takes 26.5 ...
2
votes
2
answers
51
views
when make select to top 5 of rows from table it take too much time?
I work on sql server 2019 i face issue when make select top 5 rows it take too much time .
Number of Rows on Table Z2DataCore.parts.SourcingNotMappedParts 70 milion rows .
when run statment select ...
0
votes
2
answers
1k
views
AlwaysOn Availablity Groups and database count limits
Update:
Basic answer: I asked for something that isn't part of the design of AOAG.
Which in my eyes makes this a 'not a good question to ask'.
Unless this offends someone, I'll keep it here in the odd ...
0
votes
0
answers
159
views
SSMS: Dragging vertical tab group divider and nothing happens
I've searched Google for "ssms vertical drag divider nothing happens" but can't find anything. Am I the only one experiencing this?
I'm using both SSMS 17 and 18, as some servers I work with ...
15
votes
1
answer
22k
views
Clone a database from SQL Server 2019 to 2017 [duplicate]
I try to clone a database from an Sql Server on my local machine v15 (2019) to a server machine v14(2017). I did a .bak file and when I tried to import on the server side it says:
System.Data....
1
vote
3
answers
7k
views
Backup sqlserver 2019 and restore to Sqlserver 2017
I have only 1 table in SqlServer 2019 that I want to backup and restore into SqlServer 2017 in different server.
To SqlServer 2019 I have access to server and with SSMS but to SqlServer2017 I have ...
3
votes
1
answer
2k
views
How to collapse rows with individual, contiguous dates into single rows with date range start and end
Given a data set like this:
Id
Date
Value
1
01/01/2021
100
1
01/02/2021
100
1
01/03/2021
100
...
... (rows omitted for brevity)
...
1
12/29/2021
100
1
12/30/2021
100
1
12/31/2021
100
2
01/01/...
0
votes
1
answer
321
views
Transactional Replication between SQL Server 2017(Publisher+Distributor) and SQL Server 2019(Subscriber) [closed]
So here's the replication scenario that we need to set up.
At organization A, We have SQL Server 2017 which is both the publisher and a distributor.
At organization B, on a remote server, we have a ...
0
votes
1
answer
536
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
2
answers
3k
views
SQL Server 2016 -> 2019 AlwaysOn Rolling Upgrade Migration
I have a migration concept with an AlwaysOn configuration from SQL Server 2016 (on windows server 2016) to SQL Server 2019 (on Windows Server 2019) which are in different sub-networks.
So with ...
0
votes
2
answers
460
views
Default trace vs auditing in SQL Server
Currently I am working in an environment that has the default trace enabled and I would like to propose that we add SQL server auditing to our environment.
I'm looking for some points to put forward ...
0
votes
1
answer
214
views
SQL Server:Piecemeal Restore on Standard Edition 2017/2019?
I am currently fiddling with piecemeal restore.
I have some demo code from Jes Borland from her great presentation "Minimize Data Loss with Advanced Restore Methods" (take a look at https://www....
3
votes
1
answer
1k
views
Turn off Error AND Usage Reporting SQL Server
Unfortunately, SQL Server usage internet bandwidth and us activity in SQL, for R&D. You can find in your server, this service is called: SQL Server error and usage.
This service is active without ...
3
votes
1
answer
6k
views
Limit TLS and Cipher Suites on SQL Server 2016-2019
I'm wanting to configure some SQL 2016+ servers to use only TLS 1.2+ and a subset of Cipher suite options (no ciphers considered weak or compromized). I'm having trouble tracking down how to ...
0
votes
0
answers
1k
views
Microsoft SSMS 2018 cannot open (only the splash screen)
yes, i've read this SQL Server Management Studio 18 won't open (only splash screen pops up) , it work the first time. after i restart my computer, and try to open smss again, the problem happen ...