Viewing 15 posts - 1 through 15 (of 179 total)
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 ?
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 ucaseSELECT 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
Okay Thank You.
February 27, 2021 at 10:56 am
If Execution speed is the only issue, can we move ?
January 20, 2021 at 4:38 am
Is it possible to find the query causing problem?
Because error comes randomly(once per week) and too many queries/programs run daily and continuously.
I am using SQL Server 2008 R2 in Windows...
December 3, 2020 at 10:40 am
I am trying to find reason for below error"There is insufficient system memory in resource pool 'internal' to run this query."
I am trying to find reason for below error
"There is insufficient system memory in resource pool 'internal' to run this query."
December 1, 2020 at 6:06 am