19,957 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers One of the answers was accepted by the question author.

Scalability LEFT JOIN vs MERGE

Hi there, I'm UPSERTING AND handling 70 + millions of rows of UPSERT. I'm the only developer on the DB. GP_Gen5_6 LEFT JOIN DURING UNIT TEST OF ALL RECORDS 12 mins SCALED UP OVERNIGHT PROCESS GP_Gen5_20 History of existing MERGE process same operation…

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.
14,417 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,688 questions
asked 2025-01-28T17:04:24.43+00:00
RJ 286 Reputation points
edited the question 2025-02-05T01:23:44.56+00:00
ZoeHui-MSFT 40,131 Reputation points
1 answer One of the answers was accepted by the question author.

ADF - CSV file with more than 2000 columns, need to create multiple tables in the sqlserver using Azure Data factory

I have csv file with more than 2000 columns and 20gb file size. Have to create multiple tables in sqlserver from the csv file using Azure Data factory. here is the file columns col1 col2 col3 col4 col5 col5 ...... i have to create tables with below…

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,192 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
asked 2025-01-31T13:53:58.33+00:00
Anil 40 Reputation points
edited the question 2025-02-05T01:22:59.58+00:00
ZoeHui-MSFT 40,131 Reputation points
0 answers

SSAS Development How to fix "Cannot open BIM Model. Localhost server unreachable" ?

Hello everyone ! I've had a weird problem during the last couple of days. I downloaded a SSAS project from Azure to work on it with some people. I set it up to use "Integrated workspace", and I left everything else as default. The first time I…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
471 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,310 questions
asked 2025-02-04T10:14:50.5333333+00:00
D2d3d4d5 20 Reputation points
edited the question 2025-02-05T01:17:41.4566667+00:00
ZoeHui-MSFT 40,131 Reputation points
2 answers

SqlServer.ManagedDTS DLL Reference Error for Visual Studio 2019

Hello Everybody; Visual Studio 2019 Enterprise v16.11.15 Sql Server Integration services v3.16 I try to Load my DTSX Package as File from Framework C# solution. I add reference Microsoft.SqlServer.Dts.Runtime to my project throwing…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,268 questions
asked 2022-10-06T12:51:04.557+00:00
Kamel Jtita 1 Reputation point
commented 2025-02-05T00:13:38.2333333+00:00
Wendell Beverly 0 Reputation points
1 answer

Cleanup of stale DB entries skipped

I have log shipping enabled on a User Database and that database is also using memory optimized tables. It looks like the folder that contains the $HKv2 files on the secondary server are not being deleted after the restore of the log file on the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,417 questions
asked 2025-02-03T18:30:07.4333333+00:00
Kevin Howard 0 Reputation points
answered 2025-02-04T22:36:52.19+00:00
Erland Sommarskog 116.2K Reputation points MVP
1 answer One of the answers was accepted by the question author.

Unable to create a database in SQL Server | "The specified max size is invalid"

I am trying to create a database in SQL server under a subscription and its resource group through Python code, the response I get in the code is 202 but upon checking the logs, it shows failed. I am trying to copy the database from another sub and its…

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.
14,417 questions
asked 2024-10-13T13:01:06.8133333+00:00
NoobSlayer 25 Reputation points
commented 2025-02-04T22:28:53.8766667+00:00
frederico tereso 1 Reputation point
1 answer

Understand the backup and restore of Azure SQL Managed instances Logins

Hi Team, I want to do backup and restoration of SQL managed instances, Is there any way to migrates SQL logins and jobs too? Thanks Krupa G

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,417 questions
asked 2025-02-04T07:47:52.68+00:00
krupa gundraju 0 Reputation points
commented 2025-02-04T22:28:02.83+00:00
Erland Sommarskog 116.2K Reputation points MVP
1 answer

Unable to process the existing user settings and will overwrite the file with user settings from this session.

I have local install of sql server 2022, with Analysis server & MSRS features enabled, when I launch the management studio, I get the error message below, any suggestions on how to suppress the message ? Thanks Jay Unable to process the existing…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,417 questions
asked 2024-07-30T16:36:54.4966667+00:00
Jay Tabatabai 20 Reputation points
commented 2025-02-04T22:12:35.7966667+00:00
Erland Sommarskog 116.2K Reputation points MVP
3 answers

How granting the execute permission for several stored procedures - SQL Server 2019

Hi, in order to review some security aspects about a SQL Server 2019 instance I need to assign the execute permission for several stored procedures to a db_datareader and db_datawriter user without operating one by one. How could I accomplish a such…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,417 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,688 questions
asked 2025-02-03T08:18:41.0633333+00:00
pmscorca 1,007 Reputation points
commented 2025-02-04T22:09:15.4066667+00:00
Erland Sommarskog 116.2K Reputation points MVP
2 answers

I cant install SQL server express version

