20,352 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

SQL Server Limitations that aren't Solved

I use Sql Server 2022. I'm running Select queries using hundreds of words, and I need to know, for each matching record, which words were found. After running the Select query, I now have to run hundreds of searches for each word in each record, and…

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.
174 questions
asked 2025-04-23T23:52:20.8133333+00:00
Central data 156 Reputation points
commented 2025-04-25T13:49:14.6433333+00:00
Yitzhak Khabinsky 26,486 Reputation points
2 answers

MSSQL Windows Server Failover Cluster - Cluster IP address already in use

Hello, I have a cluster named "ClusterMain" that contains three nodes: N1, N2, and N3. Everything was working fine until N3 suddenly started misbehaving and became isolated from the cluster. Currently, N1 and N2 are functioning normally within…

SQL Server Database Engine
asked 2025-04-23T20:26:47.6466667+00:00
Quadra 0 Reputation points
answered 2025-04-25T12:49:34.7333333+00:00
Quadra 0 Reputation points
0 answers

The specified service does not exist as an installed service- SQL Server 2022

Hi I am trying to install SQL server 2022 and getting the error pop up: "The specified service does not exist as an installed service". Any solutions please let me know. I have also attached the screenshot of error and Detail.txt file from log…

SQL Server Database Engine
asked 2025-04-25T09:44:10.43+00:00
sudheer 0 Reputation points
edited the question 2025-04-25T09:53:26.97+00:00
sudheer 0 Reputation points
1 answer

Issue to restore the schema

Dear all, How to resolve it below? Exclusive access could not be obtained because the database is in use. I ran the following     USE db_to_restore       go       ALTER DATABASE db_to_restore SET SINGLE_USER WITH ROLLBACK IMMEDIATE       go   but it…

SQL Server Database Engine
asked 2025-04-25T03:14:41.97+00:00
Peter_1985 2,731 Reputation points
edited a comment 2025-04-25T09:21:34.08+00:00
Peter_1985 2,731 Reputation points
1 answer

Third party backup tools for SQL server

Anyone please share a few names of good and faster backup tools for SQL server? Preferably a snapshot of physical file backup It is for stand-alone server and should support VM too.

SQL Server Database Engine
asked 2025-04-24T18:18:03.1466667+00:00
Asharaf Pattarathil 0 Reputation points
answered 2025-04-25T09:09:59.9866667+00:00
Olaf Helper 46,551 Reputation points
1 answer

XTP_THREAD_POOL- lot of spids running in background when no sql workload is there.

In our L&P systems, before the actual run kickoffs we have a SOP to run rebuild indices and update statistics job. Recently we are seeing SQL memory consumption is great than 80 % even after the above jobs get completed and there is no SQL workload…

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,494 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,705 questions
asked 2021-07-09T04:26:29.84+00:00
Sreeni G 1 Reputation point
commented 2025-04-25T09:03:28.1566667+00:00
Ilya 0 Reputation points
1 answer

I'm seeing 137 XTP_THREAD_POOL processes on a VM with 16 cores. Why?

When I run sp_who2, I am seeing 137 XTP_THREAD_POOL processes on an Windows 2019 Server VM with a 2.3GHz 16 core / 32 vCPU with 128GB RAM. Why am I seeing so many of these processes? We have several other similar VMs and don't see the same thing.

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,494 questions
asked 2021-05-14T16:02:58.587+00:00
Michael MacGregor 86 Reputation points
commented 2025-04-25T09:02:56.95+00:00
Ilya 0 Reputation points
1 answer

Cannot figure out why I'm getting this error: Msg 102, Level 15, State 1, Line 74 Incorrect syntax near ')'

Pretty new to SQL, I keep getting an error on the final bracket at the end of the code, but I can't figure it out. Anyone see any reasons? ;with cte as ( SELECT SampleID ,SetpointID ,CDPercentDiff ,AuditID ,pointrn = ROW_NUMBER() OVER…

SQL Server Database Engine
asked 2025-04-24T21:13:12.1866667+00:00
FSI 0 Reputation points
commented 2025-04-25T00:44:18.3033333+00:00
David Fouché 0 Reputation points
3 answers One of the answers was accepted by the question author.

Small Dialog boxes in SQL Server Management Studio (SSMS) 18.9.2

After installing SSMS 18.9.2 on SQL 2016 server (Windows Server 2016) all dialogs of SSMS contain very small fonts...in some cases the fonts are so small that the slider bar covers up all text (i.e. Help-->About). Is there a way to have the dialogs…

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,494 questions
asked 2021-12-11T16:23:24.11+00:00
Wade Nederveld 26 Reputation points
edited a comment 2025-04-24T17:02:54.96+00:00
Louie C 0 Reputation points
3 answers

