Questions tagged [sql-server-2019-express]
36 questions
0
votes
1 answer
How to get the first and the last value in a column per each sequence with the same value
I would like to get the first and the last value in the column Status1 of each sequence of the same value!
This is an example of my table:
time Status1 Eficiencia Lote
----------------------------------------------------
2020…
0
votes
1 answer
C drive is getting full when I run any query on SSMS via sequel server 2019
I have Sequel server 2019 with databases on it and whenever running query on the database, the C: drive will lose space until I close out of the query and then it will regain it all.
I've tried running management studio from SQL server 2019 querying…
Shaik
- 1
- 1
0
votes
2 answers
Cannot connect polybase to Oracle
I try to connect my SQL Server 2019 to Oracle via Polybase.
4/15/2020 1:25:51 PM [Thread:5816] [NativeOdbcConnection:InformationEvent] (Info, Normal): NativeOdbcConnection.Open, ConnectionString: Driver={PolyBase ODBC Driver for…
Stefan S
- 85
- 2
- 9
-1
votes
2 answers
Create new row with a one new value based on value in another row
What I have:
VALUE
PROPERTY
HOST
One
1
Dave
Two
2
Dave
Three
3
Dave
What I want to achieve:
VALUE
PROPERTY
HOST
One
1
Dave
Two
2
Dave
Three
3
Dave
One
1
Pete
Two
2
Pete
Three
3
Pete
So I'm trying to create new…
Peter Riddell
- 3
- 2
-1
votes
1 answer
Automatically generate unique id like UID 22-001
I want to automatically generate unique id with per-defined code attach to it.
ex:
'UID 22-001..
'UID 22-002..
'UID 22-003 ('22' is year 2022)
and then when the year is 2023 it will be generated as;
'UID 23-001..
'UID 23-002..
'UID 23-003..
and…
Darwin Zonio
- 1
- 1
-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