18,200 questions with SQL Server-related tags

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

SSMS hangs for an extended period when closing a query tab or object explorer when a connection cannot be established to the SQL Server

Suppose I am connected via VPN to a network that includes a SQL server. I then open SSMS and connect to that server. Eventually the VPN loses connection or I disconnected (work is finished for the day, whatever) I then attempt to close an SSMS…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,944 questions
asked 2022-03-15T17:09:44.58+00:00
allmhuran 136 Reputation points
commented 2024-05-31T22:37:54.5533333+00:00
Lynn Lahman 0 Reputation points
3 answers

Completely remove Ledger Table from Database

Is there a way how to completely remove Ledger table from a database and reclaim disk space? History table can take gigabytes, and I want to remove all the data related to some ledger table. Data and history. But I don't see how it can be done.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,944 questions
asked 2024-05-31T07:38:46.19+00:00
Oleg Gelya 0 Reputation points
answered 2024-05-31T21:23:10.2733333+00:00
Erland Sommarskog 1L Reputation points
1 answer

How to lock transactions that cannot be ended autonomously

An abnormal table lock was detected in the production environment. Tracking revealed a transaction that lasted for several hours, which was conspicuous in a production setting where transactions typically last no more than 30 seconds. Monitoring through…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,944 questions
asked 2024-05-31T09:06:33.96+00:00
博雄 胡 70 Reputation points
answered 2024-05-31T21:17:42.5066667+00:00
Erland Sommarskog 1L Reputation points
1 answer

Set up valuable Indexes on a table

I have a really big transaction table, billions of rows, and I need some kinds of Indexes to make it useful. Right now there is a clustred columnstore index on the table, and a nonclustred on ID, but I guess I need some nonclustred to make the 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.
52 questions
asked 2024-05-31T14:45:31.69+00:00
Fredrik M 146 Reputation points
answered 2024-05-31T21:10:03.6666667+00:00
Erland Sommarskog 1L Reputation points
1 answer

Typo on page

Hi, where do we give feedback for a typographical error on a MS Learn page? https://learn.microsoft.com/en-us/training/modules/sql-server-2022-performance-enhancements/3-memory-feedback-exercise Item 6. IsMemoryGrangFeedbackAdjusted should be…

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.
5 questions
asked 2024-05-31T19:07:21.7766667+00:00
Ric Oliva 0 Reputation points
answered 2024-05-31T21:02:26.81+00:00
Erland Sommarskog 1L Reputation points
4 answers One of the answers was accepted by the question author.

Hash table creation issue in Sql server