SSMS does not support <Ctrl>E for Execute any more

My SQL Server Management Studio 21.1 does not recognise single key commands such as <Ctrl>E (execute) or <Ctrl>R (show/hide result pane) I had first installed SSMS 21.1 and something happened after a few days so that when I started SSMS.exe…

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,494 questions
asked 2024-06-12T20:10:41.1033333+00:00
Eric Mamet 365 111 Reputation points
commented 2025-04-24T15:25:35.8966667+00:00
AbG3 1 Reputation point
0 answers

How to migrate large tables of size around 30gb from sql server 2014 to sql server 2022?

Hi , what would be the best way to migrate table of size 30 GB from sql server 2014 to sql server 2022?

SQL Server Database Engine
asked 2025-04-22T18:29:14.89+00:00
Kumari, Dimpy 0 Reputation points
commented 2025-04-24T14:36:17.25+00:00
Kumari, Dimpy 0 Reputation points
1 answer

MS SQL Installation error - The mof compiler could not connect with the wmi server

I tried to reinstall MS SQL 2022 server but I am facing the below error. title: microsoft sql server 2022 setup ------------------------------ the following error has occurred: the mof compiler could not connect with the wmi server. this is either…

SQL Server Database Engine
asked 2025-04-24T08:39:26.18+00:00
Rabin Mahato 0 Reputation points
answered 2025-04-24T14:08:43.8666667+00:00
Shubham Yadav 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,338 questions
asked 2021-09-23T02:32:42.227+00:00
ismepopola 76 Reputation points
commented 2025-04-24T13:08:11.2833333+00:00
Michael Bartlett 0 Reputation points
2 answers One of the answers was accepted by the question author.

How to recover the deleted Mysql resource database

Restore the deleted resource Mysql database backup ,i can't find the deleted resource in the deleted resource list , it was deleted accidently few hours before only

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.
3,037 questions
asked 2025-04-24T03:59:53.4633333+00:00
Lavanya Yatin 20 Reputation points
commented 2025-04-24T12:06:48.9133333+00:00
Shikha Ghildiyal 4,865 Reputation points Microsoft Employee
0 answers

WSFC Issues with Node failing Over but the Roles stay on the old primary

Hi Hope someone can help me out here, last couple of nights our WSFC has failed over, The servers have not been restarted but the Primary Node failed over to the Secondary node, though none of the Availability Groups moved with the failover, all the…

SQL Server Database Engine
asked 2025-04-24T08:30:40.1133333+00:00
Clive Wightman 146 Reputation points
2 answers

Errors to run some custom reports after migration

Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type…

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.
3,037 questions
Microsoft Configuration Manager
asked 2023-11-21T16:42:52.0966667+00:00
Claudio Santini 0 Reputation points
commented 2025-04-24T06:29:34.85+00:00
Filip Aiello 0 Reputation points
1 answer

SQL Server Installation

I am not able to Install the SQL Server on my laptop, i have been trying since last 3days. all times there are showing common errors Please help me out

SQL Server Database Engine
asked 2025-04-23T17:11:58.24+00:00
Shanmukha Rao Chintada 0 Reputation points
answered 2025-04-24T06:25:34.2566667+00:00
Olaf Helper 46,551 Reputation points
1 answer

Query related to length in CAST and Output clause

Hi Team, Could you please reply to below queries - Using CAST, I need to convert BigInt and Datetime2 values to Varchar. How could I be sure on the length that I need to use (in CAST) to convert these values to Varchar. I am using Update statement…

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.
174 questions
asked 2025-04-22T18:21:46.98+00:00
Salil Singh 40 Reputation points
answered 2025-04-24T06:20:32.56+00:00
Olaf Helper 46,551 Reputation points
1 answer

BCP OUT/IN, What is native format and its usage. I am planning to use BCP out/in to export & Import table data from source to target and would like to know which is the best option when my data contains special character inside it and also have some email

BCP native format when to use when not to use. Is there any alternative BCP utility to export and import data from source to target table

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.
174 questions
asked 2025-04-24T05:15:22.5166667+00:00
C, Manoharan (Cognizant) 40 Reputation points
answered 2025-04-24T06:12:34.9+00:00
Olaf Helper 46,551 Reputation points
2 answers One of the answers was accepted by the question author.

Can I convert a database field from binary to a PDF file in SQL Server?

I have a SQL Server database in which there are PDF documents stored in a column with the binary data type. I need to figure out how to get the actual PDF document out.

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,494 questions
asked 2023-06-23T17:56:16.4533333+00:00
Romelfanger, Matt 20 Reputation points
commented 2025-04-23T23:46:34.4166667+00:00
J Gonzalez 46 Reputation points