Questions tagged [sql-server-2019]

SQL Server 2019 (major build version 15.00.xxxx). Please also tag sql-server.

Filter by
Sorted by
Tagged with
2
votes
1answer
29 views

How to control Segmentation min/max data_id on a non-clustered ColumnStore index

Given a simple row-based table without a PK but with a row-based clustered index like so: create clustered index [CX_PropertyValue] ON [dbo].[PropertyValue] ([PropertyId], [Value]) Then I wish to ...
0
votes
0answers
25 views

HA AlwaysOn and SMB File Share

I am planning on taking our current single 2014 SQL server and rebuilding it to a 2019 SQL Server HA AlwaysOn Cluster. The issue is, the listener IP and hostname has to stay the same and many years ...
0
votes
0answers
8 views

Windows Server 2019 non-owner node cannot see Cluster Name or IP

I am trying to build a SQL Server AlwaysOn Availability Group with 2 nodes in Azure. I have created 2 SQL Server VMs and Managed to create a Cluster with both Nodes as members of that cluster.  I ...
0
votes
1answer
24 views

SQL Server 2019 Always On using Distributed Network Name

We're running a couple SQL servers in Azure that are set up with an Always On availability group and Windows Failover Clustering. The servers are Windows 2019 and we're running SQL Server 2019. When ...
1
vote
0answers
20 views

mssql suddenly cannot access physical file

SQL server 2019 on Centos 7 x86_64. It was running fine for quite long time, then got broken. I was not doing anything special, neither update or restart or whatever. At some point the database went ...
0
votes
1answer
18 views

Getting the exact and closest Search using CONTAINS/CONTAINSTABLE in SQL

I have a table that contains 30 000+ records named as ProductCodes that contains a column 'Value'. I have made a query that'll return the records matching and containing a passed String using ...
2
votes
2answers
76 views

SQL Server 2019 performance worse than 2012… am I missing something?

We have a SQL Server 2012 server which far outperforms a SQL Server 2019 database on (as far as I can see) the same infrastructure. We are hosting both databases on a cloud platform with the same SLAs....
2
votes
2answers
51 views

dbcc checkdb runs for interminably long time, 50% of the time

I've got a nightly maintenance job (largely taken from the ola hallengren maintenance package) that runs database backups and runs an an integrity check on every database. The integrity check part ...
0
votes
0answers
22 views

Which system catalog view has the create_date of a database which name was modified?

In the Stack Exchange Data Explorer each Sunday all databases are dropped and recreated one by one with this stored procedure. For each database the script starts with (paraphrased) for example Dba....
0
votes
1answer
20 views

Cost of indexed view versus filtered index?

I have met the following table design for recording references in non-normalized way: RecordGUID uniqueidentifier DestinationEntity uniqueidentifier DestinationRecordGUID ...
0
votes
0answers
17 views

SQL Polybase - Connect to MySQL ODBC - Issue with decimal data type

hope someone has a clue about this... I'm using SQL 2019 Polybase to connect to a MySQL 8 Server using an ODBC (MySQL 8.0.20 ODBC Driver). CREATE EXTERNAL DATA SOURCE eds_test1 WITH ( LOCATION = '...
1
vote
0answers
53 views

Why are column store indexes disabled automatically when a database is restored?

I have recently done a server migration where we backed up and restored all the databases from a SQL Server 2012 version to SQL Server 2019. However the restored databases appear to all have their ...
2
votes
1answer
23 views

Cannot find DReplay.exe for SQL Server 2019

I have been working on SQL Server 2019 version and trying to setup a load test environment using SQL Server Distributed Reply Controller - Client, however I cannot find the DReplay.exe. I thought the ...
1
vote
1answer
65 views

SQL2019 CU4 PWAIT_EXTENSIBILITY_CLEANUP_TASK

I'm running SQL2019 CU4 Linux and seeing a high number of PWAIT_EXTENSIBILITY_CLEANUP_TASK. Can anyone share their insight on what this wait type means and how we can reduce it? Select * from sys....
0
votes
1answer
27 views

views restored from backup in a different server referring to linked servers

I have 3 SQL servers X, Y, Z and 2 databases X.A and Y.B. There are (many) view in X.A that uses 4-level naming in their definition: SELECT ... FROM Y.B.SCHEMA.TABLE From this I infer that X ...
3
votes
2answers
84 views

Restoring MDF without LDF file