I have created hash table in outer procedure with 2 columns and trying to create another hash table with same name but 3 columns. Now if i try to insert into hash table in inner procedure i get error saying not able to access third column (which was not…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,944 questions
asked 2024-05-30T09:15:06.0866667+00:00
yashwin g shetty 40 Reputation points
commented 2024-05-31T20:54:17.3133333+00:00
Erland Sommarskog 1L Reputation points
2 answers

exit code (decimal): -2068052377error description: invalid command line argument. consult the window installer sdk for detailed command line help

This morning I was still able to use sql, I was curious and deleted something like SQLEXPRESS16, then I uninstalled all sql and reinstalled it all, and used quite a few cmd commands that I didn't know to uninstall but still nothing. I can't remove them,…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,944 questions
asked 2024-05-29T14:08:19.1766667+00:00
Dukanhh 0 Reputation points
commented 2024-05-31T20:51:30.3233333+00:00
Erland Sommarskog 1L Reputation points
3 answers

i have few snapshot transactions, now i need to put nolock/read uncommit for perticular table

hi, I have few snapshot transactions , now my admin has informed me that put no lock in all tables in snapshot transactions, as it was blocking locking deadlocking with others. so I suggested to put read uncommited instead of snapshot when u 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.
12,944 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2024-05-20T07:11:58.9+00:00
Rajesh Kumar Yadav 0 Reputation points
commented 2024-05-31T20:47:35.6666667+00:00
Erland Sommarskog 1L Reputation points
1 answer

Power BI Sources and Education

Just looking for some good Power BI resources and education materials...web sites...YouTubes And is there a separate Forum for Power BI? Because I cannot seem to tag anything with "Power BI" here. Thanks in advance for your review and help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,944 questions
asked 2024-05-31T14:03:29.1766667+00:00
Bobby P 221 Reputation points
edited a comment 2024-05-31T20:07:00.3966667+00:00
Ms Nischal Lata 0 Reputation points
1 answer

Buffer Cache and Buffer Pool

Hi, What is the difference between Buffer Cache and Buffer Pool?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,944 questions
asked 2024-05-31T14:24:27.79+00:00
Chaitanya Kiran 736 Reputation points
answered 2024-05-31T19:06:17.35+00:00
Olaf Helper 41,806 Reputation points
1 answer

SSISDB Project Deployment expired Certificates

We have hundreds of project deployment certificates that are expired, but I tried to find what is using them and am unable to. I tried dropping them, but it says they are in use. How do you figure out which project is using the certificates?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,473 questions
asked 2024-05-31T04:00:21.25+00:00
John Couch 21 Reputation points
commented 2024-05-31T19:02:20.0233333+00:00
Olaf Helper 41,806 Reputation points
1 answer

Compiling SSAS, SSRS, and SSIS projects under Build Tools for Visual Studio 2022?

I have a build server using Build Tools for Visual Studio 2022 to compile projects. We have several systems that are currently not using the build server because they use SSAS, SSRS, and SSIS projects. Investigating, it looks like Build Tools does not…

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,834 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,473 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,252 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
182 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
982 questions
asked 2024-05-31T14:54:04.85+00:00
Zarate, Martin 5 Reputation points
answered 2024-05-31T18:47:20.1833333+00:00
Olaf Helper 41,806 Reputation points
3 answers

Install SCOM 2022 on Windows Server 2022

Hi, I have evaluations of Windows Server 2022, SQL Server 2022 and SCOM 2022. I have a Windows Server VM on VMware Workstation. I want to install SCOM. I'm using this link…

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
863 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.
12,944 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,336 questions
asked 2024-05-30T21:27:08.9133333+00:00
Mike 2 20 Reputation points
answered 2024-05-31T18:13:54.1866667+00:00
Mike 2 20 Reputation points
0 answers

I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector

I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector & attaching the screenshot of the connector image. Compatibility level of the SSAS Tabular…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
440 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,252 questions
asked 2024-05-31T06:52:56.3233333+00:00
Aravind K Pachaiyappan 0 Reputation points
commented 2024-05-31T18:06:47.4266667+00:00
BhargavaGunnam-MSFT 27,976 Reputation points Microsoft Employee
2 answers

CPU used query return wrong result

Hi, After the CPU upgrade to 98 cores when I execute the query to find the sqlserver usage and system idle shows the result more than 100%. for example SQL Server process utilization - 20 System idle process - 89 The query which I used was Please help…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,944 questions
asked 2024-05-30T20:18:20.67+00:00
SVA 86 Reputation points
answered 2024-05-31T17:54:07.8133333+00:00
Olaf Helper 41,806 Reputation points
1 answer

Connecting Azure web app service (.net8) to SSRS on Azure VM by using private DNS

My azure web app service(.net8) connect to SSRS on VM by using the private DNS name provided by Azure to the VM, but my credentials did not work when I run the report on my azure web app server. The private DNS name works fine with my credentials via url…

SQL Server on Azure Virtual Machines
Azure DNS
Azure DNS
An Azure service that enables hosting Domain Name System (DNS) domains in Azure.
611 questions
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
474 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,834 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,067 questions
asked 2024-05-29T19:10:30.8133333+00:00
Billey 10 Reputation points
answered 2024-05-31T15:55:50.37+00:00
Chris Boyce 20 Reputation points
2 answers

Using SSDT on a build server

I need to use SSDT on my build server. What exactly do need to install to get it working? I have a docker image that does the builds. It's based on mcr.microsoft.com/dotnet/framework/sdk:4.8-20230110-windowsservercore-ltsc2019Ideally, it would be nice…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,944 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
982 questions
asked 2024-04-24T19:26:26.72+00:00
Mark DeMichele 0 Reputation points
commented 2024-05-31T14:44:49.1233333+00:00
Zarate, Martin 5 Reputation points
2 answers

How to solve this connection problem with OLEDB?

Well, I'm trying to create an OLE DB connection in Visual Studio (I'm studying ETL), I followed the installation and configuration steps in the video, but mine shows the following error message: The specified provider is not supported. Please choose…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,721 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,473 questions
asked 2023-05-09T17:27:07.5833333+00:00
Gabriel Pina 0 Reputation points
commented 2024-05-31T14:18:18.2+00:00
KUNCHALA HIMAKHAR 0 Reputation points
1 answer One of the answers was accepted by the question author.

Benefits of azure SQL server 2022 enterprise edition for SSRS and Power BI Reporting Server

I have azure SQL server 2022 enterprise edition, So can i use SSRS and power Report server as benefit or paid any extra charges. For SSRS and power bi report server installation time asking product key but SQL server 2022 not provide product key. How can…

Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,290 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,013 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.
12,944 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,834 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,252 questions
asked 2024-05-31T11:37:34.31+00:00
Dhumal, Dhairyashil 20 Reputation points
accepted 2024-05-31T13:36:31.31+00:00
Dhumal, Dhairyashil 20 Reputation points
1 answer

Errors on some reports after upgrading to16.0.8886.1775 (SQLServerReportingServices_16.0.1115.92.exe dated 5/1)

After upgrading we get this error on multiple (not all) reports "The Hidden expression for the tablix 'table1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0,…

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,834 questions
asked 2024-05-30T16:41:17.3866667+00:00
Kehoe, Tim 0 Reputation points
commented 2024-05-31T13:31:27.5666667+00:00
Kehoe, Tim 0 Reputation points