18,045 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

Azure Data Factory - Pipeline always fails at the second connection to On-Premise data source

I have SSIS Package that pulls data from On-premise data Source and push data to Azure Database. In that package, I have 3 data flow tasks, each of them connect to one db on On-premise data Source. SSIS Package has been deployed to Azure SQL DB (SSISDB)…

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,201 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,647 questions
Azure Load Balancer
Azure Load Balancer
An Azure service that delivers high availability and network performance to applications.
405 questions
asked 2024-05-11T18:23:31.62+00:00
HellNguyen-0736 0 Reputation points
answered 2024-05-11T21:30:43.7233333+00:00
hossein jalilian 3,250 Reputation points
1 answer

Unable to install SQL Server. Exit code (Decimal): -2064908287

Hi, I tried to reinstall SQL server and it shows this error, please tell me how to solve this problem. Thank you. This is all it says in the summary file Overall summary: Final result: Failed: see details below Exit code…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-11T19:27:24.82+00:00
Dante904 0 Reputation points
answered 2024-05-11T21:20:33.62+00:00
Erland Sommarskog 101.9K Reputation points MVP
1 answer

Help with SQL

Hi Experts, Need help in creating calculated columns as below. My Data: Expected Result of two calculated columns: Calculated Column 1 = Previous calculated value in Calculated Column 1 * Rate Calculated Column 2 = RecentMinRent * current…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
48 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2024-05-11T17:16:52.7+00:00
Shyam Sreeramula 1 Reputation point
answered 2024-05-11T18:59:27.29+00:00
Erland Sommarskog 101.9K Reputation points MVP
1 answer

can not start sql server2012.the request failed or ther service did not respond in a timely fashion.

This error will be reported after starting sql server 2012, check the log，Please refer to the following picture to view the log. How to solve it? The description for Event ID 17836 from source MSSQL$MSSQL2012 cannot be found. Either the component that…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-11T04:10:59.0033333+00:00
Han Yang 0 Reputation points
commented 2024-05-11T17:38:01.18+00:00
Erland Sommarskog 101.9K Reputation points MVP
1 answer

SSRS Report Viewer windows forms - The request failed with an empty response

Dear all, we use the following component in our Windows Form (.net 4.7.2 application): Microsoft.ReportingServices.ReportViewerControl.Winforms 150.1620.0 Since we migrated our server on a new domain, we are getting sometimes the following execption in…

Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,839 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,813 questions
asked 2024-05-10T13:16:20.6633333+00:00
SERIOLI, MARCO (MSTI) 0 Reputation points
commented 2024-05-11T17:09:54.98+00:00
كوثر بنت عوض بن قاسم اليافعي 0 Reputation points
1 answer

query taking long time to match

Hi Team, how to split the query to check data missmatch fint.eabl column if there multiple left joint and taking time to match it query attached

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2024-05-10T13:40:44.6133333+00:00
Vineet S 165 Reputation points
edited the question 2024-05-11T14:43:43.9433333+00:00
Vineet S 165 Reputation points
4 answers One of the answers was accepted by the question author.

SSMS 20 can't show conflict viewer

Hi! Clicking on View conflicts in Object Explorer open Connect to Server dialog form instead of Conflict Viewer. If I fill in form to connect to the same server, it creates very strange error: A connection was successfully established with the server,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-04-05T12:35:44.52+00:00
Nebojsa Ilic 35 Reputation points
commented 2024-05-11T13:37:55.7266667+00:00
Lloyd @ Binderholz 0 Reputation points
1 answer

I can't start the MSSQLSERVER on new esxi host

I am a student currently studying virtualization and SQL installation for one of my projects apkbeb. After obtaining approval from my instrcutor, I attempted to transfer a virtual machine (VM) to my personal laptop apkbeb.However, upon doing so, I…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-07T11:39:26.0633333+00:00
ahmedbark 0 Reputation points
edited the question 2024-05-11T12:57:47.5366667+00:00
ahmedbark 0 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Server restrictions for support system centre

I am trying to confirm if I can run a SQL Server cluster (AG) to support System Centre. I understand the database must be Standard Edition and dedicated to System Centre. That's clear. What's not clear is can I run a cluster or must it be s single…

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
841 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-10T20:15:25.35+00:00
G, Chris 20 Reputation points
commented 2024-05-11T12:41:07.6966667+00:00
G, Chris 20 Reputation points
1 answer

