19,582 questions with SQL Server-related tags

Sort by: Updated
5 answers

Query store STALE_QUERY_THRESHOLD_DAYS and SIZE_BASED_CLEANUP_MODE

If I have a query store setting STALE_QUERY_THRESHOLD_DAYS 30 days SIZE_BASED_CLEANUP_MODE 100MB suppose there are 30 days query already inside the query store and used up 50MB only , and after 10 days the size reach to 60MB , will…

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,114 questions
asked 2021-02-19T04:56:40.273+00:00
sakuraime 2,331 Reputation points
answered 2024-12-01T07:47:01.9366667+00:00
Raghs 0 Reputation points Microsoft Employee
0 answers

SQLServer2022-x64-ENU installation error in windows 10

SQLServer2022-x64-ENU

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,114 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,950 questions
SQL Server Open Specifications
SQL Server Open Specifications
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
3 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,666 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
16 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.
14,114 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,950 questions
SQL Server Open Specifications
SQL Server Open Specifications
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
3 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,666 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
16 questions
asked 2024-12-01T04:33:48.34+00:00
bhaskar naidu 0 Reputation points
0 answers

SQLServer2022-x64-ENU installation error in windows 10

SQLServer2022-x64-ENU

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,114 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,950 questions
SQL Server Open Specifications
SQL Server Open Specifications
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
3 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,666 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
16 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.
14,114 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,950 questions
SQL Server Open Specifications
SQL Server Open Specifications
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Open Specifications: Technical documents for protocols, computer languages, standards support, and data portability. The goal with Open Specifications is to help developers open new opportunities to interoperate with Windows, SQL, Office, and SharePoint.
3 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,666 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
16 questions
asked 2024-12-01T04:33:48.34+00:00
bhaskar naidu 0 Reputation points
4 answers One of the answers was accepted by the question author.

how to change tabular mode to multidimensional model?

Hi there, I am trying to deploy multidimensional project to sql server and get an error. I was installed a tabular database. How to change tabular to multidimensional? Or I need to reinstall SSAS?

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,294 questions
asked 2021-09-23T02:32:42.227+00:00
ismepopola 76 Reputation points
answered 2024-12-01T01:55:58.1766667+00:00
Paul Garnes 0 Reputation points
0 answers

how to slove this problem??

what is this problem? How to slove this problem. so i can't unistall this pogram .give me solution.

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,114 questions
asked 2024-12-01T01:21:08.15+00:00
Arosha mahagedara 0 Reputation points
2 answers One of the answers was accepted by the question author.

Create JSON file and import as a table

Hi, This should be simple, but I tried various options and can not get it to work. I'm trying the following: SELECT TOP (100) ADMIN_AUDIT.admin_audit_id AS [id] , ADMIN_AUDIT.admin_audit_dttm AS [time] , ADMIN_AUDIT.process_txt AS…

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,114 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,666 questions
asked 2024-11-27T21:12:31.1+00:00
Naomi Nosonovsky 7,971 Reputation points
accepted 2024-12-01T00:27:07.44+00:00
Naomi Nosonovsky 7,971 Reputation points
1 answer

i am getting this error

please give me some solution for SqlConnection, SqlCommand and Clear ()

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,962 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,662 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,532 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.
14,114 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,748 questions
asked 2024-11-30T11:08:29.9066667+00:00
sayali dhanawade 20 Reputation points
commented 2024-11-30T22:10:24.8833333+00:00
SurferOnWww 3,376 Reputation points
4 answers One of the answers was accepted by the question author.

Azure Backup install fails with a SQL Server installation failed.

Exit error message: The /IACKNOWLEDGEENTCALLIMITS command line parameter is missing or has not been set to true. An Enterprise Server/CAL license product key (as opposed to Enterprise Core) was entered, and this computer has greater than 20 physical…

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,114 questions
asked 2024-08-22T21:01:36.3666667+00:00
Sam Albright 40 Reputation points
answered 2024-11-30T21:55:58.7066667+00:00
Kevin L Holland 0 Reputation points
0 answers

SQL SERVER unable to install error code Decimal: -2068052377

Hey there, I am having a hard time with installing SQL server. I had it installed on my computer previously, however I couldn't get the program to do what I needed it to do. I chalked it up to installation error. I uninstalled the program and tried 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.
14,114 questions
asked 2024-11-30T18:49:59.3033333+00:00
Stone, Ashton Skye 0 Reputation points
commented 2024-11-30T19:38:02.1666667+00:00
Erland Sommarskog 113.2K Reputation points MVP
1 answer

Install Sql Server 2019/2022 in Amazon Linux 2023 server.

Hello, I was trying to install mssql in Amazon Linux 2023 server, unfortunately while installing itself getting some exception. Seems like sql 2019 has a dependency with python2 and compat-openssl10 packages. But Amazon Linus 2023 images removed python2…

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,114 questions
asked 2024-11-30T15:50:24.5266667+00:00
George, Jijo 0 Reputation points
commented 2024-11-30T18:35:25.2366667+00:00
Erland Sommarskog 113.2K Reputation points MVP
1 answer

SQL DB Backup issue