I am trying to attach a database just from the MDF file, cause the server crashed and could never find the LDF. I am on a 2019 MS SQL Server. I am following the instructions from this page. I have ...
4
votes
1answer
89 views

Heap table insert

I am trying to understand the behaviour of SQL Server when it INSERT record into a Heap table. According to about sql Server blog post, paragraph 2 "SQL Server would not put a new row to the page if ...
3
votes
1answer
52 views

Clustered index data access

I am trying to understand how SQL Server access data from the clustered index. My understanding is when the table has a clustered index SQL should be able to seek into the single page that holds the ...
34
votes
1answer
2k views

SQL Server 2019 executes unreachable code

Consider the following repro example (fiddle): CREATE FUNCTION dbo.Repro (@myYear int) RETURNS datetime AS BEGIN IF @myYear <> 1990 BEGIN RETURN NULL END DECLARE @...
0
votes
2answers
45 views

In SQL Server Always On 2019 environment should SSRS/SSIS be on a separate server?

I am looking for some advice in setting up a new SQL Server 2019 Always On instance. We have a 2 server cluster right now, moving to Always On with a similar two virtual server setup. I want to ...
1
vote
0answers
49 views

Keep 2 instances of SQL Server synced [closed]

We want to set up a second instance/server of SQL Server such that both instances will be kept in sync. The reason is we need to separate some users and processes out to a separate server for business ...
1
vote
1answer
43 views

Reducing table size during initial load with ADR in SQL Server

