I will dig a few by hand at times, but not often. I did, however, pound in 20 T-posts into the ground by hand over the last month.

If you run regular log backups, you ought be able to set a log size and not mess with it. Read Gail's article and that should help you understand why.

Log...

Does this work if you don't do the SAN backup?

You should be able to test this during a low period of activity. See if you can :

- Add a table

-...

I wouldn't lie.

I'd say, I left this job because they wanted me to work 80 hours a week for weeks. I can't, and don't believe it that. I'm more productive...

Ignore the query.

How do you get this answer if you have the populations?

Now, how do you get the populations in a query?

Apply the math to the query. It's not...

LOL, I think I did this without thinking in my younger...

x64 or x86?

I would leave 2GB for the OS, but monitor and check the pagefile for lots of activity. Leaving3-4GB can't hurt.

For SQL, you'll have to experiment with each instance....

The issue with Single_user is that the first user gets in. Might not be that person.

I'd still set permissions in two groups. Revoke access for one group, add for the...

It should. You might need to restart the log shipping jobs, but they should be able to pick up with the next log file

That's the agent log, isn't it? You want to get something from the maintenance plan itself, not the job. Something like this:

Maintenance Cleanup Task (SEVENFALLS)

Maintenance Cleanup on Local server connection

Cleanup...

No, no red gates. Not unless they pay for it! 😛

My wife bought green last time.

Digging is easy here. I have an auger on the tractor. It does the work....

It is a nice break during the day. Course, I've spent 20 minutes out there 3 nights in a row with a bucket of water trying to soften clay and...

Still going...

Kit G (9/3/2010)

Yes, we are. I'll let Gus...

Just for load, I'd do them in series. As noted by Jason, I have no metrics.

I'd also use shrinkfile instead of shrinkdatabase. Had better luck with that.