Viewing 15 posts - 1 through 15 (of 183 total)
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
As we now know that XML NULL value takes no space , We would like know the space taken when values(non NULL values) are stored in a column with XML...
August 3, 2021 at 5:28 am
Read committed snapshot mode - can read last committed value,
even if "begin transaction" is done after uncommitted "update" query - tested.
July 9, 2021 at 5:42 am
what if userB had opened connection(with snapshot), after userA ran update query and commit is pending from user A ?
And
what if user A runs update query first, then user B...
July 6, 2021 at 12:06 pm
My tempdb size = 200mb
Autogrowth set to "By 10 percent, unrestricted growth"
Will be using express edition.
June 22, 2021 at 7:48 am
All other errors were solved. Now when I execute DBCC Checkedb i will get only this error.
Msg 8921, Level 16, State 1, Line 1Check terminated. A failure...
June 19, 2021 at 9:39 am
Below query tested and time updated
-- with ucase
SELECT COUNT(*) from tblallindex
WHERE bookdata.exist('/bookstore/book/author/text()[upper-case(.) = ''ERIK T. RAY'']') = 1;
-- CPU time = 5781 ms, elapsed time...
May 12, 2021 at 5:58 am
In a scenario, where 100 users over LAN open data entry application and edit values(in a grid) from 9 AM to 9 PM, wouldn't there be a speed issue, if...
March 8, 2021 at 7:13 am
whether required to restart server pc during SQL server non-responsive state?
i.e.. pending memory grants >0 or restart SQL server ? ( or any other method like DBCC FREEPROCCACHE)
March 5, 2021 at 9:24 am
Ok thanks, connections were kept open till application was closed to reuse. Connection string is unique for a DB, so will change to close and open logic.
Whether connection pools are...
March 4, 2021 at 6:54 am
Viewing 15 posts - 1 through 15 (of 183 total)