Skip to main content

All Questions

Filter by
Sorted by
Tagged with
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 ...
Andrea Jared's user avatar
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 ...
arnoldbird's user avatar
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 ...
Newbie-DBA's user avatar
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 ...
SqlWorldWide's user avatar
  • 13.6k
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 ...
franklwambo19's user avatar
-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 ...
variable's user avatar
  • 3,499
-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 ...
ahmed elbarbary's user avatar
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 ...
ahmed elbarbary's user avatar
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 ...
Lockszmith's user avatar
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 ...
SvendK's user avatar
  • 101
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....
serge's user avatar
  • 451
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 ...
yfr24493AzzrggAcom's user avatar
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/...
Brian M.'s user avatar
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 ...
user2815760's user avatar
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 ...
buddinggeek's user avatar
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 ...
Arno's user avatar
  • 3
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 ...
Asher's user avatar
  • 303
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....
Martin Guth's user avatar
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 ...
Amirhossein's user avatar
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 ...
Tracker1's user avatar
  • 201
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 ...
tns2307's user avatar