It's not easy, but I think we have great rewards. Talk to doctors and lawyers. They worked 100+ hour weeks in school! And they get to dress up, work insane...

I tend to agree with Colin on the v2005 and 64bit if you can swing it. Even if your box only support 4GB or 8GB, if you're on 64-bit, then...

colin has the best advice I've seen. Usually things aren't quite the same when there's a restore. I'd definitely rebuild indexes to defragment things and be sure you get the...

Most of these tip lists are from Brad Magehee, who is the editor of sql-server-performance.com.

I'm not sure how much of a performance problem there is, and given their benefits...

If the FBI starts watching me, they're in for a long boring ride.

Waste is an issue and I don't have a solution. My kids wonder why we don't send it...

No, but I'd be interested as well.

No, but I'd be interested as well.

As the author, it was a complete guess. I caught this late last night and in an hour of frantic searching (in between pausing the newsletter and getting it rebuilt),...

I tend to favor using suffixes if you want to distinguish views from tables from procs, etc. The big reason is that I want all things affecting a particular area,...

This is more of an ordering issue on a union than a puzzle. There doesn't appear to be a relationship to the tables. Is there some reason you chose this...

I used to have a task like Purple lady's. I did a "pushFTP" from the source side to get the files to our office rather than a pull. If that...

Here's one to test or modify for you:

http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1857

Here's some of it.

SUMMARY

If you apply the initial release version of Microsoft SQL Server 2005 Service Pack 2 (SP2), existing SQL Server 2005 maintenance plans and Integration Services packages...

Must be something switching you on the MS site because of your browser. Are you in Germany?

Personally I'm not much of a log reader guy. I bought Lumigent a long time ago (2000-2001) and thought it was amazing, but never really used it for a production...