I think posts are a grey area. If you post substantial code or develop original thoughts in a paragraph or two, then I think your words are copyrighted. Quoting someone...

I have corrected the answers as it is indeed 2^31 - 1 characters. Sorry, missed that little subtraction late last night.

I got to two pages, and start to drop things when I get longer. The other thing I do is reduce the amount of description in older jobs, so the...

Ian,

You can reduce this by limiting the results again to look for a NULL in the left outer table.

The one for the 70-443 exam and one (short) one on 2005 Maintenance Plans

BTW, I did receive an apology from the President of the company today.

That was nice, although someone posted a rude comment in his guest book. Please refrain from doing something...

It makes administration harder. I've only used it when I had data for archiving I could separate out into it's own filegroup. Or when I had disk constraints.

How much is...

This is normal. SQL Server will allocate some at boot and begin to request more from the OS as it feels it needs it. 1GB is pretty low and I'd...

The tasks run in parallel if they have no dependencies between them. You can add 4 connections with 2 data transform tasks, but no links between them and the 2...

You can set an alert to get successful logins, but I've had trouble getting it to work. Maybe BKelley will chime in.

If you have the logs, then you can save...

The Configuration Manager or the Properties of the server in SSMS should help you here.

Thanks for the notes and support, but I tend to agree with Bob McEuen. After I sent it, I felt bad about that last line. Actually would have preferred to...

I used to build a separate table for accounting periods. We always had weird ones that would sometimes end a day early or late. So I build a table that...

The woodstove is interesting and we've considered that. Get two benefits for the price of one. A wood fire and heat.

The alternative power is interesting to me because I know...

You can use DATEPART to find out which day of the week it is. Then depending on what you have DATEFIRST set to, you can add or subtract days.

For me,...