7,066 questions with SQL Server-related tags

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

Why is this query not a parallel plan

为什么不并行.xml The max degree of parallelism of an instance is 0 and the cost threshold for parallelism is 5. print @@VERSION： Microsoft SQL Server 2019 (RTM-CU27-GDR) (KB5040948) - 15.0.4382.1 (X64) Jul 1 2024 20:03:23 Copyright (C) 2019 Microsoft…

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,785 questions
asked 2024-09-10T09:31:46.64+00:00
博雄 胡 475 Reputation points
commented 2024-09-13T02:00:23.8+00:00
博雄 胡 475 Reputation points
1 answer One of the answers was accepted by the question author.

Removing old SQL Backups in Azure Storage

We used to use a maintenance plan to cleanup old SQL backups onprem. We are testing backing up to an Azure storage account. It does not appear the maintenance plan can access an URL location. Is this correct? If so, what is the best way to address this?

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,149 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,785 questions
asked 2024-09-07T17:59:58.7733333+00:00
rr-4098 1,481 Reputation points
accepted 2024-09-12T17:51:15.73+00:00
rr-4098 1,481 Reputation points
4 answers One of the answers was accepted by the question author.

Download link for Microsoft.ACE.OLEDB.12.0

We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required

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,785 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 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,785 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 25 Reputation points
commented 2024-09-12T14:56:18.13+00:00
Paul Wright 0 Reputation points
4 answers One of the answers was accepted by the question author.

Download link for Microsoft.ACE.OLEDB.12.0

We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required

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,785 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 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,785 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 25 Reputation points
commented 2024-09-12T14:56:18.13+00:00
Paul Wright 0 Reputation points
2 answers One of the answers was accepted by the question author.

Purpose of Schema

What is the purpose of schema? I am a BA like to be more technically knowledgeable.

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,785 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,637 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,785 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,637 questions
asked 2024-09-11T15:07:16.7566667+00:00
Jonathan Brotto 420 Reputation points
accepted 2024-09-12T13:11:16.5966667+00:00
Jonathan Brotto 420 Reputation points
2 answers One of the answers was accepted by the question author.

Purpose of Schema

What is the purpose of schema? I am a BA like to be more technically knowledgeable.

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,785 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,637 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,785 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,637 questions
asked 2024-09-11T15:07:16.7566667+00:00
Jonathan Brotto 420 Reputation points
accepted 2024-09-12T13:11:16.5966667+00:00
Jonathan Brotto 420 Reputation points
3 answers One of the answers was accepted by the question author.

Can I still install SQL Azure Connect Pack + GDR version 13.0.7037.1 after I used SQL SP3 + GDR version 13.0.6441.1?

I was tasked to update all SQL 2016 servers to its latest CU update at that month (August) due to identified critical vulnerabilities CVE/CVSS . Our SQL servers have different versions from RTM to SP3. Problem is I used a different patch which is SP3 +…

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,785 questions
asked 2024-09-11T05:01:42.8066667+00:00
Rambo1925 20 Reputation points
commented 2024-09-12T03:00:24.9666667+00:00
CathyJi-MSFT 22,201 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Can SQL Server 2022 Standard be activated offline?

I have to upgrade SQL Server 2022 Express to Standard, but I am worried about license activation because the computer has to stay offline. Is it possible? Does it need a special program to do 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,785 questions
asked 2024-09-11T10:37:00.2833333+00:00
Arkadiusz Dudziak 20 Reputation points
accepted 2024-09-11T11:13:17.05+00:00
Arkadiusz Dudziak 20 Reputation points
2 answers One of the answers was accepted by the question author.

SQL job showing failed even after doing its job

SQL job showing failed even after doing its job. The sql job is doing its job however at the end shows failure. Getting below message in error logs. Date 9/10/2024 8:57:21 AM Log Job History (ABC) Step ID Server 123 Job Name ABC Step…

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,785 questions
asked 2024-09-10T07:29:01.0266667+00:00
PUSHPENDER PATWAL 20 Reputation points
accepted 2024-09-11T06:50:10.6833333+00:00
PUSHPENDER PATWAL 20 Reputation points
1 answer One of the answers was accepted by the question author.

Azure SQL connectivity

Hello, we have Azure SQL service DB and are having some problems with connectivity which can't really pinpoint. From some places, it refuses connection. Like from my home, i try to connect using SQLAlchemy library in python but fails with timeout error…

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,785 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,680 questions
asked 2024-09-10T12:15:50.8333333+00:00
Python Developer 7 85 Reputation points
accepted 2024-09-11T06:02:43.6733333+00:00
Python Developer 7 85 Reputation points
1 answer One of the answers was accepted by the question author.

how do i know if microsoft ODBC Driver 13 for SQL Server is running TLS 1.2 or higher

how do i know if microsoft ODBC Driver 13 for SQL Server is running TLS 1.2 or higher

Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,577 questions
asked 2024-09-10T14:48:45.86+00:00
Tom Seabrooke 20 Reputation points
accepted 2024-09-10T23:55:06.9633333+00:00
Tom Seabrooke 20 Reputation points
2 answers One of the answers was accepted by the question author.

