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
0
votes
1answer
45 views

Fresh SQL Server 2019 can't query Excel files

I've been using the same query for ages to query excel files: SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0','Excel 12.0;Database=C:\_DBA_TEMP\Controle.xlsx', [planilha1$]) But with this fresh ...
-2
votes
0answers
31 views

error installing pubs and northwnds data in SQL server [closed]

this is my first time using SQL server, and I need to install the pubs database, I installed the .sql files (from github) and when I add them to a new query it gives me "executed successfully&...
4
votes
1answer
155 views

What is difference between Arabic_100_CS_AS_KS_WS_SC_UTF8 and Latin1_General_100_CS_AS_KS_WS_SC_UTF8?

Starting from SQL Server 2019, it supports UTF-8 as collation. However, according to the following queries: SELECT COLLATIONPROPERTY('Arabic_100_CS_AS_KS_WS_SC_UTF8', 'CodePage') SELECT ...
0
votes
0answers
15 views

ODBC source SQL Server unable to connect to local Sql express 2019

On My Win10 I'm trying to connect to my local Sql Server Express via ODBC. I must the ODBC driver "SQL Server". I create the connection via ODBC sources. I Receive an error prompt. I've ...
3
votes
1answer
58 views

Estimate database growth caused by Accelerated Database Recovery

Accelerated Database Recovery (ADR) is on by default in Azure and an option in SQL Server 2019. It has some really interesting potential. I have experimented by turning ADR on in a static test ...
0
votes
1answer
41 views

Can't remove “synchronizing/suspect” database after removed from availability group Sql Server 2019 Enterprise

I've removed a db from a synchronous availability group.The db shows "synchronizing/suspect" as it should on the secondary. I'm trying to remove this database cannot. I have tried: DROP ...
0
votes
2answers
36 views

Hiding visual relation between two tables with related data

Sorry for sharing a confusing title I have got a requirement to design a DB for a highly sensitive application. There are virtually two set of tables. One is totally demographic information or its a ...
0
votes
1answer
34 views

Selecting all columns from row with specific max value [duplicate]

Imagine that I have the following table: ItemCode WhsCode MinStock MaxStock AvgPrice 123 01 1 4 600 123 02 0 1 200 512 01 0 2 100 489 01 0 6 50 489 02 2 7 72 489 03 5 10 80 489 04 1 4 65 258 ...
0
votes
0answers
89 views

Delayed stored procedure execution

We are having issues with one of our servers. When executing a stored proc it can take seconds to return data. Sometimes it is milliseconds. I don't think it is a parameter sniffing issue as it ...
0
votes
0answers
19 views

SQL Server 2019 CU10 on Linux Crashes When Running a PolyBase Query [closed]

This has been plaguing me for some time now. I run a tiny SQL Server 2019 CU10 Standard instance on Oracle Linux 7 (RHEL 7-compatable) that uses PolyBase to reference tables on an Oracle 19c Instance ...
0
votes
1answer
14 views

Creating specific permisions for DB user

