GSquared (11/20/2009)

---

Steve Jones - Editor (11/20/2009)

---

I'll have to try milk on the steak. Haven't tried that one yet, though I do like it on a hot grill.

One other thing I'd...

It is normal for a query to take longer on the first run until the plan is cached.

Rebuild statistics is not always necessary as part of the rebuild indexes maintenance.

And...

http://gourmetmeatman.com/ROASTS.aspx

It's listed as a Roast, but it is cut like a steak....

Lynn Pettis (11/20/2009)

---

Gianluca Sartori (11/20/2009)

---

Thanks Gus, I would never have thought of milk! I'll try and let you know the results.

My steak recipe is the shortest ever:

* volcano hot...

GilaMonster (11/20/2009)

---

That's...

Yes.

To get more specific, we would need table structures, execution plans, and indexes.

jasona.work (11/19/2009)

---

Steve Jones - Editor (11/19/2009)

---

SQL Server will not spread out to these files automatically, though if they're in the same filegroup, SQL Server will use the space in a...

Though the maintenance plan and ssis options are perfectly sound, here is a list of some possible scripts.

Yes, logic sounds good. I would enable the write cache

Yes networking issue. It really seems like it could be routing table or dns related. You will need to check your routers, dns and adsl setup.

Not a real fan of the BE SQL agent. Backup Exec is fine for doing the operating system and file systems. I have seen it cause performance woes.

I...

SQL may be able to handle that many tables. The problem is that these are tables being generated (if i understand correctly) through one of the Microsoft CRM products...

slightly different than the correlated subquery is the option of using a CTE. Use the cte to join back to the original table to get the results you are...

The SSIS package is the method I currently use. I use it for more than just getting DB listings. I have expanded it to be able to inventory...

Paul White (11/19/2009)

---

[font="Courier New"]Msg 530,...