336,858 questions
0
votes
0
answers
21
views
How can low selectivity filters elicit seek rather than table scan?
Values that are low selectivity can elicit a seek operation which is typically more efficient by directly seeking out only the data pages of the rows needed to serve the query.
https://dba....
- 7,541
0
votes
1
answer
44
views
Difference in precision of UTC and Local TIMESTAMP dates inserted with same statement
I have created an ALL SERVER FOR LOGON trigger in my MS SQL Server 2019 Dev Edition to keep track of login activity.
The activity is stored in a database table SYS_UNF_TRAIL that includes the ...
- 369
-1
votes
0
answers
52
views
DATEDIFF unexpected results. I want to calc difference between times. Half of the data is doing the operation perfectly. The other half, not so [closed]
I am unable to get the desired result when I use DATEDIFF function. Half the results are as expected, half of them are not.
What was the average time in mins for driver to arriver at HQ to pick up the ...
-1
votes
1
answer
57
views
row_number giving me trouble when called from a join [closed]
When I run the code below I get no results, but if I remove the b.row field from the first select statement, I do get the expected result set. What I want ultimately, is to have a column in the result ...
- 101
1
vote
1
answer
73
views
Trouble with T-SQL aggregation statement
I am trying to update 2 columns in a table, using an aggregate subquery. For some reason, my subquery does not have "access" to a field in the parent query. I know I have written similar ...
- 11
-1
votes
0
answers
32
views
BCP performance - version 11 vs version 15 - older is faster for same file
currently doing upgrade.
old - BCP -version ==> 11.*
new - BCP -version ==> 15.*
Same file - apple.dat size around 33 MB
when executing... using BCP cmd
I see older is faster than newer one... ...
- 161
0
votes
0
answers
59
views
Import '£' symbol to SQL Server using Azure Data Studio
I am trying to import a table to SQL Server. I'm using the Import Wizard in Azure Data Studio.
The table is a conversion table and the units might be in £ or £000s for example.
The field needs to be a ...
- 505
-2
votes
0
answers
63
views
Retrieve all active IP addresses on SQL database in web app using C# [duplicate]
I need to retrieve all active IP addresses/firewall rules for a SQL database, I tried doing this through a query, but it does not have all the information I need and I'm not sure if I can actually map ...
- 13
-1
votes
3
answers
87
views
Unpivot based on prefix
I want to compare two rows in a same table.
SELECT OLD.[Addressee] OLD_Addressee, NEW.[Addressee] NEW_Addressee,
OLD.[BuildingName] OLD_BuildingName, NEW.[BuildingName] NEW_BuildigName
FROM [dbo]....
- 449
-5
votes
0
answers
70
views
Copy value from row above to row below [closed]
Let's say that this is my base output in view from my sql:
Name
Sname
Value1
Value2
dep
Jack
Wong
6
5
AA
Jack
Wong
11
10
BB
Mark
Tire
2
8
CC
Dann
Dark
22
9
CC
Phil
Wall
3
2
DD
Phil
Wall
33
3
EE
Now I ...
- 1
0
votes
0
answers
80
views
Using EXECUTE with FORMATMESSAGE [duplicate]
I’ve learned that FORMATMESSAGE() is the closest thing to parameterising a string in SQL Server. So this works for me:
DECLARE @db NVARCHAR(12) = 'test';
SELECT formatmessage(N'USE master; DROP ...
- 16.6k
1
vote
0
answers
36
views
ClickHouse JDBC Bridge: "Connection was closed" errors with long-running SQL Server queries
I'm experiencing persistent timeout issues when connecting ClickHouse (v25.2.2.39) to SQL Server through the ClickHouse JDBC Bridge (v2.1.0).
Simple queries work fine: SELECT * FROM jdbc('DWH', '...
- 11
-1
votes
0
answers
47
views
How to use JSON_VALUE to extract all bottom level nodes? [duplicate]
I have the following JSON
{
"227865": [{
"friendlyCode": "Schedule Number",
"friendlyName": "Schedule Number",
...
0
votes
0
answers
46
views
Comparing two dates using SSIS conditional split component
CONTEXT
We retrieve data from a local Gas Station where the company's vehicles go to refuel their tanks in a CSV file.
So we save this data: VOLUME, TOTAL_AMOUNT($), PRODUCT (gas, premium, diesel), ...
0
votes
0
answers
41
views
How to Resolve Special Character Encoding Problems in R When Using Remote Desktop?
I need help on how to solve a problem encoding special characters in R.
I am working on a data warehouse project stored in slq server. The data is in French and when I do my calculations, I encounter ...
