Not really sure what you are asking, but if you are trying to make a comma seperated list of names try this:

declare @NameList varchar(8000)

select @NameList = isnull(@NameList,'') + Name +...

Curious, Best, but when are you going to start doing your OWN work insterad of relying on the good nature of the people who use this site?

If you would take...

I think I have a pretty good understanding about building and tuning queries, and the use and creating of indexes.  What I am not sure about is statistics.  In working...

SQL Noob, not that I didn't want your scripts (I'm not one to reinvent the wheel everytime I need one), but I thought it best to write my own as...

Along these lines, how much effort should I put in to understand statistics?  Would getting Inside Microsoft SQL Server 2005: Query Tuning and Optimization be a worthwhile investment?  Just curious...

substring(tbl1.field1, 1, patindex('% %',tbl1.field1) - 1) = substring(tbl2.field1, 1, patindex('% %',tbl2.field1) -1)

Just checking to see if you have an update?

Thank you.

I'm tired of TLA's, there are just too many of them.  Someone care to elaborate on BES?

Unfortunately, some of these queries are written using the PeopleSoft Query Tool (visually build your query and let Oracle decide how best to run it!).

We have come to the conclusion...

Actually, we are running Windows Server 2003 Enterprise Edition.  Sys Admin had to add the PAE when he added the additional 4 GB RAM to the server on Friday so...

AWE is NOT enabled, only using the /3GB switch.  max degree of parallelism is currently set to 2 (the number of physical processors in the server).

1st, dev boxes were upgraded to SQL 2005 first.  We have no PeopleSoft Database Servers currently running SQL Server 2000.

2nd, same boxes as before.  Uninstalled SQL Server 2000, installed SQL...

We update statistics nightly.  Didn't help.  Going to look more closely at the indexes.  Also asked sys admin to add lock pages in memory priv to the service account login. ...

Since you are using the field in a where clause, it makes sense to index the field.