-2061893606 error

ERRORLOG.txt I can't download sql server

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-11T10:45:29.8933333+00:00
JONATHAN HANSEN 0 Reputation points
answered 2024-05-11T12:00:11.3866667+00:00
Erland Sommarskog 101.9K Reputation points MVP
0 answers

Azure Managed disk performance analysis for SQL Server DB Backup

We are currently trying to optimize cost in our Azure environment and are reviewing dedicated backup disks on servers. We have a few servers running single Premium SSD P50 - 4TB as backup disks, but the actual backup files on these drives are often less…

SQL Server on Azure Virtual Machines
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
Azure Disk Storage
Azure Disk Storage
A high-performance, durable block storage designed to be used with Azure Virtual Machines and Azure VMware Solution.
576 questions
asked 2024-05-11T11:20:30.0233333+00:00
Abimbola Adeniran 21 Reputation points
2 answers

Execution Plan Parallel Deadlock Issue Persisting in SQL Server 2022

Hi Msft team! I hope this message finds you well. I am writing to report a persistent issue with execution plan parallel deadlocks that still exists in SQL Server 2022. Despite updates and patches, this bug appears to remain unresolved, and I have been…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-10T15:07:55.6733333+00:00
Steven Lam 0 Reputation points
commented 2024-05-11T10:42:38.91+00:00
Erland Sommarskog 101.9K Reputation points MVP
6 answers One of the answers was accepted by the question author.

remove values from string

Hi Expert, how will i remove all the characters from values in sql Create table test1 (id string, details string) insert into test1 values('20kjk','3ddf') Regards

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,813 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,247 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,559 questions
asked 2022-08-17T10:50:23.187+00:00
Shambhu Rai 1,406 Reputation points
answered 2024-05-11T10:29:32.2366667+00:00
Ebrahim Bazarjani 5 Reputation points
2 answers

Switching from SQL Server/CAL based licensing to core based licensing model for all SQL servers

We are using Server+CAL licensing model for all SQL servers in our organization. Due to the limitation of number of cores supported by CAL based license, we are planning to switch to core based license. Upon checking with client, he informed, "Under…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-10T06:34:06.92+00:00
Pratibha 0 Reputation points
answered 2024-05-11T08:41:35.8166667+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
3 answers

Unable to install SQL Server (setup.exe). Exit code (Decimal): -2061893606Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.

I have been trying to run kestrel in Visual Studio, and then I got this message: System.AggregateException: 'One or more errors occurred. (A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,247 questions
asked 2024-05-10T07:45:13.2366667+00:00
Natalia Medrano 0 Reputation points
answered 2024-05-11T08:07:00.82+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
1 answer

How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11

Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-10T13:49:21.6766667+00:00
Dhamodharan M 0 Reputation points
answered 2024-05-11T06:05:22.1633333+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
5 answers

SQL SERVER 2022 - certificate error when creating a job for integration services

In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2024-04-10T03:35:21.82+00:00
Marcio Matos 10 Reputation points
commented 2024-05-11T03:08:15.01+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
3 answers

Regarding Compliance of SQL Developer

SQL Developer right now can be consider as free if not used as production environment. But there still something missing information, consider i read the EULA for how SQLDev work. (…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-10T14:30:25.82+00:00
Yozuke Hizawa 21 Reputation points
answered 2024-05-11T01:52:50.2266667+00:00
ZoeHui-MSFT 33,296 Reputation points
2 answers

Virtual Machine Windows Server 2019 Licensing / SQL Server Licensing

Greetings, I am trying to build a new infrastructure with 3 VMs for Application Server, SQL Server and a Test-Dev Server. In many discussions with different providers I did not get the answers that I really need. These 3 VMs must be licensed with Windows…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-10T10:57:46.0566667+00:00
Dimitris Roubos 0 Reputation points
answered 2024-05-11T01:40:31.9+00:00
ZoeHui-MSFT 33,296 Reputation points
2 answers

Licensing SQL server at a host level (2016 -2019)

Hello We have a 10 host on premise VMWare cluster, mostly running Windows VMs. We are looking to license all our SQL virtual machines (versions 2016 through to 2019) using the core based model and would like to license at the physical host level. My…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,814 questions
asked 2024-05-10T06:40:46.1366667+00:00
Algon 1 Reputation point
answered 2024-05-11T01:39:33.0033333+00:00
ZoeHui-MSFT 33,296 Reputation points