DBCC DBREINDEX drops each index on the given table, then rebuilds them using the parameters supplied (fill factor) unless none is specified and then it will use the original fill...

Let me get this straight, you are running a scheduled backup that is appending to a single file? How is this job configured?

I would suggest that you use the maintenance...

We been seeing this problem, both at a client site, and in our development environment - but it only started recently. It does seem more prevelant on the multi-core machines....

You are in a pickle, aren't you. No lecture on backups at this point as it is not helpful.

First, might I suggest that you open an incident with Microsoft. Chances...

First I'd suggest contacting your Network Administrators to deal with flushing the router. I might be able to dig up the necessary commands, but I don't recommend just doing that...

All bashing aside, we all know that there are exceptional DBA's and Developers, just as there are horrible versions of the same.

If I had my choice, I would rather have...

I can play a couple of angles on this one as I have worked with both types of businesses mentioned in this post.

There are those small organizations that have a...

This is a known issue. SQL 2000, 2005, and likely 2008 will not show anything but local drives on the Server. This excludes SAN drives as the drivers for most...

Steve - I've not tried this in 2008 yet, but I know that it was a limitation in 7.0 and 2000. In all cases you could backup/restore to network locations,...

This is an interesting question.

In my experience, VPN works much the same as your average network, but slower. Having said that I would say that you should be able to...

I don't find it hard to believe that there are potentially 40 plus laptops lost each day. I'd be curious if the number of smartphones is also around that number...

Right click on that part of the task and select the Edit option. In this screen you can select the location and file extension as well as how old the...

Are you saying that you have added a Cleanup Task and are still having issues?

I've noticed that there...

You can do that, you just can't browse to the location.

In the file location type in the UNC Pathname and the filename you want to backup to (i.e. \\Server\share\SQLbackup.bak)

Where ever...

I agree with David, it is ultimately up to your customers or sponsors. However, let me add that you should let them know what their options are since they may...