Questions tagged [sql-server-2016]
SQL Server 2016 (major build version 13.00.xxxx). Please also tag sql-server.
2,809 questions
4
votes
1
answer
330
views
Is it possible to stripe backups going to Azure Blob Storage?
Using Ola Hallengren's toolset, I'm attempting do a backup of a database that is resulting in a backup that is larger than 1TB in size to Azure Blob Storage. This, obviously fails, so I attempt to ...
- 484
1
vote
0
answers
64
views
SQLPackage generating unwanted Alter Database commands
I'm using SQLPackage to compare a DACPAC to a Database and generate a change script
When I look at the script I get unwanted Alter Database statements, I've tried various parameters to suppress these ...
- 4,676
0
votes
0
answers
34
views
Retrospectively applying data retention to temporal tables
I've been asked to look at trimming the amount of change information that we're currently storing in a temporal table. The background to this is:
When the organisation that I work for initially ...
- 101
2
votes
1
answer
90
views
Upgrading SQL Server 2008 SP3 to SQL Server 2022 Best Upgrade Path and Licensing Questions
I have a requirement to upgrade several SQL Server 2008 SP3 databases to a new environment on new servers running SQL Server 2022. As per Microsoft’s documentation, SQL Server 2008 cannot be upgraded ...
0
votes
0
answers
86
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
0
votes
0
answers
77
views
How to disable auto create of statistics on a given table? [duplicate]
I'm a programmer, not a DBA, but the company doesn't have DBAs anyway. I just happen to know a few things about SQL Server.
There is an SQL Server 2016 Standard from a legacy system that nobody knows ...
- 4,720
0
votes
1
answer
73
views
ADO.NET client occasionally attempts connection to SQL Server mirror partner even when principal is online
We're running SQL Server 2016 Standard Edition with database mirroring in synchronous mode and automatic failover enabled. Our .NET applications use connection strings with Failover Partner.
...
- 1
1
vote
1
answer
229
views
How can I execute Openrowset in the named instance I am currently in?
I am running this openrowset query about jobs on my current server and I see that the result set is not correct.
I was expecting a bunch of jobs but I only get one.
when I run the following piece of ...
- 17.3k
0
votes
1
answer
95
views
SQL Server Extended Events - collecting SP Object_name
I'm going round in circles trying to work out how to collect the object_name in extended events, I can use it to filter like in the session definition below
CREATE EVENT SESSION [xetest] ON SERVER
...
- 4,676
0
votes
2
answers
355
views
Sql Server Agent service not starting because the Agent XPs is disabled. How to solve this problem?
I have a bunch of servers hosted in Canada,
one of them has some erratic behaviour when under too much pressure for some time.
it just looses connectivity as probably the CPU is on high.
this is ...
- 17.3k
0
votes
1
answer
91
views
where is my ssis package saved after importing data from source server to destination server?
so I am importing some data from a different server on a table I have on master database
this is done through a query on the destination server, but I need to specify credentials on both servers.
...
- 17.3k
0
votes
0
answers
73
views
Same query, different execution plan, massive runtime impact
We have a JavaEE application that calls a stored procedure (SP) for some kind of search form. It's a massive query utilizing multiple joins and conditions.
We now observed, that this SP seems to use a ...
- 1
1
vote
1
answer
591
views
Query Stuck in SUSPENDED State Wait Type BPSORT
I have a query which was stuck in state SUSPENDED for several hours when running sp_WhoIsActive. We run SQL Server 2016 SP3 on a VM with 16 cores and 192 GB memory. This query is an INSERT query for a ...
- 549
0
votes
1
answer
65
views
query to find the latest transactional backup for a server involved in availability group
I got a query to find the latest transactional log backup.
in this particular server it is not working for some reason.
here is the query:
SELECT
@@Servername AS [Server_Name],
B.name AS ...
- 17.3k
0
votes
1
answer
383
views
SSIS Package Failing: Version of the Flat File Destination is not compatible with this version of the data flow
Built a simple SSIS package that pulls data from six SQL tables and dumps out to flat files. Package works fine within Visual Studio but keep getting the error code 0xC0048021 when deploying within ...
- 501