Two ways,

One is to create a link table, has EmpID and SupervisorID, along with dates that correspond to the timeframes. For current assignments, leave the end date open and handle...

First, please post this in a forum that makes sense for your post. You titled it SQL Server Express, so perhaps that forum.

Second, how are the data feeds coming? If...

Thanks for the suggestions and I'll second the Stephanie Plum series mentioned above. They're hilarious, even laugh out loud in places.

I actually watched some of Night at the Museum today...

Thanks and feel free to submit this as a script. We can get it out in the newsletter then.

I had a 700GB database and it ran fairly well, but we had 5 or 6 filegroups, mulitple arrays and we had to be careful with maintenance. And we...

Very strange. could be fragmentation.

How much data is in the table?

Troy,

I sympathize and I'd really recommend looking at 2005, even in 8.0 mode. The architectural enhancements will help with the load, especially if you can move to 64-bit.

That aside, a...

Be sure you're not one of the connections. Don't open a query window to that database, have one to master instead.

SSMS should do fine.

If this is only a SQL server, then I would probably set Min and Max to the same value. My impression for 64bit is that you would...

SQL_oracle has my caveats for network backups. Don't do it.

If you have bandwidth issues, then you're somewhat stuck as the bandwidth is required to do the backups.

What I'd recommend is...

Did you attach the master database?

might have a naming conflict.

I'm not sure I understand.

First 3000 isn't much. I'd just run them, suck them in on your side and discard what you don't need.

Second, where is the criteria for the...

Also, don't forget there is a Cumulative Update #5 available now. Announcement going in tomorrow's newsletter.

I've dropped it on 3 laptops/desktops and one server in a VM situation and had no errors.

Rebuild the index, and it should have a clustered index on it. Likely it's just bad data.