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...

Read committed snapshot mode - can read last committed value,

even if "begin transaction" is done after uncommitted "update" query - tested.

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...

• This reply was modified 3 years, 7 months ago by   IT researcher.

My tempdb size = 200mb

Autogrowth set to "By 10 percent, unrestricted growth"

Will be using express edition.

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...

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...

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...

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)

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...

Okay  Thank You.

If  Execution speed is the only issue, can we move ?

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...

I  am trying to find reason for below error

"There is insufficient system memory in resource pool 'internal' to run this query."

We have added stored procedure  betalockinfo , error not repeated but we have already troubleshooted using sp_who2,sp_who3 and using blocked by handle we were able to locate pc and closed...

We are  using  dot net Application. When application opened SQL connection will be opened and it will be closed when application closed. The Extended property is updated using application  but ...