19,185 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
7 answers

Svchost Issue - user profile service - Server 2022 high memory usage

Recently I have install 3 windows server 2022 with mssql 2019. Every two days the system stuck, and I find user profile service consume all the free memory. it's not happens on servers without sql. Btw: I'm not sure if it have something to do but we are…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,049 questions
asked 2023-07-05T18:34:52.1633333+00:00
אריאל ווינברג 5 Reputation points
answered 2024-10-03T22:39:04.73+00:00
Benjamin Jensen 0 Reputation points
2 answers One of the answers was accepted by the question author.

Suggest a way to replicate data from on premise sql server 2019 to azure synaspe analytics directly

Im using an sql server in my on premise with version 2019, I need to transfer or replicate real time data to azure synapse database, so which azure service will be more effective and flexible for large data transfer

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,914 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.
13,771 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,666 questions
asked 2024-09-26T14:30:15.38+00:00
AGP 20 Reputation points
commented 2024-10-03T21:15:47.0133333+00:00
Erland Sommarskog 111.1K Reputation points MVP
1 answer

How to solve the error 2068052377?

error while installing ms sql 2022 express edition basic installation Oops... Unable to install SQL Server (setup.exe). Exit code (Decimal): -2068052377Error description: Invalid command line argument. Consult the Windows Installer SDK for detailed…

Windows App SDK
Windows App SDK
A set of Microsoft open-source libraries, frameworks, components, and tools to be used in apps to access Windows platform functionality on many versions of Windows. Previously known as Project Reunion.
785 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.
13,771 questions
asked 2024-10-03T17:00:33.4233333+00:00
Chanchal 0 Reputation points
answered 2024-10-03T21:08:45.43+00:00
Erland Sommarskog 111.1K Reputation points MVP
2 answers

how to export stored procedure data with headers into a xls file in sql server?

Hi every MS Sql server user . I have a stored procedure in my server that make a lot of join and in the result shows them. Now I want to make a job in the server and this job should run this SP and copy the results into a xls file.I have seen a lot of…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
asked 2024-10-03T05:54:01.9133333+00:00
Farshad Valizade 441 Reputation points
answered 2024-10-03T21:00:17.5533333+00:00
Erland Sommarskog 111.1K Reputation points MVP
0 answers

Bug on dbo.SP_DeleteOldJobs (HPC pack 2019U1)

problem: Project filter on Job Manager or Cluster Manager doesn't clean up. So, after digging into a bit, I found out the delete query is a bit wrong written as null entries are inside ProjectId column on Job and JobHistory table. So, delete query on…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,049 questions
asked 2023-11-10T14:54:48.16+00:00
Sven 21 Reputation points
commented 2024-10-03T20:51:47.94+00:00
Zheyu Shen 0 Reputation points Microsoft Employee
1 answer

Pivot query result (column name will change)

Hi there, Have been working on a huge database task and one part of it is the below. How do i pivot this 1 row with dynamic columns (column names will change) Query: select top 1 * from INFORMATION_SCHEMA.columns Output should be ColumnName |…

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.
13,771 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,636 questions
asked 2024-10-02T23:08:15.1166667+00:00
RJ 166 Reputation points
answered 2024-10-03T20:38:33.17+00:00
Amira Bedhiafi 24,451 Reputation points
1 answer

SQLServerException: An item with the same key has already been added.

Running the query: SELECT name FROM [" + catalog + "].sys.schemas ORDER BY name I got exception: 10:05:26 [com.microsoft].sqlserver.jdbc.SQLServerException: An item with the same key has already been added. RequestId:…

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.
13,771 questions
asked 2024-10-03T17:18:28.88+00:00
dprutean 0 Reputation points
answered 2024-10-03T20:35:20.94+00:00
Amira Bedhiafi 24,451 Reputation points
2 answers One of the answers was accepted by the question author.

How to add 100 plus source link in ADF pipeline to transfer data to single destintion.

I need to transfer data from multiple source sql servers( almost 100 plus) to a single destination using ADF, Is there is any way to add these much servers to ADF as source

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,914 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.
13,771 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,666 questions
asked 2024-09-29T13:21:02.1033333+00:00
AGP 20 Reputation points
accepted 2024-10-03T18:53:06.7366667+00:00
AGP 20 Reputation points
0 answers

Cannot connect to SQL Database. Please contact SQL server team for further support.

Hello support from time to time i get an error that username/password is invalid for database. However database is up and running and in use. below are the infromation activityid 701ef079-7056-4d6b-b941-c2e2f011e57a

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.
13,771 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,666 questions
asked 2024-10-01T08:13:02.49+00:00
Ninoslav Zekic 10 Reputation points
commented 2024-10-03T18:28:19.2933333+00:00
Sai Raghunadh M 310 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Comparison of actual database schemas against each other (within one database)

Hi all, for a small project I created a database within Azure and one schema for dev and one for prod (to save run cost). I would like to compare these two schemas now with Azure Data Studio, but it looks like, that I can only compare databases with one…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
115 questions
asked 2024-08-17T10:10:18.3266667+00:00
Maximilian Ksoll 0 Reputation points
commented 2024-10-03T18:06:47.1133333+00:00
Oury Ba-MSFT 19,101 Reputation points Microsoft Employee
3 answers

