PaulB-TheOneAndOnly (12/30/2010)

---

Thank you for the clarifications.

I'll say that... if you do not have a Test environment and you do not know the Queries and you do want to keep your...

Would if I had access. As it is, I have to wait...

GilaMonster (12/30/2010)

---

Stefan Krzywicki (12/30/2010)

---

PosNumber is a subset of CafeNumber and is tightly linked to it.

I'm thinking I can just make one Index with the fields

BusinessDate, CafeNumber, PosNumber, DField

and be done...

PaulB-TheOneAndOnly (12/30/2010)

---

Stefan Krzywicki (12/30/2010)

---

I'm currently transferring some tables from a large database on SQL Server 2000 to a new server, their own database and SQL Server 2008 R2. We don't...

Jack has a really good point. You said you're going to have 500 databases, that is a lot of databases to restore/bring back on-line if the server fails. You're going...

Koen (da-zero) (12/29/2010)

---

Jack Corbett (12/29/2010)

---

Hey, did you know that SSC is now a dating site? Here's a PM I got from lord.god90:

Hello My New Friend.

Good Day and How are...

As Gail has been saying, you need to test your specific loads and databases to know what the right proportions are. I'd suggest starting with one instance and several "typical"...

I think they may just be looking for confirmation that they're going in the...

WayneS (12/28/2010)

---

Okay, let's talk about blogging. I've seen a few posts from time to time, but I don't recall seeing anything dealing with:

(From a higher level) How to set up...

Yes, I read it. Interesting, but I wonder what the numbers...

Do you mean the Queries for SSC Community Participation article?

Yeah, I really liked how the OP pointed out that all Celko's assumptions were wrong. He seems to think...

This article might also help[/url] you figure out exactly how you want to go about the calculations.

Craig Farrell (12/16/2010)

---

Brandie Tarvin (12/16/2010)

---

Steve Jones - SSC Editor (12/16/2010)

---

I think Intellisense can make this just as bad. If you're used to using "p", downarrow to get to ProductDetail and...

GSquared (12/16/2010)

---

Brandie Tarvin (12/16/2010)

---

So, I have this query that yesterday is working fine and quick when I left outer join three tables. But when I change them over to inner...