If the database is going to grow to 10gb once every 10 months, why not just leave it at 10gb. The shrinking, or not shrinking, has nothing to do with...

By archived, do you mean backed up? If so, then you can query the msdb database to see the backup history[/url]. If you mean some other process where data is...

On a database that small... I wouldn't sweat it, but if you are worried, take more frequent log backups. That will reclaim space faster.

Don't do that.

If your log it growing over and over again, you need to determine why it's growing. Deal with that cause. Set the log to an appropriate size. Make...

Rebuilding the indexes removes wasted space by moving rows that are distributed across a lot of empty space and compacting them into individual pages. This allows for more compression. Regular...

As far as setting up the servers, that's what you're going to have to do. When you say "start the upgrade process" that's the question. Since you're installing new servers,...

There's nothing you can run specifically to reload queries into cache. You running the app is doing that work for you. In short, this command is not something that should...

Well, not quite so close now.

Nicely done.

Either the file is locked, or the user you're attempting to run the DTA with doesn't have access to the file location.

Just trying to paste this into a query window to get a good view on what you're doing and I'm getting syntax errors. It looks like some of the code...

Never go back to the old job. All the reasons you left are still there. It's the same arguments for never taking a counter-offer. If all you needed was more...

From the sounds of it, there's senior level work in the organization, you just have to position yourself to be the one doing it. I've had these kinds of issues...

It's what Koen says, you can train people on any topic you want, pretty much any way you want. What you can't do is post or teach information from the...

Please, not NOLOCK. That just makes it possible to get bad data.

Without seeing the query and the query plan, it's impossible to say for certain. It's entirely possible that the...