What would be the best asp.net option that allows a SQL database and communicates with a .NET MAUI frontend?

I am currently working on designing a cross platform application with .NET MAUI. I've decided to migrate my previous database to a SQL database. Looking at the Microsoft documentation, it showed the asp.net core web MVC project as the standard for using…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,553 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,785 questions
.NET MAUI
.NET MAUI
A Microsoft open-source framework for building native device applications spanning mobile, tablet, and desktop.
3,486 questions
asked 2024-09-08T23:12:50.52+00:00
Anis Redmond 20 Reputation points
accepted 2024-09-10T21:40:17.7233333+00:00
Anis Redmond 20 Reputation points
3 answers One of the answers was accepted by the question author.

Error when trying to delete SQL Server and SSMS

Since i created 4 instances of the database engine, I decided to delete 3 of them since they are redundant to me. I could not delete them since i have already deleted related files to them and the automatic deletion could not work. After that i deleted…

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,785 questions
asked 2024-09-10T06:14:27.65+00:00
Georgi Atanasov 20 Reputation points
commented 2024-09-10T17:27:45.04+00:00
Georgi Atanasov 20 Reputation points
2 answers One of the answers was accepted by the question author.

Cannot install SQL server 2022 in windows 11

I bought a new surface pro 11 and trying to install sql server. But I cannot instal SQL server 2022 in Windows 11. It is getting me error as below: Detailed results: Feature: Full-Text and Semantic Extractions for Search Status:…

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,785 questions
asked 2024-09-04T21:05:52.41+00:00
Manswab Nechiyil 20 Reputation points
accepted 2024-09-10T07:16:12.23+00:00
Manswab Nechiyil 20 Reputation points
1 answer One of the answers was accepted by the question author.

microsoft analysis services projects download but not showing in Download Folder

Hi, Hope everyone is doing well. When I trying to download and install Microsoft Analysis Service (SSAS) from Visual Studio. I am not able to see in download folder after downloading the software. How can I Instal SSAS? I have already SSIS in my system.

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,282 questions
asked 2024-09-08T13:18:32.93+00:00
Ramana Kopparapu 306 Reputation points
accepted 2024-09-10T06:40:18.75+00:00
Ramana Kopparapu 306 Reputation points
3 answers One of the answers was accepted by the question author.

How to write/read comma-separated data from an SQL table and load them into a datagridview column?

I want to write comma-separated string values entered in a text box to an SQL table and later fetch them from the table and load them into a data grid view column.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,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.
13,785 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,723 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
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,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.
13,785 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,723 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
asked 2024-09-07T16:06:21.0566667+00:00
Priyantha Niroshan 41 Reputation points
commented 2024-09-10T03:02:23.4266667+00:00
Priyantha Niroshan 41 Reputation points
3 answers One of the answers was accepted by the question author.

How to write/read comma-separated data from an SQL table and load them into a datagridview column?

I want to write comma-separated string values entered in a text box to an SQL table and later fetch them from the table and load them into a data grid view column.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,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.
13,785 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,723 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
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,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.
13,785 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,723 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
asked 2024-09-07T16:06:21.0566667+00:00
Priyantha Niroshan 41 Reputation points
commented 2024-09-10T03:02:23.4266667+00:00
Priyantha Niroshan 41 Reputation points
1 answer One of the answers was accepted by the question author.

Which dot net frame is used by SQL server 2016 SSIS packages

Which dot net frame is used by SQL server 2016 SSIS packages

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
532 questions
asked 2024-09-09T14:23:34.13+00:00
Kallavi, Vasudeva Gururaja 20 Reputation points
accepted 2024-09-09T20:10:19.57+00:00
Kallavi, Vasudeva Gururaja 20 Reputation points
2 answers One of the answers was accepted by the question author.

SSMS Error with Create Credential in Maintenance Plan

I was able to backup an onprem SQL DB to an Entra Storage account without issue. The problem is when I try to backup the DB using a maintenance plan I get the error below. I have been reading how to resolve this online and have already tried upgrading to…

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,785 questions
asked 2024-08-28T19:43:09.02+00:00
rr-4098 1,481 Reputation points
accepted 2024-09-09T16:10:47.7133333+00:00
rr-4098 1,481 Reputation points
1 answer One of the answers was accepted by the question author.

SSRS 2019 installation

I need to install and run SSRS 2019 from Azure VM. Database Engine is a SQL Managed Instance for ReportServer and ReportServer_Tempdb. VM and SQL MI are located in same region on same Vnet. Where do I get the product key from SQL MI to complete a…

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,785 questions
asked 2024-09-05T20:19:54.0566667+00:00
Charles Dove 20 Reputation points
commented 2024-09-09T15:09:16.19+00:00
Mahesh Kurva 240 Reputation points Microsoft Vendor