Enjoy that Jack, it's a nice, balmy 1.5F here.

A few hints. The general work for a self join is

select a.x, b.y

from mytable a

inner join mytable b

on a.pk =...

I would not use T-SQL to do this. User VBScript or the Powershell scripting languages to do this. They are better suited to work with files.

The FileSystemObject can help you...

Well we're wrong. It appears that as long as you don't have XP home you can install standard edition. This from BOL (http://msdn.microsoft.com/en-us/library/ms143506%28SQL.90%29.aspx)

I would assume that would apply to Win...

Actually I'm not sure it's wrong. When you insert/update data you can cause a page split. In that case, the data is rearranged on disk.

The code is there, and a wrapper to make it a separate app can't be that hard, so why not do both? Give us access to the log viewer, query...

The switch I use to make mine run faster is the power switch. Turn it on, it flies. turn it off, no so much.

I think crystal balls work better than ouji boards. Especially when you drop them on someone's foot to emphasize a point.

I think it's a bit of both. IT should look for ways to improve things, and suggest them to users. Let them know that you see a possibility about how...

As much as most of us would like a switch like that, as Grant mentioned, there isn't one.

I'd also stop taking advice from whoever told you that.

You can use Virtual PC (or other vm software).

Here's a link to help you learn: http://www.sqlshare.com/clustering-sql-server-2005_33.aspx?searchid=76111

AFAIK, Azure is beta now. I'm sure there are some people using it, but it should go live, and start to cost $$ in Jan 2010

If you think something is wrong, please provide a reason and reference. We have not reason to take your work for it over anyone else's.

The third answer has been edited...

This article was written about a month ago, and my guess is the author did not have Win 7 at the time. Many of the articles written will age quickly...

moved.

Please pay attention to where you post.