Unanswered Questions
88,298 questions with no upvoted or accepted answers
45
votes
5
answers
4k
views
Oracle SYS_CONNECT_BY_PATH equivalent query into SQL Server
I'm trying to convert a complex query involving the Oracle SYS_CONNECT_BY_PATH syntax into SQL Server:
SELECT
DISTINCT TO_CHAR(CONCAT(@ROOT, SYS_CONNECT_BY_PATH(CONCAT('C_',X), '.'))) AS X_ALIAS
, ...
- 1,908
16
votes
2
answers
7k
views
JDBC getUpdateCount is returning 0, but 1 row is updated, in SQL Server
Anyone ever seen this? I'm using MS SQL Server 2008, and I've tried it with two different JDBC drivers (jtds, and Microsoft's). I run a simple statement to update a row, and it does update it, but ...
- 7,797
15
votes
1
answer
3k
views
Table Partitions with Entity Framework Core
I have a large database that will use partitioned column-store tables in a redesign. Is it possible to specify the partition in the generated sql with Entity Framework Core 2.2?
This is for an Azure ...
- 15.2k
15
votes
2
answers
2k
views
Calling SSIS with SSISDB implementation from SQL Server Service broker
The requirement is to call a web service through SSIS and calling the SSIS from a SQL Server Service Broker activated stored procedure.
Here is what I have currently doing:
Queue
CREATE QUEUE [...
- 1
13
votes
2
answers
1k
views
EF won't migrate after database restore
I'm going crazy... I've been trying to write integration tests that restore a database. In the process of writing these tests, I've been playing with my SQL Server User Settings. In the end, I pulled ...
12
votes
0
answers
486
views
Simple SQL query to read one single (large) record takes forever when run is K8S pod, instantaneous when run in IIS
I have a simple table in SQL Server:
CREATE TABLE [dbo].[MyTable]
(
[Ticket] [uniqueidentifier] NOT NULL,
[UserID] [int] NOT NULL,
[Progress] [int] NOT NULL,
[Created] [datetime2](7) ...
12
votes
2
answers
2k
views
How to make SSAS Dimension attribute data type as Numeric in Excel
I need to your help to change the dimension attribute data type in Excel sheet when connecting cube via excel and I have defined a column as "FLOAT" in Data warehouse and "DOUBLE" in Cube,but that ...
- 2,215
12
votes
2
answers
7k
views
System.Data.Entity.Infrastructure.CommitFailedException: C# Multithreading & SQL Server 2012
We have a C# multi threaded (100 threads) program which reads the records from the DB and each thread picks up one record (one Entity Framework connection per thread) and update the a single DB table. ...
- 1,590
12
votes
2
answers
2k
views
Recent Failures on Delphi TADOStoredProc / D6 and RAD Studio XE2
Thanks to any that can provide some assistance...
Background:
I have an application coded and still supported in Borland Delphi v6. Very recently I have had issues with the TADOStoredProc class ...
- 4,096
11
votes
2
answers
279
views
Azure Recovery Services and SQL 2014 Managed Backups not playing well together
I started using Managed Backups on my SQL server. It has been working well for over a year. It seems to backup the dbs once a week, and take incrementals every 2 hours.
A month ago, we changed our VM ...
- 8,767
11
votes
3
answers
20k
views
Connect to SQL Server instance using pymssql
I'm attempting to connect to a SQL Server instance from a Windows box using pymssql (version 2.0.0b1-dev-20111019 with Python 2.7.1). I've tried the most basic approach from the console:
import ...
CommunityBot
- 1
11
votes
1
answer
1k
views
SSDT Schema Compare always adding objects, which are "Build = None" in Solution
In my Visual Studio Database Solution, I have some objects, which I had to set Build action = None, due to several reasons (Problems in build caused by OPENQUERY,...).
Unfortunately the Schema Compare ...
- 28.4k
10
votes
0
answers
843
views
How to deal with SQL Server connection pooling leaking transaction isolation levels
When you are using Microsoft SQL Server connection pooling, a recycled connection gets all the session details reset (eg: temp tables are deleted). Internally this is done by the special sproc ...
- 28.4k
10
votes
1
answer
3k
views
Applying EF Core migrations per tenant schema
I'm working with .NET Core 3.1 and EntityFramework Core 3.1.3.
I'm trying to implement tenant data separation using DB schemas. I've read this. I'm aware it's a little bit outdated, so I've adjusted.
...
- 1,391
10
votes
0
answers
5k
views
How can SQL Server client get information on TLS certificate being used?
If a client connects to SQL Server, and a certificate is used to power TLS encryption, how can i get information about that certificate?
Ideally i want all the details, but i'd be happy with
Issuer: ...
- 260k