19,094 questions with SQL Server-related tags

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

Queries in the same window for multiple databases, servers, and tables

I was wondering in SSMS in the query window could I write multiple queries that use different servers, databases, and tables? A compounded question and answer I am expecting for this.

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,690 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
38,800 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.
92 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,626 questions
asked 2024-09-16T13:02:52.5733333+00:00
Jonathan Brotto 400 Reputation points
answered 2024-09-16T21:45:55.07+00:00
Erland Sommarskog 110.4K Reputation points MVP
2 answers

SQL 2022 Timeout issues

We recently migrated our databases from SQL Server 2014 to SQL Server 2022 and have noticed sudden timeout issues occurring in the application, specifically with stored procedures containing SELECT queries in the SQL 2022 database. These timeouts 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,690 questions
asked 2024-09-12T06:13:58.0366667+00:00
MOHAMMED ILYAS 0 Reputation points
commented 2024-09-16T21:33:57.52+00:00
Erland Sommarskog 110.4K Reputation points MVP
1 answer

Performance degraded under 2000 records in SQL Server 2022 compare to SQL Server 2019

Hi, I have observed that bulk delete operation is having poor performance SQL Server 2022 SQL Server 2019 Number of records - array:10000000 Operation - DELETE Operation Delete Operation taken time is : 34703 ms SQL Server 2022 Number of records -…

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,690 questions
asked 2024-09-13T13:10:00.5833333+00:00
Badhe, Ganesh 60 Reputation points
commented 2024-09-16T20:39:28.4066667+00:00
Erland Sommarskog 110.4K Reputation points MVP
1 answer One of the answers was accepted by the question author.

Need help with proper step flow for putting a database into a Distributed AG

This is a bit long, but I want my explanation to be thorough. I'm trying to get a couple of large databases added to a new Distributed AG setup. The setup consists of 4 servers, 2 in each of 2 sites. The 2 servers in each site are contained in a Local AG…

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,690 questions
asked 2024-09-12T20:44:10.27+00:00
PrestonSheila-3467 20 Reputation points
accepted 2024-09-16T13:11:41.97+00:00
PrestonSheila-3467 20 Reputation points
1 answer

Blazor and SSRS/Report viewer

Hi, We are wondering, if it's possible to use Report Viewer (any Blazor components) or embed SSRS report (no IFrame) in Blazor. Is there such thing out there besides solutions like what Telerik or BoldReports provide? We're looking at a solution with…

Blazor
Blazor
A free and open-source web framework that enables developers to create web apps using C# and HTML being developed by Microsoft.
1,559 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,915 questions
asked 2021-07-13T16:49:46.907+00:00
Stéphane Roy 31 Reputation points
commented 2024-09-16T10:59:35.2066667+00:00
Kasim Husaini, FMIS Supervisor 6 Reputation points
1 answer

Azure SQL Session Limit Reached

This morning I started getting an error stating that the session limit for the database of 4800 has been reached and I can no longer log into SQL Server Management Studio and the databases I have created that access the Azure SQL Server bring up the same…

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,690 questions
asked 2024-09-11T15:18:33.6366667+00:00
Jason Evans 0 Reputation points
commented 2024-09-16T10:25:15.5666667+00:00
Mahesh Kurva 5 Reputation points Microsoft Vendor
6 answers

Debian 12 public key is not available

Trying to install mssql-tools, after registering the repository for Debian 12 (Docker image): RUN curl https://packages.microsoft.com/keys/microsoft.asc | tee /etc/apt/trusted.gpg.d/microsoft.asc && \ curl…

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,690 questions
asked 2023-07-12T09:52:33.2833333+00:00
Pablo Burgos 30 Reputation points
answered 2024-09-14T14:41:12.74+00:00
VICTOR ALEXIS BETTACHINI 1 Reputation point
2 answers

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,690 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.
112 questions
asked 2024-08-17T10:10:18.3266667+00:00
Maximilian Ksoll 0 Reputation points
commented 2024-09-14T10:50:03.3866667+00:00
Maximilian Ksoll 0 Reputation points
3 answers One of the answers was accepted by the question author.

Cannot connect to deskstop in sql serve

I cannot connect to desktop, so help me fix this 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,690 questions
asked 2024-09-13T09:16:50.13+00:00
võ thị tuyết ngân 20 Reputation points
accepted 2024-09-14T09:04:11.5+00:00
võ thị tuyết ngân 20 Reputation points
3 answers

default password of NT SERVICE/MSSSQLSERVER account

i want default password of NT SERVICE ACCOUNT of MSSQL 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.
13,690 questions
asked 2021-07-29T09:28:55.323+00:00
palani sam 1 Reputation point
commented 2024-09-14T07:17:29.2966667+00:00
PA 0 Reputation points
1 answer

Can I delete the RSTempfiles for microsoft report server?

There's and RSTempFiles folder on the report services server, that is taking up so much space. from my understanding and what others are saying. These are temporary files caused either by a report that's has a high number of requests. But we cannot…

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,915 questions
asked 2024-07-25T10:18:22.3766667+00:00
Kashupi, Tokolo (CGP-ITO) 20 Reputation points
answered 2024-09-14T06:52:41.1533333+00:00
Atif Sheikh 0 Reputation points
1 answer

How often does SQL Server contact the Azure Key Vault for a Certificate or Key?

