I'm afraid I don't understand the question. Are you concerned that your system is not using enough memory or too much?

One measure that will tell you if memory is a...

kim.talley (4/10/2009)

---

I have a question from a developer that I'm not able to answer....I was hoping someone here could help out.

Is it more efficient to use multiple joins in a...

It really could be almost anything. Since you don't know, you need to investigate systematically. I like the recommendation to capture a trace. That's something I always do. I'd also...

HVPR (4/9/2009)

---

Thanks for your suggestions..

and sorry for the posting twice...

But I want to know is there any local sql server feature or tool which can help to sync the

code between...

It's really hard to say based on the information provided. Are you sure that the slow response on the system is due to this table in particular? If so, do...

GilaMonster (4/9/2009)

---

Join us next time? Even if it's just to watch and take photos?

For the records, I never beat Steve up. I was training with Kalen most of the class...

Just out of curiousity, where do you go to ping MS on something like that?

Man, I'm sorry I missed that seminar. She made a real impression.

Andy Warren (4/9/2009)

---

I've tried to modify my statement to 'some of those tools don't offer ENOUGH value' for me, for right now. Not trying to dissuade anyone from using them...

I don't think so. Plus, I just wouldn't use @@IDENTITY. It's too prone to error. SCOPE_IDENTITY is much more consistent and I'm not aware of anyone having errors with it...

dastagirid (4/9/2009)

---

thanks...

but what I need suppose I inserted 1 to 10 values in a table

and deleted 5 to 10 ..next i will insert record 11 is the id values..

I want...

You use a second instance in order to manage different security for a system, to isolate an application from others, to have a SQL Server with different configurations, but still...

During the insert you have a couple of options. You can use SCOPE_IDENTITY if you are inserting a single row at a time. You can use the OUTPUT clause if...

satishthota (4/8/2009)

---

I had T1 Table

PersonId OID

P1 ...

Clustering is a whole technology and no, to my knowledge, you can't cluster two instances on the same server. Clustering is a mechanism for having more than one server available...