My previous employer, a school district, required all personnel to have 40+ hours of training each year. They counted trade shows and conferences so I could easily have made those...

Well, this isn't exactly what I wanted to do since it doesn't seem to be as clean as I would like but...

I took the statement from the function and put...

Well, I have looked at the documentation but I can't make heads or tails of how a cross apply would work in this particular case. If you look at the...

Tricky, tricky! Good question though. I fell into the trap probably because I haven't had enough coffee yet this morning. I saw the % signs and just completely forgot about...

Michael Valentine Jones (8/12/2008)

---

Sometimes it is necessary to have different servers because they have different maintenance windows for the applications.

One might have a downtime window of 0100-0600 on Saturday and...

I think I saw you say you are still running Windows NT? In my experience with NT, it wasn't very stable. When I started doing system administration with SQL Server,...

So really, they are wanting to pay for two severely under-utilized boxes? You could take that to management so they can't spend the money.

Anyhow, the thought just occurred to me...

I assume you have already searched Microsoft's site for "best practices" and came up empty. My only suggestion is to look for examples where people are running multiple databases without...

I would definitely push the concept of mirroring if they insist on setting up a separate server. If this database will have < 10 users, the server will be so...

Steve Jones - Editor (8/7/2008)

---

Jim,

How important is it for you to see us move? I'm wondering because I bet we could move today, but we don't really take advantage of...

I'm curious - how soon will SQLServerCentral.com move to 2008?

eric (8/7/2008)

---

After having another discussion with our tech guys, it turns out that the 5th drive was only temporary and it's been removed before I even had a chance to...

I think cost, mostly, is what is driving his decision. Plus, he just doesn't have time to manage yet another resource that he will have to learn.

Based on very preliminary conversations, it sounds like we'll be going with ESX although our Network Admin would prefer Hyper-V.

Even with SP2, you still need to tell SQL Server what it's max memory is. It will consume everything if you leave the max at the default. I have SP2...