Viewing 15 posts - 1 through 15 (of 193 total)
No , a normal select query with few where conditions followed by a ordey by clause
February 6, 2025 at 8:40 am
No . im not using Prepare() statement
My VB.NET code is in the below format
Dim command As New SqlCommand(query, connection)
command.ExecuteReader()
February 5, 2025 at 2:08 pm
the query does not contain any variables or parameters
February 5, 2025 at 1:51 pm
I am using the read committed isolation level to execute the command
February 5, 2025 at 1:09 pm
It happens for a particular SELECT query, but the error doesn't occur consistently,it's generated randomly.
February 5, 2025 at 1:04 pm
I’m running the SQL query through VB.NET code. To check if the query execution time was slow, I executed the query directly on SQL Server and verified that it runs...
February 5, 2025 at 11:55 am
We have already tried closing and reopening SSMS. But , that did not work . I want to set this execution timeout for all the sessions in the SSMS programmatically...
June 4, 2024 at 4:34 am
Apologies for the confusions caused . I am planning to set the execution timeout for all queries that I will be running in SSMS. My goal is to stop the...
May 29, 2024 at 7:02 am
Error: 9001<c/> Severity: 21<c/> State: 5.
Error during rollback. shutting down database (location: 1).
Database was shutdown due to error 3314 in routine 'XdesRMReadWrite::RollbackToLsn'. Restart for non-snapshot databases will...
May 20, 2024 at 7:15 am
I have already tried this , does not work . Same error repeats.
November 20, 2023 at 11:51 am
When I run the same query multiple times why does the CPU time fluctuate between 0 and 16ms in tracer, query cost and live data explorer? Also I have updated...
December 22, 2021 at 9:34 am
To add to what Johan said, I'd also check to make sure your database owner is a valid, enabled user. I've had service broker fail to send messages because...
November 1, 2021 at 6:20 am
What are you trying to do with notification services ?
Chances are you can do it more easy and less intrusive on your server / instance using Extended Events...
November 1, 2021 at 5:54 am
When the following query was run ,
SELECT * FROM [msdb].[dbo].[suspect_pages]
we found that few pages in a table was corrupted.
If it is a data page we can get...
October 20, 2021 at 10:22 am
We have a single SQL server instance , to which 200 users(.net application) are connected and are waiting to receive notification from SQL server when a row has been updated...
August 21, 2021 at 5:51 am
Viewing 15 posts - 1 through 15 (of 193 total)