18,206 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
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,950 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 102.6K 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,950 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 102.6K 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,950 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 75 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,950 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,474 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,835 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,474 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
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
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,835 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,070 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,950 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,728 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,474 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,292 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,030 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,950 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,835 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

SSIS package executed from SQL Server Agent doesn't export full data to Excel

I have a SSIS package which exports data to multiple tabs to Excel, This doesn't export full data to Excel when run from SQL Server agent on server. It is checked to run as 32 bit. I have other packages which exports data to Excel and they all work fine…

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,950 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,474 questions
asked 2024-05-31T02:07:30.6933333+00:00
Challagundla, Sindhura (ITS) 0 Reputation points
commented 2024-05-31T12:13:57.1466667+00:00
Challagundla, Sindhura (ITS) 0 Reputation points
3 answers

SQL SPNs for 2 Node AON Cluster with 2x Instances and custom Ports

Hi everybody, I read so many different suggestions in different forums and blog artciles that it made me question my understanding about the proper SPN registration for SQL. I have a pretty standard setup: 2 Node Cluster consisting of: …

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,950 questions
asked 2024-05-30T08:00:27.4866667+00:00
SChalakov 10,276 Reputation points MVP
edited an answer 2024-05-31T09:33:45.6+00:00
LucyChenMSFT-4874 1,815 Reputation points
2 answers

Prompt To Save unsaved T-SQL query windows on close

I am using SSMS V 18.7. I am continually prompted to save changes to query windows when closing them, even though "Prompt To Save unsaved T-SQL query windows on close" is unchecked. In fact, the "Prompt To Sqve unsaved T-SQL query…

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,950 questions
asked 2021-10-01T20:57:45.25+00:00
WILLIAM BEHNING 36 Reputation points
commented 2024-05-31T09:00:45.4233333+00:00
Phil Parkin 0 Reputation points
1 answer

Change the code and used in existing Views

Hi There is Scalar UDF used many places in views and SP. I need to change the Scalar UDF from all views and SPs. What is the alternate way to replace it. Is it good that I can replace the Scalar UDF with Inline table valued function. Appreciate your…

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,950 questions
asked 2024-05-07T12:57:39.02+00:00
SVA 86 Reputation points
commented 2024-05-31T07:56:48.89+00:00
SVA 86 Reputation points
2 answers

Invalid column

Hi When I execute below SP gives me invalid column error. Sometime it will work and sometime it gives this error create proc test as Begin Select * into #Temp from table1 begin ALTER TABLE #Temp ADD IsOn BIT NOT NULL DEFAULT(1) UPDATE #Temp SET…

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,950 questions
asked 2024-05-29T11:43:16.77+00:00
SVA 86 Reputation points
commented 2024-05-31T07:55:43.0733333+00:00
SVA 86 Reputation points
2 answers

Seeking Expertise in Spark SQL CTE Recursive Queries in Azure Databricks

I'm currently diving deep into Spark SQL and its capabilities, and I'm facing an interesting challenge. I'm eager to learn how to write CTE recursive queries in Spark SQL, but after thorough research, it seems that Spark doesn't natively support…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,504 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,985 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,950 questions
asked 2024-05-30T04:27:35.4+00:00
Anuj, Singh (Cognizant) 50 Reputation points
answered 2024-05-31T07:52:36.89+00:00
Smaran Thoomu 11,045 Reputation points Microsoft Vendor
1 answer

Unable to install SQL Server (setup.exe).

Exit Code (Decimal):- 2068052377Error description: Invalid command line argument. Consult the windows installer SDK for detailed command line help. SQL Server Install Log Folder :- C:\Program Files\Microsoft SQL Server\160\Setup…

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,950 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,497 questions
asked 2024-05-31T05:54:54.65+00:00
Technology 0 Reputation points
edited an answer 2024-05-31T07:05:10.2466667+00:00
LucyChenMSFT-4874 1,815 Reputation points
2 answers One of the answers was accepted by the question author.

conditional join

hello, table1 has columns - col1,col2, col3 table2 has columns - col1,col2, col3 in my sql, I join the tables together by col1 but I also want to join via col2 and col3 only if col2 and col3 are present in table2 otherwise only join via col1. for…

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,950 questions
asked 2024-05-31T04:56:18.7066667+00:00
arkiboys 9,686 Reputation points
answered 2024-05-31T06:34:42.9066667+00:00
CosmogHong-MSFT 24,026 Reputation points Microsoft Vendor
4 answers One of the answers was accepted by the question author.

Can a deadlock issue be raise while running two select queries in sql server

Do we get a deadlock issue while running two select statements of two different table in sql 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.
12,950 questions
asked 2024-05-24T13:21:28.4666667+00:00
Khan-CW, P Ali Altaf 63769 20 Reputation points
accepted 2024-05-31T05:45:00.68+00:00
Khan-CW, P Ali Altaf 63769 20 Reputation points