I would like to use Azure Key Vault rather than Windows Store to store my SQL Server TDE Certificates/Keys, Server Certificates, and Always Encrypted Keys. However, I want to know how often the server connects to Azure Key Vault and polls the keys and…

Azure Key Vault
Azure Key Vault
An Azure service that is used to manage and protect cryptographic keys and other secrets used by cloud apps and services.
1,259 questions
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,690 questions
asked 2024-09-13T14:14:38.8433333+00:00
Wallace, Glenn 0 Reputation points
answered 2024-09-14T03:21:38.9166667+00:00
Sina Salam 10,176 Reputation points
1 answer

Database engine failed SQL Server 2022

Database engine failed to install. I have gone through all the solutions posted but nothing worked. find below my summary report: Overall summary: Final result: Failed: see details below Exit code (Decimal): -2147467259 …

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,690 questions
asked 2024-09-01T23:38:41.8366667+00:00
Chinedu Okechukwu 0 Reputation points
answered 2024-09-14T02:28:45.0966667+00:00
Hardikbhai Velani 75 Reputation points
1 answer

SET FMTONLY ON/OFF is deprecated according to the docs and should be replaced by sp_describe_first_result_set. But sp_describe_first_result_set returns 'incorrect syntax' message on correct queries. How to correctly migrate?

Using this simple table structure: CREATE TABLE Persoon_ ( ID INT, Adres NVARCHAR(50) ) CREATE TABLE Factuur_ ( ID INT, Debiteur INT, Persoon INT, Bedrijf INT, Derde INT ) CREATE TABLE Bedrijf_ ( ID INT, FactuurAdres NVARCHAR(50), …

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.
92 questions
asked 2024-09-13T08:32:03.4933333+00:00
Carta Online | Hans Wijntjes 0 Reputation points
answered 2024-09-13T22:09:54.04+00:00
Erland Sommarskog 110.4K Reputation points MVP
1 answer

How to hash a password in asp.net core and use it in a stored procedure

Hi there; There are a lot of examples of SQL stored procedures for User Validations (credential checks) but all of them the password is in text format which is bad security practice. The idea is to hash the password in the client side ( in this case is…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,526 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,690 questions
ASP.NET API
ASP.NET API
ASP.NET: A set of technologies in the .NET Framework for building web applications and XML web services.API: A software intermediary that allows two applications to interact with each other.
331 questions
asked 2024-09-12T16:57:36.7066667+00:00
Jose Daniel Navarro Brito 61 Reputation points
commented 2024-09-13T21:50:12.2766667+00:00
Greg Low 1,760 Reputation points Microsoft Regional Director
2 answers

Issue installing SQL Server 2022 Express

I am trying to install SQL Server 2022 Express. Whenever I go to run the installation, nothing happens after it prompts me for admin elevation. I checked Event Viewer and I saw this: Faulting application name: SQL2022-SSEI-Expr.exe, version:…

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,690 questions
asked 2024-09-05T14:08:49.4333333+00:00
RyanAE 5 Reputation points
commented 2024-09-13T20:54:20.8733333+00:00
Erland Sommarskog 110.4K Reputation points MVP
0 answers

Number of query values and destination fields are not the same

Hi All, I received the TXT files from my vendor every morning. My objective is to convert this TXT file into Excel (.xlsx) file for my internal customer. I would appreciate it if you can point me in the right direction to resolve the issue. Thank you; I…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,842 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,567 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.
10,858 questions
asked 2024-09-12T19:13:54.43+00:00
Douang Rintharamy 0 Reputation points
commented 2024-09-13T13:47:19.7866667+00:00
Yitzhak Khabinsky 25,851 Reputation points
1 answer One of the answers was accepted by the question author.

Is there any background round operation for floats?

select ceiling(1285.0992 / 1.94712) result for the query above is 660 but the query below gives 661 as a result. declare @var1 float = 1285.0992 declare @var2 float = 1.94712 select ceiling(@var1 / @var2) can anyone tell me how that 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.
13,690 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,626 questions
asked 2024-09-04T14:58:43.98+00:00
Yavuz RA 20 Reputation points
accepted 2024-09-13T13:28:09.2133333+00:00
Yavuz RA 20 Reputation points
1 answer

Host Restarts in Azure Function Triggered by EventHub, Causing Data Loss

Hello, I'm currently working with a ~v4 Azure Function running on Linux, implemented in python 3.9 (using v2 programming model), which is triggered by EventHub. The function processes incoming payloads, performs transformations, and writes the data into…

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,912 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
630 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,690 questions
asked 2024-09-11T09:51:55.3466667+00:00
Jusuf Ramic 0 Reputation points
commented 2024-09-13T13:22:20.29+00:00
Jusuf Ramic 0 Reputation points
0 answers

Cannot backup SQL server db with private endpoint link to azure blob storage

Hello, As I have mentioned on above title, we are trying to backup our database to blob storage using publicly available Runbook from run book gallery (Backup Azure SQL Databases to Blob storage Runbook by josegomera). We were able to get the backup up…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,795 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,690 questions
asked 2024-09-10T06:09:39.15+00:00
Kanishka Perera 0 Reputation points
commented 2024-09-13T11:54:39.6233333+00:00
Mahesh Kurva 5 Reputation points Microsoft Vendor