Stack Overflow
Stack Overflow

Questions tagged [sql-server-2019]

Use this tag for questions specific to the 2019 version of Microsoft's SQL Server.

New Features Of SQL Server 2019

  1. Intelligent Query Processing Enhancements enter image description here
  2. Accelerated Database Recovery (ADR) enter image description here
  3. AlwaysEncrypted With Secure Enclaves enter image description here
  4. Memory-Optimized Tempdb Metadata
  5. Query Store Custom Capture Policies
  6. Verbose Truncation Warnings
  7. Resumable Index Build
  8. Data Virtualization With Polybase enter image description here
  9. Last Actual Execution Plan DMF
  10. Multiple Internal Performance Improvements

Reference : What's new in SQL Server 2019 (15.x)

977 questions
-3
votes
1 answer

Best way to upload 14 million records from CSV Excel to SQL Server 2019

Is there any best way to upload 14 million records into SQL Server database, without splitting the file. Thanks in advance. I have tried with import export wizard tool, but the database freezes. I am expecting an alternate source to upload the 14…
Teja
  • 1
  • 6
-3
votes
1 answer

How to speed up query from 2 tables with 400 million rows each

I have 2 tables, trans_details_sell and trans_details_buy, and both have 400 millions rows each. These 2 table are linked up with a unique column call cdr_id. A 3rd table is deal_master, which is the master table only have about 300 master…
Alan Chew
  • 35
  • 1
  • 3
-3
votes
1 answer

How to disable the feature Accelerated Database Recovery (ADR) in SQL Server 2019 Express edition?

Is there a way to disable the new feature Accelerated Database Recovery (ADR) in the SQL Server 2019 Express edition?
kbisang
  • 558
  • 4
  • 13
-3
votes
4 answers

Only two objects + rest the count

I want to show the below string: Apple,Banana,Cashew,Doughnut,Elephant,Fish into this format: Apple, Banana + 4 others I only want to show first two objects and rest the count !
spruless
  • 21
  • 3
-3
votes
2 answers

Convert dd/mm/yyyy hh:mm:ss am/pm to yyyy/mm/dd hh:mm:ss

I need to convert "13/10/2021 09:38:20 PM" to "2021/10/13 21:38:20" in SQL Server 2019. I have looked up the internet for the same but I can't find a solution. Please help me.
Pallavi Singh
  • 55
  • 5
-3
votes
1 answer

I need write a query pivot or your solution on SQL Server 2019

I'm working SQLServer 2019 and I have orders table. Orders table has columns orderid, userid, country, site, count, price. I need help write query. You can see below with details. Question: Show me that how much user ordered from 2010 to present…
user17141323
  • 1
  • 1
-3
votes
1 answer

Use multiple where conditions in SQL select statement

I have a SQL query as below(which is wrong) where I need to adjust the where condition as per the conditions shared. select 'app' as appkey,'arival' as layer, 'fmcg' as sets,ID as HOME_ID, INVO_DATE as INVOICE_DATE, …
batman_special
  • 115
  • 1
  • 2
  • 10
-4
votes
1 answer

Ordering string containing numbers

Strings which begin with number should be ordered first, then strings (which may or may not contain numbers next) Here's sample data : 1000 apples 500 apples 10 apples 10 bananas Container 100 Box 10 Container 1000 Container 123 Container…
BigIWT
  • 243
  • 1
  • 5
  • 14
-4
votes
1 answer

Obtain names from foreign key relationship

I would like to alter my query result to give me a different result for example when I run this query select * from receipt where receiptId = 358914592` It gives me a table like…
lovely dovy
  • 1
  • 3
-4
votes
1 answer

Function that receive table name as input variable to be used in CROSS APPLY

I need to create a Db function that returns a list of GUID, but from different tables. So I'm trying to create a db function, that get as input the name of the table, and return a list (table with only one field), but since I cannot use dynamic sql…
ff8mania
  • 1,553
  • 3
  • 19
  • 28
-4
votes
1 answer

Why does this conversion to date fail on some rows in my table and not other rows when I use an IIF

I have this table and data: CREATE TABLE dbo.tBadDate ( BadDateID int NOT NULL, StartDate nchar(20) NULL, CONSTRAINT [PK_tBadDate] PRIMARY KEY CLUSTERED ( [BadDateID] ASC ) ); INSERT dbo.tBadDate (BadDateID, StartDate) VALUES…
nicomp
  • 4,344
  • 4
  • 27
  • 60
-4
votes
1 answer

How to get the SUM of all values in CSV in SQL Sever?

I have a CSV, I want to get the SUM of all the values in it, I couldn't find a good solution. I have thought to try STRING_SPLIT like the below, But It requires compatibility level 130 and my SQL Server is on 120. I cannot change the compatibility…
Vivek Nuna
  • 25,472
  • 25
  • 109
  • 197
-5
votes
1 answer

Writing a SQL function that returns a function and get `Expecting EXTERNAL` near 'begin'

The code tries to get all numeric columns and then returns the list as a new table but I am getting stuck at the begin part. The error is: Expecting EXTERNAL near 'begin'. go create function get_num_col(@table_name varchar(255)) returns table (…
Gerry
  • 1,159
  • 1
  • 14
  • 29
-5
votes
1 answer

How to split multiple strings from one row to table and how to add multiple strings to one row using SQL

I would like to know how to separate the string so that the result is like this tax company name branch #1-0 123456789123456 2022-05-14 01:51:09 38.75 5.05 10-1 /…
Mohammed Abdelrahman
  • 17
  • 1
1 2 3
…
64
65