Content
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…
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…
Errors to run some custom reports after migration
Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type…
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 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…
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…
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.
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…
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
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…
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 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…
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 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…
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…
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…
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…
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…
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…
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…