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

There is no "best" tool, there's what works for you and your situation. I can make a few suggestions.

Start treating your database like code. Check all the scripts into source...

Thanks to an article published here a few months back, I read a book called Getting Things Done by David Allen. He's pretty ruthless with time management too. It's made...

Something like this will help get you going.

SELECT TOP (100)

a.CustCode

,a.COUNT(CustCode) CustCodeCount

FROM TableA a

GROUP BY a.CustCode

ORDER BY CustCodeCount DESC

I didn't use the other table becuase I don't see a need for...