To move the data, move the clustered index to the new filegroup. To move the indexes, rebuild them on the new filegroup.

You can use Gail's suggestion, but building queries like this is inefficient and can cause you performance issues with large data sets.

Please do not post in all caps and please describe your problem in the post.

Send an email to the webmaster with your blog name and ssc registration.

Feel free to suggest most levels or names. I got tired of doing these and hadn't planned on going past 10,000.

We don't have a monitoring system in place and to prevent abuse, you must request a blog from the webmaster.

Ellis, nice one.

I'm a big karma believer and I'd do what sing4you said. Put it in a separate account, make efforts to return it, and let it sit. Preferably an...

I would have tried it the way you were running it. Not sure there's a way outside a cursor with dbcc inputbuffer. Course there are a lot of DMVs, one...

The log does truncate after a successful portion and it does remove the active portion, but are you expecting the file size to change? It will not.

Some interesting comments and thanks for the debate.

I think the idea of replacing xp_cmdshell for specific functions is a great one, and one that I hadn't thought of when I...

Change your procs to insert the result data into a temporary table and then compare those two tables.

Agree with Matt. Show some work and post only once.

There's no way for us to help you with this. You need to do some testing with and without filegroups and see if it's better. You might also want to...

Where does this occur during the install?

Are there services installed? Does SSMS run?

Oh and I'd also add that for those of you that work more than 40, how much of that is because you're a driven person, looking to push your career...