Microsoft Q&A

SQL Server

16,439 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

16,439 questions with SQL Server-related tags

Sort by: Updated
1 answer

How to make this query Sargable

Hi All, How to make this query Sargable and make use of index. I see the 2nd expression the WHERE is causing the query to take long time to execute. <?query -- SELECT comm_val ,party_id ,@email_domain domain INTO #comm FROM…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
asked 2023-11-22T07:59:42.71+00:00
Samantha r 1,226 Reputation points
commented 2023-11-22T14:35:10.4766667+00:00
Samantha r 1,226 Reputation points
2 answers

Assistance with SQL Query for Retrieving Software Update Groups and Associated Patches in SCCM

Hello Everyone, I hope this message finds you well. I am reaching out for assistance as I'm relatively new to SCCM and SQL, and I'm facing challenges in retrieving a comprehensive list of software update groups along with the associated patches…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
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.
655 questions
Microsoft Configuration Manager Deployment
Microsoft Configuration Manager Deployment
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Deployment: The process of delivering, assembling, and maintaining a particular version of a software system at a site.
798 questions
Microsoft Configuration Manager Updates
Microsoft Configuration Manager Updates
Microsoft Configuration Manager: An integrated solution for for managing large groups of personal computers and servers.Updates: Broadly released fixes addressing specific issue(s) or related bug(s). Updates may also include new or modified features (i.e. changing default behavior).
858 questions
Microsoft Configuration Manager
asked 2023-11-22T12:41:52.02+00:00
Swahela Mulla 45 Reputation points
commented 2023-11-22T13:57:03.5466667+00:00
Swahela Mulla 45 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.
2,619 questions
Microsoft Configuration Manager
asked 2023-11-21T16:42:52.0966667+00:00
Claudio Santini 0 Reputation points
answered 2023-11-22T13:27:22.0933333+00:00
Garth Jones 1,301 Reputation points MVP
1 answer

Slowness in collecting fragmentation details from huge database

Dear Team, On running this query as an Agent job, the performance is quite slow causing blocking. This is run during off peak hours. Could you please advise any steps for improvement? The DB size is over 2 TB. SET NOCOUNT ON; DECLARE @dbid…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,436 questions
asked 2023-11-10T08:53:49.02+00:00
mo boy 371 Reputation points
answered 2023-11-22T12:46:10.3466667+00:00
Bjoern Peters 8,641 Reputation points
4 answers

sql command written in cmd that is .bat file is synchronous or asynchronous

hi, I call few stored procedure from a .bat file  and .bat file is executed from micorsoft windows sheduler, need to know that , does it call in syncronious or asyncronious way? i.e firstly it executes the stored procedure in first line  and waits for…

Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,436 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.
11,481 questions
Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
9,387 questions
Azure SQL Database
asked 2023-11-21T15:30:27.79+00:00
Rajesh Kumar Yadav 0 Reputation points
answered 2023-11-22T12:44:53.6+00:00
Dan Guzman 8,441 Reputation points
2 answers

Question Regarding Azure Data Factory Date Field Data type

