-- It may be a good Idea to create an index on the Grouping/joining Column

-- create index idx_someName on SomeTame(someName)

-- go

select someName, sum(age) X

into #tmp

from mainTable

group by someName...

Hehe...

I was refering to the Identity column with primary key...

OR Find which is the equivalent of DAYADD in Oracle

Absolutely

First.

The Idea of a Sequence table is the right idea in this case.

Second.

"Central location for keys is a concurrency nightmare" if you are not using the appropriate locking...

There are several posibilities and you will need to choose acording to the complexity you need to handle. For a quick solution have a look at:

sp_crosstab

My advice is to see...

Now that you are looking for performance, Allow me to also say that your triggers should check for different values and only then insert the change in the log.

The reason...

SP4 is supposed to address this issue:

http://support.microsoft.com/kb/891719/

Correct. sqlmaint.exe does hardcode the connection settings and there is no way to change that. In sql 2005 MS introduced support for those cases with a switch.

The workaround is to...

     SELECT t1.*

     FROM dbo. t1

     JOIN

     ( SELECT [fK_id_1], MAX([date]) MaxDate

       FROM dbo.

       WHERE [primary]='Y'

       GROUP BY [fK_id_1] ) dt

     ON t1.fk_id_1 = dt.fk_id_1 and t1.[date] = dt.MaxDate

Not all errors are trappable in SQL server, especially TRUNCATE TABLE is something that should be thought very well  due to the elevated priviledges required. For such control you will need...

try:

select  a.changeNo, a.VendorID, a.ChangeDate

  ,(SELECT NewValue as CertificationDate

  from AuditTable

  where Field = 'CREDT'

        and VendorID = a.vendorID

        and DateChange = (select  top 1 DateChange --find the latest that...

>> Remember: Computed columns via UDF can't be indexed <<

That is not entirely true!

You CAN index the computed column if the UDF is DETERMINISTIC

I hope this clears the confusion of...

if you are looking at the problem from a performance stand point here are some thoughts:

1. Compute in to variables as many fixed values as you can

2. Try not to use...

Michael,

I am sorry if I can't really understand your post but:

1. Can you write *in words* what is it that you want?

2. Can you show an example *in tabular format* of the output. 

Cheers,