Questions tagged [sql-server-2016]
SQL Server 2016 (major build version 13.00.xxxx). Please also tag sql-server.
2,806 questions
1
vote
1
answer
44
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
62
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
70
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
208
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
82
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,656
0
votes
2
answers
287
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
84
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
72
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
500
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
352
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
1
vote
1
answer
102
views
SQL 2016 Small ETL batches load very slowly while large batches load normally in terabyte database with giga-row tables
Bear with me, I've got a ton of setup before getting to the questions.
SQL Server 2016, 13.0.7050.2 (but this also happened on earlier builds). I think it's SQL Enterprise Edition (but it could be ...
- 113
2
votes
1
answer
148
views
SQL Server Index Rebuild Lock
I had a Rebuild Index Task from Manteinance Plan running the ALTER INDEX REBUILD PARTITION = ALL WITH (DATA_COMPRESSION = COLUMNSTORE) on several large tables WITH OFFLINE = OFF due to license. This ...
- 21
1
vote
1
answer
288
views
is there a way I can see if a specific patch has been applied to my sql server?
How can I see if this patch has been applied to my sql server server?
I know about @@version, but that shows me the latest patch applied, about about the other patches before that one?
- 17.3k