Hello, I want to ask if anyone has a solution to how to allow a date field datatype to export to Azure Storage Explorer through an Azure Data Factory process with the same date data type as from Azure SQL Database table ((note: the data type for date…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
Azure Storage Explorer
Azure Storage Explorer
An Azure tool that is used to manage cloud storage resources on Windows, macOS, and Linux.
200 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,405 questions
asked 2023-11-17T21:07:45.26+00:00
DaeDae89 0 Reputation points
answered 2023-11-22T11:05:11.2266667+00:00
ShaikMaheer-MSFT 35,626 Reputation points Microsoft Employee
0 answers

pyspark dataframe to be moved to sql pool

Hi, I am facing with the below error when i am trying to write the pyspark dataframe to sql server. Can you please let me know the changes i need to make in the code.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
asked 2023-11-22T09:49:18.0266667+00:00
Balaji M [C] 0 Reputation points
3 answers

How to install Microsoft SQL server management on MacOS M3

How to install Microsoft SQL server management on MacOS M3. Hello, for two days I’m trying to get Microsoft SQL management studio on MacBook with M3 processor. I was trying to do it with parellels, but it didn’t work. Is there any possibilities to get…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
asked 2023-11-18T21:10:57.26+00:00
jack281 0 Reputation points
commented 2023-11-22T09:11:33.7666667+00:00
AniyaTang-MSFT 11,096 Reputation points Microsoft Vendor
1 answer

How to split data of a single dataset in tablix in SSRS?

Hi Team - I would like to split the data of a tablix into two from single table from one dataset. I am new to SSRS so any help will be appreciated. Regards, Mudit

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,619 questions
asked 2023-11-20T23:19:12.8966667+00:00
Mudit Dhebar 101 Reputation points
commented 2023-11-22T09:10:46.22+00:00
AniyaTang-MSFT 11,096 Reputation points Microsoft Vendor
1 answer

How to allow Python Script in Azure Data Factory to access Azure SQL Server with private endpoint (no public access)

I have a python script in batch service as an element of Azure Data Factory (like here: https://learn.microsoft.com/en-us/azure/batch/tutorial-run-python-batch-azure-data-factory ). The ADF Pipeline has only one element - the mentioned script. The…

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,405 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.
11,481 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
1,801 questions
Azure Batch
Azure Batch
An Azure service that provides cloud-scale job scheduling and compute management.
280 questions
asked 2023-10-27T18:48:52.9466667+00:00
11-4688 61 Reputation points
commented 2023-11-22T09:02:35.55+00:00
AnnuKumari-MSFT 27,691 Reputation points Microsoft Employee
0 answers

SQL Vulnerability Email

I keep getting an email notification showing a few "failing checks," but when I click on the "View results" and go to "Vulnerability Assessment Page" it shows a big ZERO for all categories. Hmmm?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
Microsoft Defender for Cloud
Microsoft Defender for Cloud
An Azure service that provides threat protection for workloads running in Azure, on-premises, and in other clouds. Previously known as Azure Security Center and Azure Defender.
1,034 questions
asked 2023-11-21T16:43:44.9633333+00:00
NO 0 Reputation points
edited the question 2023-11-22T08:07:57.61+00:00
ShaktiSingh-MSFT 10,746 Reputation points Microsoft Employee
0 answers

SQL 2023 16.0.4065.3 When I use SQLSatellite.AppName in sql server extended events the trace stops capturing events

Works means that events are captured, fails means that the events are not captured. The works/fails state is switched by excluding/including SQLSatellite.AppName. CREATE EVENT SESSION [RPC - Works1] ON SERVER ADD EVENT sqlserver.rpc_completed(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.
11,481 questions
asked 2023-11-21T11:30:52.9066667+00:00
CUTHBERTSON, John 0 Reputation points
commented 2023-11-22T07:27:25.7566667+00:00
CUTHBERTSON, John 0 Reputation points
1 answer

inquire about CAL

Hello, I would like to inquire about CAL. What is a CAL license for SQL licenses? How do I purchase a CAL license? Can anyone give me some advice? Thank you so much!

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
asked 2023-11-22T06:36:16+00:00
Cater 0 Reputation points
edited an answer 2023-11-22T06:48:41.4833333+00:00
PercyTang-MSFT 11,336 Reputation points Microsoft Vendor
2 answers

SQL Server not starting

hello, my sql server has not been starting. i am using the express version and it is installed on my laptop for development purposes(university). my error log is as follows: 2023-11-21 18:27:11.66 spid20s A new instance of the full-text filter daemon…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
asked 2023-11-21T14:34:07.0433333+00:00
Adrien Alassoo 0 Reputation points
answered 2023-11-22T06:41:26.91+00:00
CosmogHong-MSFT 16,621 Reputation points Microsoft Vendor
2 answers

I want to write 42000+ rows of data into sql from azure synapse using python,I get an memory error,So tried bulk upload when i am trying to write the data to sql.

I want to write 42000+ rows of data into sql from azure synapse using python,I get an memory error So to avoid the memory error i also tried, writing the data as a csv file(bulkupload) directly from the container, but i am facing the below error. 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.
11,481 questions
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.
3,767 questions
asked 2023-11-21T12:49:08.6933333+00:00
Balaji M [C] 0 Reputation points
answered 2023-11-22T06:19:35.4033333+00:00
ZoeHui-MSFT 26,911 Reputation points
1 answer

Help in Query to compare latest timeline from previous timeline

Hi, I want to compare Round1 and Round2 column of current timeline with the very latest last timeline. Round1 and Round2 of latest timeline should not be different from very last timeline. The key column of this table is R1,R2,R3,R4,R5. Thanks   Create…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
asked 2023-11-22T02:24:22.7366667+00:00
Martin Kevin 141 Reputation points
answered 2023-11-22T06:10:48.17+00:00
CosmogHong-MSFT 16,621 Reputation points Microsoft Vendor
4 answers

How to fix, Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.

We have setup the domain controller. Two machines (Windows Server 2019 Standard, 10.0.17763) are added to the same domain(Mac1 and Mac2). From Mac1, we are trying to connect remotely to SQL Server 2019 installed on Mac2. We are using Mix mode…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
asked 2023-05-12T07:33:52.4566667+00:00
Manjusha Shinde 0 Reputation points
answered 2023-11-22T05:37:48.76+00:00
Herdsman, Wade 0 Reputation points
1 answer

How to install Reporting Services in an Azure SQL VM

Hello, I have an Azure SQL VM and i need to install SQL Reporting Services. I downloaded the setup but it asking for a serial number that i don't have. How do i know the serial number of SQL to insert in the instalation process? Or there is another way…

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,619 questions
asked 2023-11-21T15:33:23.5+00:00
Sérgio Raposo 0 Reputation points
edited the question 2023-11-22T05:28:31.33+00:00
vipullag-MSFT 22,651 Reputation points Microsoft Employee
1 answer

Visual Studio SSIS 2013 OData Source issue: The underlying connection was closed: An unexpected error occurred on a send on windows 10

Hello, I am getting the Test connection failed -> The underlying connection was closed: An unexpected error occurred on a send. error on an SSIS package I'm trying to run. It's using an OData Source connection to connect to a sharepoint list to…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,303 questions
asked 2022-03-09T18:58:04.41+00:00
Umair Ahmed 1 Reputation point
edited the question 2023-11-22T03:40:25.2133333+00:00
Roy Li - MSFT 30,536 Reputation points Microsoft Vendor
1 answer

Unable to connect to SQL server on Azure Logic Apps

Hi, I am new to Azure logic apps. I am trying to connect to a SQL server using port 1521. I put the port number after the server address as specified in the image. For example, I put testserver.database.windows.net[:1521] as the SQL server name. It gives…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,481 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,524 questions
asked 2023-11-22T01:32:46.5633333+00:00
Admin 0 Reputation points
edited a comment 2023-11-22T02:44:05.16+00:00
AdamZachary 406 Reputation points