Pleasure.

Are you familiar with the group by clause and the aggregation functions in a sql statement?

The aggregations (in this case SUM) get the columns you're trying to aggregate as a...

The inside SQL Server 2000 book and the Inside SQL Server 2005 series are excellent. Kalen Delaney, Itzik Ben-Gan and others

duplicate post

http://www.sqlservercentral.com/Forums/Topic506818-338-1.aspx

A primary key is the row's unique 'identifier'. A clustered index defines the physical order of the data. The are unrelated.

By default, when you create a primary key, it's enforced...

Try building up your strings and placing them in variables then passing those variables to sp_executesql. I seem to recall that concatenating bits of string in the call to a...

If I may suggest - remove the extract from a wrox book as it is probably (at best) borderline copyright infringement - posting copyrighted works on a public forum.

I would hope so. Though I have a feeling some people think we work for SSC and get paid to answer...

Check the remote server. You may very well find an access violation/stack dump.

No. I said that was a solution to the small query you...

Try DBCC INPUTBUFFER(@@SPID).

This should work.

SELECT original_login(), local_net_address, text

FROM sys.dm_exec_requests er

INNER JOIN sys.dm_exec_connections ec on er.session_id = ec.session_id

CROSS APPLY sys.dm_exec_sql_text (er.sql_handle)

where er.session_id = @@SPID

The simple query you posted has a simple index fix, and Barry gave it to you on page 1 of this thread

http://www.sqlservercentral.com/Forums/FindPost506666.aspx

Other queries, especially if they have lots of columns...

If you could give us the table definitions, the index definitions and the query, it would really help.

Also, copy the entire execution plan to excel (not just the 1st column...

A...