When a table is created, and loaded with data from scratch based on a file, the table size changes significantly when Accelerated Database Recovery is on in SQL Server (realized based on my question ...
1
vote
1answer
48 views

Table size in Azure SQL Managed Instance vs On Premise SQL Server

In doing a test, I have observed that the size of the same table with the same exact DDL (created from scratch) with the same exact data (10M rows) varies drastically in our Azure SQL Managed Instance ...
2
votes
3answers
133 views

Why can't SQL Server find a seek plan? Is this a bug?

create table Test1 (Id int not null, H char, primary key (Id), index i1 unique (H)) create table Test2 (Id int not null, H char, primary key (Id), index i2 unique (H)) insert into Test1 values (1, 'A')...
0
votes
1answer
45 views

Is accelerated database recovery available in SQL Server 2019?

SQL Server 2019 CTP introduced a new feature – accelerated database recovery. But then something strange started to happen: If we look at doc page about this feature, we would see no mention of SQL ...
0
votes
0answers
22 views

Problem with installation Polybase in SQL SERVER 2019 on local instance

I am trying to install Polybase on SQL Server 2019 but in process of instalation I got following error: [ZARZĄDANIE NT\USŁUGA SIECIOWA] is [NT AUTHORITY\SERVICE]. I was also trying [NT AUTHORITY\...
0
votes
1answer
62 views

How to calculate a value for all rows in sql server?

I have two tables. One is a linking table to handle a many-to-many relationship between users and construction projects, and the other one is a payment table which includes the users' payments. Now I ...
1
vote
2answers
42 views

Properly determine SQL Server version and update level

I have some existing code which tries to read the current version of SQL Server that's installed for a particular instance name by using a WMI query. It checks the first dotted part of the VERSION (...
3
votes
1answer
112 views

Subscription Initialization throws Error “The option ”INLINE=ON“ is not valid for this function” which is incorrect

Scenario We are upgrading our SQL estate to SQL Server 2019 and have setup what will be the production environment. From: SQL2008R2 Standard/Windows Server 2008R2 - Primary Server/Secondary Server (...
0
votes
1answer
60 views

Querying a table with 200+ million rows by filtering on the clustered index AND additional column is super slow

We have one table that has clustered index on two columns: first one is NVARCHAR(50) and second one is on DATETIME2(3) type. There are few other columns. When we query the table with WHERE clause on ...
0
votes
1answer
22 views

How to name tables which are responsible for storing dictionaries and configuration?

Below I attached diagram which corresponds to part of my database : My questions: In your opininon Do I have to divide ServiceInsance and ConfServiceInstance ? I did it like that because I would ...
4
votes
1answer
195 views

SQL Server evaluation period has expired

OS: Windows 10 Enterprise 64bit SQL Server: Microsoft SQL Server 2019 (RC1) SQL Server Version: Developer Edition I'm unable to start the SQL Server service due to the following error, "SQL Server ...
0
votes
1answer
43 views

Best way for naming schemas in SQL Server 2019 [closed]

Would like to ask about using of schemas in Sql Server 2019. For now we are using numbers as schemas for procedures and functions: 0,1,2 etc. to version procedures and functions. For example [1].[...
0
votes
2answers
51 views

Linked Server from On-Premise to Azure SQL Database

I am using: SSMS-18.4 SQL Server-SQL 2019 CU3 Windows 10 I was able to create a linked server successfully from on-premise SQL 2017 to the Azure SQL database without exposing my password. --Read ...
4
votes
0answers
103 views

How can Cumulative Updates to SQL Server 2019 be Slipstreamed into a Single Installer?

I'd like to take the latest version of SQL Server (SQL Standard, 15.0.2000.5), and apply the latest CU to it so that I have a single installer, thus reducing the size of the resulting package. The ...
0
votes
0answers
31 views

SQL 2019 Database Engine Service Stopped

I'm having an issue with my new SQL 2019 server. It seems that randomly the Database Engine service is stopping. It has happened 4 times over the last 3 weeks. There is no pattern as to what days/...
4
votes
0answers
112 views

SQL Server 2019: Memory performance with graph queries (possible memory leak)

I'm currently working on implementing an upgrade to SQL Server 2019 in order to make use of the graph features that are available in it. Our database stores records of files and their children, and ...
0
votes
0answers
22 views

SQL Server Mirrored Backups proceed as single location backup if errors: How to do that?

**The problem ** I am currently experimenting with Mirrored Backups for the first time. Imagine a backup command like this: BACKUP DATABASE [myDB] TO DISK = N'B:\DB_Backups\myDB_FULL_20200318_083821....
0
votes
1answer
57 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....
0
votes
1answer
34 views

Piecemeal Restore: Can you add new filegroups during the restore?

I have a SQL 2019 Standard instance and am currently fiddling around with piecemeal restore in order to be able to restore a database more quickly. What do I try to achieve? The database has ...
3
votes
0answers
75 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 ...
6
votes
0answers
173 views

Select permission denied when using linked server in a function unless inlining is off

We are encountering an unusual error in our beta environment after upgrading to SQL Server 2019. This occurs when selecting from a scalar-valued function. This error does not occur in our production ...
0
votes
1answer
52 views

Exception when starting Snapshot Agent when setting up database replication

I am trying to set up replication between databases. I followed these tutorials: Tutorial: Prepare SQL Server for replication (publisher, distributor, subscriber) and after: Tutorial: Configure ...
2
votes
0answers
88 views

InitPersistentVersionStore failed after installing CU2 on multiple instances

I saw this on another post, but I can't comment on it. So I am opening a new one, but I am having a similar issue that Martin Guth had posted. It is odd, but I updated about 9 of my instances to CU2 ...
4
votes
4answers
260 views

Why are [Seemingly] suitable indexes not used on a LEFT JOIN with OR

I have the following [fairly meaningless, just for the purpose of demonstration] query in the StackOverflow database: SELECT * FROM Users u LEFT JOIN Comments c ON u.Id = c....
2
votes
1answer
40 views

sys.dm_db_file_space_usage not returning correct values in SQL 2019

Scripts I use for database space metrics on our SQL Server do not return the correct values for allocated_extent_page_count and unallocated_extent_page_count from sys.dm_db_file_space_usage when run ...
2
votes
1answer
75 views

Different execution plans in SQL Server for same query but different offset

I am doing performance experiments regarding the fulltext search feature of Microsoft SQL Server using the stackoverflow database. I have a (seemingly simple) query that results in different ...
0
votes
0answers
7 views

Change PBIRS Layout

Does anybody know if it is possible to change the color of the PBIRS Reporting Portal. Currently its only black and we did not found a way so far to change it. Thank you...
2
votes
0answers
44 views

SQL Server Agent is not ending some jobs correctly

we observed a strange behaviour after migrating our datawarehouse from SQL Server 2012 to SQL Server 2019. Our Agent runs most of the jobs correctly after the migration. However there are a few were ...
1
vote
0answers
81 views

After installing SQL Server 2019 CU2, SQL Server Agent stops working [duplicate]

After installing SQL Server 2019 CU2, SQL Server Agent starts consuming too much CPU resulting into skip job schedules. Although the agent service is running but it looks like hang and didn't process ...