I am using FortiClient VPN for accessing SQL DB. When trying to back up an Azure SQL Database using SQL Server Management Studio (SSMS) the backup option is not showing. So, I have used Export Data-tier Application option in the Tasks menu. Now getting…

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,114 questions
Windows Server Backup
Windows Server Backup
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Backup: A duplicate copy of a program, a disk, or data, made either for archiving purposes or for safeguarding valuable files from loss should the active copy be damaged or destroyed.
480 questions
asked 2024-11-27T07:51:42.7566667+00:00
Mohana Reddy 20 Reputation points
accepted 2024-11-30T13:07:07.41+00:00
Mohana Reddy 20 Reputation points
1 answer

SQL server instance by Azure ARC

Hi, I installed azure arc on Windows server on prem. I used the script generated by AZURE ARC RESOURCES - ADD MACHINE. The purpose is to install AMA for monitoring and create DCR on my workspace Sentinel. The questione Is: On azure arc resources in…

Azure Monitor
Azure Monitor
An Azure service that is used to collect, analyze, and act on telemetry data from Azure and on-premises environments.
3,353 questions
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
449 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.
14,114 questions
asked 2024-11-29T23:29:53.71+00:00
Blix 0 Reputation points
answered 2024-11-30T10:16:02.8033333+00:00
Erland Sommarskog 113.2K Reputation points MVP
4 answers

RDS 2016 Connection broker SQL DB - Transaction log growth

Hi, Every so often (still unsure what triggers it) we start to see huge growth in the transaction log size on the SQL (Always on Availability Group) DB for the RDS Connection brokers. Has anyone come across this before? Rebooting the brokers seems 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.
14,114 questions
asked 2020-08-05T09:10:38.227+00:00
Rob Cresswell 1 Reputation point
edited the question 2024-11-30T00:58:04.05+00:00
TP 100K Reputation points
1 answer

My SQL Server resource on Azure Portal is disabled

I wanted to login into my SQL Server using SSMS and the connection completely failed, I checked the Azure Portal and I found out on my SQL Server resource that in Overview tab is a Header orange high alert, called Disabled. I connected with success on…

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,114 questions
asked 2024-11-28T13:50:36.19+00:00
Gabriel Balinisteanu 0 Reputation points
commented 2024-11-29T22:31:09.18+00:00
Erland Sommarskog 113.2K Reputation points MVP
2 answers

SQL server doesn't implicitly cast from VARCHAR to FLOAT in some scenarios

Update: I have pasted the actual image here instead of the link. --This works fine DECLARE @sampleVar FLOAT = '123.034'; SELECT @sampleVar ; --This throws error SELECT '123.034'*-1; When I try to do the above, I notice that the implicit CAST is…

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,114 questions
asked 2024-11-26T14:19:29.5566667+00:00
Nandu S Raj 40 Reputation points
commented 2024-11-29T22:23:42.5733333+00:00
Erland Sommarskog 113.2K Reputation points MVP
2 answers

Corrupted Source Data Issue in SSIS 4.6 with Excel Source via Data Flows in VS 2019

Using SSIS 4.6 on VS 2019, with an Excel (Prof Plus 2016) Data Source, and I have a Package with 6 Data Flows that run consecutively, each one will access a different sheet from the same Excel Workbook. The Destination is a SQL Server 2022. If we use…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,606 questions
asked 2024-11-26T17:40:53.01+00:00
Adel Mansour 0 Reputation points
answered 2024-11-29T22:19:21.86+00:00
Adel Mansour 0 Reputation points
2 answers

Embed SSRS rdl Reports to an existing ASP.NET application

I have a project scenario that requires embedding SSRS rdl Reports to an existing ASP.NET Core application. I have made some research prior to posting here and I came across a library called ReportViewer, was able to get some results but only showed one…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,662 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,532 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.
14,114 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,950 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,088 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,662 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,532 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.
14,114 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,950 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,088 questions
asked 2022-05-19T14:51:39.307+00:00
Dervishi, Erald 66 Reputation points
answered 2024-11-29T18:16:47.65+00:00
Md. Sakibur Rahman 0 Reputation points
2 answers

Embed SSRS rdl Reports to an existing ASP.NET application

I have a project scenario that requires embedding SSRS rdl Reports to an existing ASP.NET Core application. I have made some research prior to posting here and I came across a library called ReportViewer, was able to get some results but only showed one…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,662 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,532 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.
14,114 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,950 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,088 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,662 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,532 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.
14,114 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,950 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,088 questions
asked 2022-05-19T14:51:39.307+00:00
Dervishi, Erald 66 Reputation points
answered 2024-11-29T18:16:47.65+00:00
Md. Sakibur Rahman 0 Reputation points
1 answer One of the answers was accepted by the question author.

The study of SQL Server began from the documentation and its correct order

Hello, I wanted to learn SQL Server from the documents, but when I entered to start, I did not know when I entered a specific arrangement at the beginning that explains things to me that I did not begin with. So please tell me whether it is from 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,114 questions
asked 2024-11-29T14:36:03.44+00:00
MOATHRAGAB 20 Reputation points
accepted 2024-11-29T17:21:12.59+00:00
MOATHRAGAB 20 Reputation points
1 answer

Is it possible to connect Azure Search Service to Local "OnPrem" SQL database

I've been trying to find information on how to connect Azure Search Service to a local SQL database, but I'm still not finding what I need. As the title says, I want to connect Azure Search directly to my local database so I can search the information in…

Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
1,091 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.
14,114 questions
asked 2024-11-29T13:26:52.57+00:00
Johan Ögren 20 Reputation points
answered 2024-11-29T14:47:47.2066667+00:00
Laxman Reddy Revuri 875 Reputation points Microsoft Vendor