Attila (8/14/2009)

---

My question is:

-Can I have a SQL2000 and SQL2008 default instances (with different ports, of course) in the same time on a box?

-What are the drawbacks of using SQL2008...

I don't think you can mentor yourself, but what I would do is contact people, ask questions, see if you bond with someone and can build a relationship. You might...

I'm kind of with Adam here.

I might go with mirroring, perhaps using an asynchronous mirror so you don't interrupt production if you have issues with the link. However I'd also...

I'd look at SSIS. If you put the tasks on designer without precendence constraints, they'll run in parallel.

They are used for different purposes. both copy data at periodic intervals, but they work differently.

snapshot - copy all the data at the interval as one batch. It's essentially an...

I'd agree with Mr. Moden and Mr Young on using lookup tables. And I'd encourage one of them to write something up on this.

Josh, If you have a URL, we'd...

I like the first suggestion from Jack, if that fits your business need. You want to be sure you won't have issues if the data grows to 5 (or more)...

user_name()

suser_sname()

Depends on what you want.

Best of luck.

I haven't tried the CBTs, so can't recommend one.

One other thing I'd suggest is that you work as a group, study style, and help each other.

I thought that test servers didn't need a 2nd license, in which case you could drop Enterprise there.

If not, developer edition makes sense.

It was introduced for data warehouses and cubes, offering savings if you store significant amounts of decimal data.

I think there are performance monitor counters for reads/writes for tempdb and full text.

Barry, thanks and feel free to complain. I know it's well meant from many of you.

The others, I tend to ignore, or argue if I think I can annoy them...

I lived in Carlsbad for a year. It's nice, but $$$. Also too windy and no winter, bugged me.

I think Denver is amazing, but no water. However we have enough...

First, read Jack Corbett's blog entry. http://wiseman-wiseguy.blogspot.com/2009/08/no-training-budget-still-no-excuse.html

Second, I'd honestly say that most of the exercises and things you need to do are practice with concepts. I'd recommend that you get...