I need to give access to CREATE QUEUE and DROP QUEUE queries. Can`t find that information over the internet, only found that db_ddladmin or db_owner fixed database roles, or the sysadmin have that ...
-1
votes
0answers
32 views

How can I shrink the size of a Microsoft SQL MDF after deleting lots of records from huge table [duplicate]

We have a database with huge amounts of data in the table. We ran a delete statement to remove all these old archive records and don't plan on putting them back. The MDF file is still almost 600GB but ...
1
vote
1answer
65 views

SQL Server 2016 database backup fails to restore on SQL Server 2019

We were trying to restore the database from SQL Server 2016 Developer Edition to SQL Server 2019 Developer Edition and it was failing with an exception. Details about this DB: It has in-memory ...
0
votes
0answers
53 views

SQL Server 2019 Service account Local Activation permission

It's a new installation of SQL Server 2019 Standard, on Windows Server 2019 Standard. I've created a maintenance plan using NT SERVICE\SQLAgent$HPIEF (named instance) but the execution fails reporting:...
0
votes
0answers
34 views

Phantom SQL Agent Job - Reports Running But Isn't Actully Doing Anything

I have a very similar issue to what is presented here. Periodically on one of my production servers a SQL agent job of some sort (that are responsible for calling several EXE's) will report running ...
-1
votes
1answer
36 views

SQL query: Find latest from table with two dates [duplicate]

I have a table with a lot of entries, and I'm stuck on how to get the records with the latest "CreatedDate" This is my table: I would like this to be the result: Date: Shows which date the ...
0
votes
0answers
23 views

TSQL - Take a single row query and transpose based on field value

I'm trying to create a fact table with data I was given. We have a monthly goal number, but we want to be able to figure out how many weeks are in that month and divide the goal number by the weeks in ...
18
votes
1answer
2k views

SQL Server in-memory optmized tempdb metadata memory usage continually growing

Problem We have enabled sp_configure 'tempdb metadata memory-optimized' = 1, and now the tempdb meta data is taking over 400 GB on one of our servers and continues to grow. There are some drops in ...
5
votes
0answers
71 views

Memory Optimized intermittently very slow perfomance

I have a memory optimized table with (in my test) 10 million rows. Running some UPDATE in parallel against it, I get intermittent spikes in CPU and huge spikes in execution time (>1s from 1ms) of ...
5
votes
1answer
201 views

In a multi-database AG, what decides which databases will have more than 1 redo thread?

We have a large physical server with more than 50 dbs on it; some are quite busy, others very quiet. When having multiple DBs in an AG, only some of them multiple redo threads. We wanted the databases ...
1
vote
0answers
30 views

Actual Number of Rows Significantly Lower than Estimated

My Problem I am having an issue with a update query, where the execution plan has a bad cardinality estimate. It is estimated way more rows (14000%) than there should be when it does an Index seek on ...
0
votes
1answer
31 views

Duplicated SQL Server Execution Times For Dynamic Query

I'm getting duplicated SQL Server Execution Times from SET STATISTICS IO,TIME ON with dynamic queries. Is this a normal behavior?
1
vote
0answers
35 views

SQL Server RECEIVE statement ordering issues

I'm seeing some unexpected message ordering behavior running a RECEIVE statement against a Service Broker queue. According to the documentation: For a given conversation, a RECEIVE statement returns ...
0
votes
1answer
20 views

Create archive solution on seperate server

We have a custom application that uses a database trigger that updates a separate "Audit" database to track any changes in data. I'd like to come up with a way to keep another database on ...
1
vote
1answer
39 views

When tempdb allocations are released?

In a Service Broker queue, when one message is proceed over time, we are executing a stored procedure which is performing some heavy operations using temporary tables. I guess that the sp_WhoIsActive ...
2
votes
0answers
103 views

DB_CHAINING lost on on planned Availability Group failover for SQL Server 2019 cumulative update

I'm looking for ideas on how to determine a plausible root cause for DB_CHAINNG problems encountered when we recently performed a planned AG failover. We're using SQL Server 2019 Standard Edition with ...
0
votes
2answers
90 views

SQL Server Query Performance Severely Regresses due to High Memory Use

Moved from StackOverflow. Scenario I have a ASP.NET Core 5 (.NET 5) project that deals with GPS devices and generates roughly 6-8GB of data per day. For the past several months I've been working on ...
0
votes
2answers
30 views

Backup TO URL WITH NOINIT fails because file already exists

There's a similar question here but I cannot work out the solution because the circumstances are slightly different, so please bear with me; I've been wresting with the official help docs all day. My ...
3
votes
1answer
87 views

Entity Framework Core for SQL Server Failover Basic Availability Groups does not work

I have set up an SQL Server Standard 2019 with Basic Availability Groups on a Windows Failover cluster. It is not like the Always On AG, but more of a limited version of it where DB operations are on ...
1
vote
2answers
67 views

Does SQL Server's is_nullable mean anything at all?

SQL Server has a type flag called is_nullable you can see it on sys.types. Currently, (SQL Server 2019) it's only set to FALSE two types, sys.timestamp and sys.sysname. On sys.timestamp this type ...
-1
votes
3answers
34 views

How can I cast to a user-defined type in SQL Server?

SQL Server provides an ability to create a user defined type with CREATE TYPE CREATE TYPE foo FROM int NOT NULL ; However, there is no mention how I construct a value with that type. Is this of use ...
1
vote
1answer
90 views

Which authentication is better for MS-SQL Server 2019 : integrated security=SSPI vs uid=sa;pwd=xx | windows auth vs sa auth

In my different web applications I use both ways, however, I would like to learn which method is better: 1: server=localhost;database=x; integrated security=SSPI;persist security info=False; ...
-1
votes
1answer
41 views

Microsoft SQL Server: TSQL Formatting of Results Columns

I have a result set of data that has duplicates because certain companies are tied to multiple banks is there a way to combine the values in the BankName column either into a single column. So the ...
3
votes
1answer
73 views
+100

Changing Database Encryption Keys

I have been asked to "rotate" the Certs and Keys for a given database and the only way I knew of to accomplish this was to unencrypt the data first, using DECRYPTION BY CERTIFICATE, create ...
0
votes
0answers
15 views

Is there a way to purge a DTC transaction from command line?

as you can see on my screenshot, I have a DTC transaction in error on my server. I know, I can Right -> Resolve -> Forget/Abort However, I want to do it with a command line (batch or Powershell)....
0
votes
2answers
53 views

Database status “restoring…”

I have opened SSMS today, and went to open my database ADMINISTRATOR (in the picture) but this option is unavailable: What's this problem, how can I cancel this restore? I have just added a new ...
1
vote
1answer
117 views

Nested AD group access not working when nested more than 2 levels deep?

For the setup of the security of the databases we have created a number of nested Active Directory groups: Group Members Group type RGP-EA_PROD-RW RGP-SparxEA-RW Domain Local Security RGP-SparxEA-...
4
votes
2answers
79 views

Multiple Set Quoted_identifier within one script takes the last one?

I'm using SQL Server 2019 and just found a weird behaviour. Research has not gotten me anywhere further. Can someone please explain this behaviour? SET QUOTED_IDENTIFIER ON; if ((256 & @@options) ...
0
votes
3answers
62 views

Replicating contained SQL databases to customer in near real-time

We host a number of customer SQL Server databases that we need to replicate to external customer sites in near real-time. The main constraint we have is that, for security reasons, our databases are ...
1
vote
1answer
76 views

FirstResponderKit - missing objects

our vendor has recommended us to use your tool to collect data for him. After the installation (version 8.03) we received following errors (warnings): *The module 'sp_AllNightLog' depends on the ...
1
vote
1answer
113 views

Parallel Redo Message Spam

yesterday i had several Problems in a Windows Service with a Function that already works and runs several Months without a Problem. But yesterday i got alot of Errors in my Service. The Errormessages ...
0
votes
1answer
48 views

Changes to server configuration option remote access are not supported in SQL Database Managed Instances

Having just set up our new SQL Server Managed Instance, restored a sample database for testing, and run Azure's vulnerability assessment, it produces this high risk finding: VA2120 - Features that ...
0
votes
2answers
92 views

Check if column has same value in any row

I have the following case. +-----------+--------+-------------+ | ArticleID | UserID | IsConnected | +-----------+--------+-------------+ | 1 | 25 | True | | 1 | 45 | ...
0
votes
1answer
53 views

While testing our workload on SQL Server 2019 we experience much higher CPU utilization compare to the same test on SQL Server 2014

We are getting ready to upgrade our SQL Server 2014 systems to SQL Server 2019. As part of our due diligence we created a workload which we are testing against both systems. What we have observed was ...
2
votes
1answer
50 views

Do SQL OS Background Tasks Yield to Normal Tasks?

I have a SQL Server 2019 server that is running at about 22% CPU. I look at what's running and I see that about half of that 22% is coming from background tasks (i.e. the status is "background&...
1
vote
1answer
57 views

How to prevent/detect fetching data from another database on same server

I have discovered a problem in our development where I need some help. We had some reports developed by an outsourced person, and now I am cleaning up his mess. The biggest problem is that he has ...
0
votes
0answers
25 views

SQL Server 2019 on Ubuntu Throwing security.crypto.symkey errors

I'm repeatedly seeing the following error, seemingly for every connection to SQL: 04/06/2021 16:39:25.890647613 Error [security.crypto.symkey] <0000004241/0x00000c34> Setting Variable Length ...
2
votes
1answer
875 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....
0
votes
1answer
151 views

Can Microsoft JDBC Driver 4.0 connect to SQL Server 2019 and perform DML without issue?

The SQL version compatibility BOL article advises that the minimum compatible JDBC driver version for SQL Server 2019 is 7.4. Can an older JDBC driver still connect to SQL Server 2019? Or can only the ...
2
votes
3answers
349 views

Critical query plans removed from sys.dm_exec_query_stats while trivial items are kept [duplicate]

Running SQL Server Express 2019. Have a complicated stored procedure containing 11 sql statements (when selected from sys.dm_exec_query_stats by plan_handle). 9 of those statements are simple variable ...

1
2 3 4 5 6