ops, there should be something assigned to the @xml_id variable.

it should look like this:

normally user will select 5-8 id from the web page and pass it to db. so,...

well, here is a simplified version of my scripts:

Table Structure (Actual table consists of > 100 columns and 20 mil records)

---------------

CREATE TABLE [dbo].[mytable](

[id] [int] IDENTITY(1,1) NOT NULL,

[ud_agent_id] [varchar](30) NOT NULL,

[ud_status]...

i tried use WITH(ROWLOCK) on both.

however, DELETE will be escalated to TAB lock. It will block my UPDATE.

in my production environment, this situation is even worse.

on one hand, one SP...

i ran this command to disable lock escalation:

dbcc traceon (1211)

i don't think this is what i want.

you can try this

stuff(stuff(right('000000'+your_colume,6), 3,0, ':'), 6,0, ':')

have u setup the trace?

if u haven't, pls refer this doc http://support.microsoft.com/kb/283790

when your trace started, it will store trace files in a folder.

after that, u need to use...

i think sql server collects the data at the back and store them in resource database (a hidden database).

after that, we can pull the data via DMVs.

this is what i...

update tblOld

set obsolete = 1

where not exists (

select 1

from tblNew b

where tblOld.c1 = b.c1 and tblOld.c2 = b.c2

)

i am not sure whether this will help.

normally, i will do a full backup of the db and modify its path during restoration. 🙂

kinda stupid but it works all the...

In your app, let say, you do somethin like this

dim str_data

str_data = "a unicode string"

'call stored procedure

...

connection.execute "exec sp_insertSomething N'" & str_data & "'"

---------------------

In you sp,

create proc sp_insertSomething @param...

did u use N'your unicode data' when inserting?

put the stored procedure in an infinite loop?

in the loop, put something like

WAITFOR DELAY '23:59:59' so that it will only run once a day.

😀

it looks like you have reach your max throughput of your D: drive (due to you are restoring too many files onto the same drive).

for a 32GB database, why...

we capture the data from this view every hour.

however, the data looks weird.

at one point, num_of_reads dropped.

Date ...

thanks for the suggestions. 🙂

I will contact my system admin to try it out.

Once I got the result, I will post it here.

thank you, again. 🙂