Newest Questions
105,207 questions
0
votes
0
answers
3
views
Creating Configuration.ini from current install
I'm migrating some SQL servers and I'd like to install the new servers using the configuration.ini's from the old servers. This looks good in most cases, but some of the non-production servers config, ...
- 53
1
vote
0
answers
7
views
JSONB subscripting initializes numeric keys as arrays instead of objects
I'm using PostgreSQL 16+ and working extensively with jsonb columns using JSON subscripting paths (as described here: PostgreSQL docs – jsonb subscripting).
I've run into an issue when updating nested ...
- 11
0
votes
0
answers
12
views
xEvent Not Capturing Events for Large Memory Grants in SQL Server
I want to capture SQL Server queries with a memory grant over 10 GB so those queries and the tables they touch can be tuned to reduce the memory grants. I created an extended events session and a test ...
- 396
0
votes
0
answers
13
views
Collation compatibility between base SAS and PostgreSQL
I'm new to databases and having an issue with sorting/merges. I currently work in base SAS. I connect to my data tables in PostgreSQL 13 using the following code:
libname name odbc dsn="...
0
votes
0
answers
17
views
Fast query got "cancelling statement" on replica
I'll say in advance that I've seen similar questions on this topic, but I just couldn't find an answer because they concerned long queries, while mine, on the contrary, executes the query in less than ...
- 101
0
votes
0
answers
16
views
Db2 for i SQL0904 (CPD4365 Reason Code 3): “More than 65535 bytes in an internal buffer” when selecting many columns
We have an SQL SELECT statement that retrieves over 400 fields from more than 120 joined tables. The query executes successfully on other database systems (Oracle 19c and Microsoft SQL Server 2019). ...
- 101
0
votes
0
answers
19
views
SQL Server 2022 CU11: Specific CPU Cores Constantly Spiking After Plan Cache Fills
We have observed an unusual CPU behavior on our SQL Server 2022 (Core Edition) starting from a specific date.
The issue is that a few specific CPU cores — particularly cores 1, 7, 14, and 21 — ...
0
votes
0
answers
25
views
Setting for saving with headers in SSMS
I've recently updated to SSMS 21.4.12, where I was previously running the 2019 version. In the old version, I was able by default to save with headers when exporting to file with right click save as, ...
- 1
0
votes
0
answers
17
views
MariaDB Connector/ODBC <-> Connector/C compatibility issue?
I'm working on a port of a product from Ubuntu 24.04 LTS to Rocky Linux 9.6. Among other things, the product is based on MariaDB 10.11.10, via the Connector/ODBC library. When I use the package ...
0
votes
1
answer
47
views
Why is there such a huge size difference between a materialized view and its PowerBI file?
I have a materialized view in postgresql. The one in question is called "Mem_Excav_NoShows".
My question is why is the materialized view 1.8G in postgresql, but when loaded in PowerBI ...
- 339
0
votes
1
answer
57
views
Non clustered index including all columns smaller than the clustered index
While messing around in SQL Server to get a better grasp on indices, I'm quite surprised to see that if I create an index (on another column than the PK) that includes all columns, it is still lighter ...
- 215
-1
votes
0
answers
23
views
Commvault Backups For SQL Server [closed]
Is anyone using the Commvault agent for SQL backups please? If so what are your thoughts/experiences?
As a DBA I would prefer to use native SQL backups, but I am trying to keep an open mind......
- 74
0
votes
0
answers
34
views
SQL Server Error 4011: The incoming tabular data stream (TDS) protocol stream is incorrect. The MARS TDS header contained errors
I was told I would have more luck here so this is a clone of https://stackoverflow.com/questions/79783222/sql-server-error-4011-the-incoming-tabular-data-stream-tds-protocol-stream-is?noredirect=1#...
- 1
-1
votes
1
answer
32
views
Named Instance SQL Server doesn't work with Backup Solution
I've been using Ola's Maintenance Solution for a couple of years now and it always worked well for me. For backups I use Quest LiteSpeed.
Now I am testing IDERA SQLSafe and having this issue when ...
- 37
-1
votes
1
answer
43
views
Migrating SSIS from using Microsoft Connector for Oracle to ADO.NET
With Microsoft's notice back in January that SSIS in SQL Server 2025 no longer being supported, we're looking to move from the Microsoft Connector for Oracle (prev known as Attunity) over to the ADO....
Shawn Guillemette