I'm still learning new things nearly every day, and I've...

I don't understand most of your Order By clause. It looks like you're sorting on variables, but they shouldn't change throughout the query, so they shouldn't be in the...

If you just need that one column, that's fine.

If you need more columns, like if you uncomment some of your joins, you'll need to add more columns to the index.

A...

Density is basically selectivity. High selectivity is good.

In Books Online, there's a good article on the subject:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/49b1cde3-4a67-4775-a942-ae1e2f1053e5.htm

No. Definitely not.

I'm suggesting that, if an appropriate column or set of columns exists, a clustered index could be created on those. That would probably be something that...

You can create traces with customer filters. Books Online has the details on how to do that.

An index that covers the join columns (and any where columns) will definitely speed things up. Even better yet, if you have the disk space and time to do...

SAME is certainly very easy to implement.

I wouldn't use it, for the simple reason that having data and log files on the same array limits your recovery options in the...

You can put anything you'd put in a Where clause, into a join clause. Some things might be a bad idea, but you can technically do it.

You're welcome.

gbargsley (8/7/2008)

---

I do not see where I said SQL is not on the machine.

I have 1000+ pc's with SQL Express 2005. It does not function correctly and the SP2...

http://www.update.microsoft.com

From there, you can have it check your computer for needed updates and it will update the client tools if it needs to.

The service pack will probably work, too, but...

Add a column to your table to force the sequence. That can be an Identity field, or a DateAdded field, or anything like that.

alter table MyTable -- put the...

If they don't have SQL Server on there, they shouldn't be trying to update it. I've never seen a computer without the server software try to install an update/patch.

Are...

On very large databases, it can also have the advantage of doing smaller, file-by-file backups, instead of having to back up the whole database all at once.

But the main advantage...