Based on that, would you say it is worth learning more about statistics?  I am just curious how much time and effort I should put into some of this or...

Hard to say anymore.  Having created new indexes and statistics, I don't have the origianl plan available to compare it to.  All I can say is that based on the...

I am more than willing to help, but I am not the only one who is start to question helping you.  I have yet to see you put anything up...

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