Get Global Primary details from All the replicas in Distributed AlwaysOn
In Distributed AlwaysOn, I could not find any DMVs in SQL Server which could provide the details about Global Primary from replicas in Forwarder side (both Primary Forwarder and its local replicas). Is there a way to at-least pull the Global Primary…
How to fix Component error code: 0x80004005 Error description: Unknown error (0xe0000235) during the SQLEXPRADV_x64_PTB (2017) installation?
Hello! I'm having some issues with the SQLEXPRADV_x64_PTB installation (2017 version). I use an MAC MacBook Air Apple M2 (masOS Sonoma 14.1) and Parallels ARM Virtual Machine to run Windows 11 Home 64 bits. In summary, the problem is as follows: Detailed…
Importing Large Data Sets in Visual Studio 2019 and SQL Server 2019 on Windows 11
Hi everyone, I recently installed Visual Studio 2019 and SQL Server 2019 on my Windows 11 system. When creating a project that involves importing a large data set with more than 1 billion rows, I encounter some issues. When using the SSIS process and…
How to install SQL Server 2022 on Ubuntu Server 24.04 LTS
I couldn't find a proper way to install SQL Server 2022 on Ubuntu Server 24.04 LTS. I tried to use Microsoft SQL Server 2022 from the Ubuntu 22.04 repository, but I couldn't run the service correctly. I'm done with this state of service (see printout).Is…
Columns of data type varbinary(max), varchar(max), or nvarchar(max) always assigned a NULL value when __$operation = 1 or __$operation = 3. how to resolve this.
Columns of data type image, text, and ntext are always assigned a NULL value when __$operation = 1 or __$operation = 3. Columns of data type varbinary(max), varchar(max), or nvarchar(max) are assigned a NULL value when __$operation = 3 unless the column…
SQL Server Import and Export Wizard is showing error while importing files
I am trying to import an excel file into SQL Server Management Studio and this error comes up: An error occurred creating the configuration section handler for system.data: Column 'InvariantName' is constrained to be unique. Value…
SQL login issue
I'm trying to connect via local SSMS to the SQL Server on my Azure VM but it's failing saying the Server is not found or accessible. I can RDP into my VM without issue. Any ideas please?
MSSQL Server 2019 std edition EOS date
When is the end of support (EOS) date for Microsoft SQL Server 2019 Standard Edition?
SQL 2012 error
Does anyone know how to solve this error? TITLE: Microsoft SQL Server 2012 Setup The following error has occurred: Locating the SQL Server Browser service component failed with Windows Installer return code '2'.
Unexpected truncation error when inserting from UTF8 to non-UTF8 collation
I believe I am hitting a bug with moving data from a UTF8 to a non-UTF8 collations in SQL Server 2022 CU13 (running under Linux but assuming for now this issue is not related). The issue is that MSSQL appears to be determining the width of a string for…
NTWDBLIB.DLL is not loadable
When I run the SQL Server Client Network Utility, the DB-Library Options show the ntwdblib.dll as not loadable.And the service is legacy which has to use the same ntwdblib.dll and can't afford to use latest/different sql library. Does anyone know why the…
WHY Index Scan Instead Of Seek While Joining Big Table With #Temp Table
In my sql server 2016 database, I have a table 'BigData' having around 50 million rows and a Temporary table #TempID which contains 600 rows. CREATE TABLE BigData (ID INT IDENTITY(1,1) PRIMARY KEY, OtherID INT, Comment nvarchar(max),…
Intermittent SQL Server Connectivity Issues: How to Diagnose and Resolve?
I'm experiencing intermittent connectivity issues with our SQL Server, and I'm looking for advice on how to diagnose and resolve them. Here are the details: Error Messages: [HYT00][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired …
blocking due to cuncurrency problem.
hi, I have a table "bridge" where i keep bridgeid as pk , and hardly four to 5 rows are there CREATE TABLE [dbo].[bridge]( bridgeid [bigint] NOT NULL, [idpool] bigint NULL CONSTRAINT [PK_bridge] PRIMARY KEY CLUSTERED ( [bridgeid]…
Intermittent SQL Server Connectivity Issues: How to Diagnose and Resolve?
I'm experiencing intermittent connectivity issues with our SQL Server, and I'm looking for advice on how to diagnose and resolve them. Here are the details: Error Messages: [HYT00][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired …
Queries with EF Core causes 'Cannot continue the execution because the session is in the kill state'
Some EF Core queries are throwing the following error in our code : Cannot continue the execution because the session is in the kill state. Une erreur grave s'est produite pendant la commande actuelle. Les résultats devront être supprimés, le cas…
I am unable to install SQL server on my window 11, the error is unable to install SQL server(setup.exe) exit code (Decimal): -2061893606
2024-06-08 14:07:53.35 Server Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Express Edition (64-bit) on Windows 10 Home 10.0 <X64> (Build 22631: ) (Hypervisor) 2024-06-08…
transpose row data into columns
Hope I'm asking this correctly. I have a table in this format: I need to have the Unique ID and the account numbers from both stores all in the same record. Like this: How can I accomplish this in SQL? Is this some kind of PIVOT or UNPIVOT? What…
sql server installation issue exit code 2147467259
Summary.txt this is the summary file from the log, pls help me with my issue
AG latency
AG is out of sync. I tried to reconfigure AG but its taking huge amount of time since the db size is 20TB. Is there any other way to fix the latency?