How to pass in clause values via SSIS paramter

Hi, I have created SSIS package based on the query( big query),In query in clause is there. I have created parameter in ssis level and trying to pass multiple values(a,b) to in clause ,It is not working how i can achieve. Can you please suggest…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2021-04-09T06:32:19.5+00:00
KlearnSSIS 1 Reputation point
answered 2024-10-03T17:50:01.8133333+00:00
Michael Baker 1 Reputation point
0 answers

How to fix "error:1C80006B:Provider routines::wrong final block length" in SQL Server ODBC client (Linux)

I'm trying to write C++ ODBC driver code to execute SQL statements from a Linux server. I keep running into errors such as: DIAG [08S01] [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider: [error:1C80006B:Provider routines::wrong final block…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,719 questions
asked 2024-10-02T22:42:20.45+00:00
Tim Coleman 0 Reputation points
commented 2024-10-03T16:46:47.8933333+00:00
Tim Coleman 0 Reputation points
3 answers

How to extract lineage from on-prem sql server ?

I want to scan store procedure from on-prem sql server as well as extract the lineage, Is there any way to achieve it either using Mircosoft Purview or using Apache Atlas API? I'm not using any ADF pipeline to transform the data, data is moving and…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 questions
Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
1,160 questions
asked 2023-05-07T14:54:39.3933333+00:00
Ritik 5 Reputation points
commented 2024-10-03T16:20:40.24+00:00
Nazeer Ali Mohammed 0 Reputation points
1 answer

Azure SQL database restore to Synapse

we need to do restore sql server database from restore point to dedicated sql pool on synapse on same resource group we are trying to do restore azure sql server db on same restore group where we have synapse but it ends up with error ERROR1.JPG Command…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,914 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.
13,771 questions
asked 2024-09-11T14:01:57.8966667+00:00
Andrea Galardi 0 Reputation points
commented 2024-10-03T16:18:03.0366667+00:00
Molly VanderVelde 51 Reputation points
0 answers

Does SSIS and SSDT require additional licenses for SQL Server 2019 Developer Edition?

Does SSIS and SSDT require additional licenses for SQL Server 2019 Developer Edition? Here is my SQL Server details SQL Server Management Studio 20.2.30.0 SQL Server Management Objects…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-10-03T13:37:18.4033333+00:00
Lyles, Kevin 0 Reputation points
1 answer

How to get a date of day in current week

Hi, I have table that stores configurations like In my sql code, I need to take currentDateTime and get current week date for Execution Day which is Wednesday. So, for this week, it will be 10-02-2024. Get following week wednesday date. Here it…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 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.
97 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,636 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.
13,771 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.
97 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,636 questions
asked 2024-10-02T17:24:40.53+00:00
Spunny 326 Reputation points
edited an answer 2024-10-03T13:26:55.7633333+00:00
Rodger Kong 90 Reputation points
1 answer

How to get a date of day in current week

Hi, I have table that stores configurations like In my sql code, I need to take currentDateTime and get current week date for Execution Day which is Wednesday. So, for this week, it will be 10-02-2024. Get following week wednesday date. Here it…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,771 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.
97 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,636 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.
13,771 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.
97 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,636 questions
asked 2024-10-02T17:24:40.53+00:00
Spunny 326 Reputation points
edited an answer 2024-10-03T13:26:55.7633333+00:00
Rodger Kong 90 Reputation points
1 answer

Error while running .dtsx package in development server

Hi Team, I have six .dtsx packages. The packages read flat files and insert the data from the flat files into the database tables. I reset the password of the DB account(account name , say VISH) in the DB server. After resetting, I cloned the MyAppETL…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,576 questions
asked 2024-09-29T08:59:20.51+00:00
Vishnu Narayan 0 Reputation points
edited a comment 2024-10-03T11:01:09.7933333+00:00
Vishnu Narayan 0 Reputation points
0 answers

Api-Web app (webjobs) connection to On-Premise SQL Connection

Hi , I am having trouble establishing connection from azure webapp to on-premise sql server. we have virtual network gateway and site-site vpn to sql server. allowed port 1433 in on-premise firewall and in azure firewall as well. webapp have private…

Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,527 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.
13,771 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
925 questions
asked 2024-10-02T22:17:03.1433333+00:00
kvidhul-3447 20 Reputation points
edited a comment 2024-10-03T10:41:11.56+00:00
kvidhul-3447 20 Reputation points
1 answer

Razor core app connects to DB, but integration test fails with Microsoft.Data.SqlClient.SqlException

I have an app that I've been writing and its working well. When I introduced an integration test, its unable to connect to the DB using the exact same connection string. Microsoft.Data.SqlClient.SqlException: 'A network-related or instance-specific…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,099 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.
13,771 questions
asked 2024-09-28T14:36:46.4833333+00:00
Walter 1 Reputation point
edited the question 2024-10-03T09:20:34.05+00:00
Jack J Jun 24,491 Reputation points Microsoft Vendor