did this post get changed?

if target memory is greater than total memory then this indicates your server is short on memory, not that you have a memory leak.

It's all very well posting links as answers, doesn't really give "real world" experience !

The article referenced is not complete or accurate.

With 4Gb of ram you have two options, use...

disk io completion time is the main one I use, if the counter is over 10ms ( I guess for a sata drive ) then it is a possible bottleneck....

There's been a number of posts about the somewhat dubious value of the tuning wiz in sql 2000. I'd suggest you don't use it and if you must use such...

timing of queries at the client is of dubious value unless you're interested in network stats. Use profiler to time your queries. The getdate() example is pretty worthless, I suggest you...

It's all to do with io, pages, index width/column width, selectivity and locks, there's not a "golden solution" to effective indexing and as Lynn correctly states it's more of an art....

you need to be a little more specific, the term "crash"  means nothing.

• Do you have backups
• do you have intact mdf files
• what caused your problem

I had this problem too

oh well lets just upset a few more people!!  I find extensive use of nolock to overcome poor programming by developers who don't understand transactions and isolation ( and data...

It doesn't work like that - you have to establish the business needs - have a search, there's lots of info about this subject.

agreed batched small deletes work so much better. make sure the delete criteria is indexed, you should index for deletes to avoid scans. I know no-one makes much reference to...

it has an open tran, you need a commit.

Hmm .. guess you'd fail the mcdba questions on server vs client  cursor processing. Using a client cursor ( and looped processes are still cursors even if in disguise&nbsp

it's a bit of a fallacy that you always need to clear the cache(s) , total of  logical + physical should always be the same regardless of make up. In...