How about we form a company so we all can benefit.

 I think you need to post what you have, the DDL for the tables, some sample data, and what the results of the query should return.  with that, there are...

Took a minute, but that little change makes sense.  Something I can add to my little tool box.

Thanks Sergiy!

Notice it is always the shortimers who seem to jump right in and help?

For about 20 weeks out of the year (10 weeks in fall and 10 weeks in spring) I get out of the office and do something totally different, I am...

I am assuming (bad habit) that the data in this case is numeric.  This actually sounds like a good use for using CLR integration and write some procedures/functions in VB.NET...

Had this problem with maintenance plans at my previous employer.  We had to delete and recreate the maintenance plans to get it to work properly.  If we had to make...

Unfortunately, we also had other issues to deal with as a result of the upgrade from SQL Server 2000 to SQL Server 2005 besides this particular query running slower on...

From what I can tell, the mirrored backups isn't supposed to protect from a failure during the backup, but from the media failing after the backup is completed.  I am...

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