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

I think it might depend on how selective the index is. Also, because you're updating the index values themselves, you might be seeing a lock on the index, not the...

Have you tried using aggregation yet? I'm pretty sure you'll need to use within a derived table, but if you can get the aggregated values first, you'll be on your...

OK. Although if that information was in the table it would be easier to query.

Regardless. What TSQL have you tried for getting the data together so far?