sudhakara (4/28/2010)

---

Yes. That select...

Roy Ernest (4/27/2010)

---

Grant Fritchey (4/27/2010)

---

Roy Ernest (4/27/2010)

---

Grant Fritchey (4/27/2010)

---

The Dixie Flatline (4/27/2010)

---

Woods are good. They provide fuel for...

And you need to identify queries that using a lot of I/O to see what they're doing. You can track down the causes and address them.

Roy Ernest (4/27/2010)

---

Grant Fritchey (4/27/2010)

---

The Dixie Flatline (4/27/2010)

---

Woods are good. They provide fuel for fire and draw game...

The Dixie Flatline (4/27/2010)

---

Woods are good. They provide fuel for fire and draw game to your vicinity. ...

Adam Machanic (4/27/2010)

---

Lynn Pettis (4/27/2010)

---

Not only do you see a lot of homework/test questions here on SSC, but I have seen quite a few of freelance jobs advertised on freelancerer.com...

itskumar2004 (4/27/2010)

---

Grant Fritchey (4/26/2010)

---

I'm still confused by why you need to dynamically create views for use with your data. It's an odd approach, so I don't get what business need...

Brandie Tarvin (4/27/2010)

---

I know a SAN admin who holds on to information like a Scottish miser holds on to money. Anytime he's asked a question about setup, his first response...

Brandie Tarvin (4/27/2010)

---

Ahh. For some reason all the SANs I've come across use multiple disk controllers. I've never heard of one with only one controller, unless the SAN used logical...

Brandie Tarvin (4/27/2010)

---

Grant Fritchey (4/27/2010)

---

Brandie Tarvin (4/27/2010)

---

If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up...

Brandie Tarvin (4/27/2010)

---

If you have multiple physical drives, you might consider having a file on each separate drive to help with I/O. It might speed up processing a bit. But...

If you're keeping your database code in source control (which, if you're not, you should), you either need to use the drop/create or you have to maintain two sets of...

And when you're unsure of what the optimizer will do with a query, take a look at the execution plan. That'll give you the information you need.

Paul White NZ (4/27/2010)

---

Grant Fritchey (4/27/2010)

---

That's not even in the top 10. It's almost, almost, straight forward compared to some of the insanity I've seen at my company. No temp...

Everyone does it differently, so there's no hard and fast rule. Plus, it's really dependent on your business needs.

These are some general guidelines, but you'll need to customize them.

Run DBCC...