When running a basic installation i get "unable to install SQL server: exit code (decimal) - 2068052377 error description: invalid command line argument HEre is the summary.txt file: Overall summary: Final result: Failed: see…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,417 questions
asked 2025-02-03T10:16:40.0833333+00:00
Omid Zahidi 0 Reputation points
commented 2025-02-04T22:00:28.1133333+00:00
Erland Sommarskog 116.2K Reputation points MVP
3 answers One of the answers was accepted by the question author.

SPID -5 blocking everything.

SS 2022 CU 13 Greetings. Last weekend we moved to a new SQL server, and last night didnt go so well. When I logged in this morning we had LOTS of blocking from spid -5. I can't find much info on this but did find this link that shares this detail: In…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,417 questions
asked 2025-01-31T15:37:03.4666667+00:00
chrisrdba 451 Reputation points
commented 2025-02-04T21:57:17.3+00:00
Erland Sommarskog 116.2K Reputation points MVP
0 answers

Content of directory on path 'https://stsxxxxxwus01.dfs.core.windows.net/stsexxxxxxxc/production/xxxx xxxxx/xxxxxxx/d_xxxxx/_delta_log/*.*' cannot be listed.

I receive this error message intermittently when I run a query against a storage account from SSMS. It works most of the time but at certain times, it fails. I find it's been failing a lot more now than before and I know it's not a permissions-related…

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.
14,417 questions
asked 2025-01-27T14:10:19.1233333+00:00
Olujimi Adebiyi 0 Reputation points
commented 2025-02-04T18:28:40.03+00:00
Olujimi Adebiyi 0 Reputation points
2 answers

Can only select both tables filter direction in SSAS tabular

Hi, I use the same SQL server database to do an import in Power BI Desktop as for my model created in SSAS Tabular SQL Server 2019 with Visual Studio 2019. My issue is in the create relationships. In Power BI Desktop I can do: In Visual Studio I…

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,310 questions
asked 2023-05-16T14:16:56.12+00:00
Arjan Fraaij 0 Reputation points
commented 2025-02-04T16:32:03.5333333+00:00
Alex Martin 0 Reputation points
3 answers

Retrieving Admin Credentials for SQL Server Database Backup

Connecting to a database from SQL Server Management Studio with normal authentication is not allowing backup operations. An ex-employee who was the admin did not provide any credentials. As a result, backup cannot be taken, and attempts to assign roles…

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.
14,417 questions
asked 2025-01-06T04:56:22.5866667+00:00
Mohana Reddy 100 Reputation points
edited the question 2025-02-04T14:00:19.31+00:00
Mounika Reddy Anumandla 2,070 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

SSIS pkgs not showing

Hello, I migrated some SSIS packages from instance A to Instance B where SSIS catalog and SSISDB is already there. Now When i connect to SQL Server Instance B using Visual Studio, i cannot see the packges/projects... Or if connect to SSIS on instance…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
asked 2025-02-04T05:51:42.21+00:00
Bilal H. Bhatt 116 Reputation points
accepted 2025-02-04T10:07:37.8133333+00:00
Bilal H. Bhatt 116 Reputation points
2 answers

All access to tables wit columnstore wait for COLUMNSTORE_LOAD_METADATA

Hello We have an issue with one of ours SQL servers Each access to table with columnstore wait for COLUMNSTORE_LOAD_METADATA (about 2-3 sec) This server is 1 of very similar 15 servers with same configuration and same load I cannot find any explanation…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,417 questions
asked 2023-06-03T18:05:39.55+00:00
Yuri Gorelik 1 Reputation point
commented 2025-02-04T10:06:03.7366667+00:00
Idan Miller 0 Reputation points
0 answers

How to resolve data update issues with Microsoft SQL Server 2012 in an SAP application?

I am unable to update data on my SAP application due to an error related to Microsoft SQL Server 2012.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,417 questions
asked 2025-02-01T10:51:25.1533333+00:00
Meimei 0 Reputation points
commented 2025-02-04T09:10:10.9466667+00:00
NIKHILA NETHIKUNTA 4,430 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Unstand the migration strategy from Azure SQL Managed instances

Hi Team, Is there any way to migrate our SQL managed instances from one tenant to another tenant. Do we have any detailed documentation regarding this? We should be using azure native tools to perform this lift and shift activity, let us know the…

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.
14,417 questions
asked 2025-01-27T11:48:50.8833333+00:00
KrupaVani Gundraju 20 Reputation points
commented 2025-02-04T08:30:31.6233333+00:00
Sai Raghunadh M 2,230 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

ssis is missing

I can not find the SSIS toolbox option on my ssis project. Tried restarting VS and machine many times, pls help

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,641 questions
asked 2025-01-30T14:50:46.8+00:00
Sin X 40 Reputation points
accepted 2025-02-04T08:09:58.5733333+00:00
Sin X 40 Reputation points
2 answers One of the answers was accepted by the question author.

SSIS package failed to run

Fail to run the package from agent job. It said unexpected error. But when i run it in VS project it works.

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,988 questions
asked 2025-01-31T15:18:39.0033333+00:00
Sin X 40 Reputation points
accepted 2025-02-04T08:08:34.5933333+00:00
Sin X 40 Reputation points