Excellent. Consider it borrowed. I'm working on the first draft of a review process for PASS and the new SQL Standard so I'll incorporate this. It's actually not too far...

I'm glad it helped. Understand though, it really is introductory. You're going to blow past it pretty quick. Come back and post when you have questions on details as you...

I'm aligned with those who don't see a special l33t forum for invited users, not that I'd get invited. Anything I'm going to post, especially questions when I have them,...

Yes, the best way to determine what needs indexing is to use Profiler, or TSQL, to create a server side trace to capture data over time. You can then run...

If the OUT process changes a lot of the data, especially if it does a lot of deletes, you could be seeing index fragmentation affecting the next process. Hard to...

Quite likely, but I'd test it very thoroughly....

Jeff Moden (3/6/2009)

---

Heh... what? They don't like pork chops? 😉

I told him to stop trolling way...

This will lead to table or index scans

and ProEmail like '%@%'

At this point, I'm calling this a troll.

http://www.sqlservercentral.com/Forums/FindPost670625.aspx

Remember, don't feed the trolls.

chrisau168 (3/6/2009)

---

Hi,

wanted to confirm some basic concepts about indexes.

my understanding of clustered index and nonclustered index is like this.

if I have a clustered index on column "a" and I have...

I don't like maintenance plans because they don't offer enough control. Instead, we generally write out our maintanenance plans and schedule. The creation is manual, but the execution is automated.

BTW,...

Lynn Pettis (3/6/2009)

---

Mangal9i (3/6/2009)

---

Yes my query little slow.

Talking about execution plan, run both my query and your query and see cost of the query.

Its 1% VS 99%.

I was not aware...

RBarryYoung (3/6/2009)

---

I think that some things should be pointed out here, lest someone reading these posts gets the wrong idea...

First, there is no such thing as an "MSDN MVP" it's...

GSquared (3/6/2009)

---

jcrawf02 (3/6/2009)

---

To you, Chris, or to someone who knows that they're doing....

Putts (3/6/2009)

---

Grant, I did create that missing index but, as you assumed, it did not help the performance.

I would agree with your sentiment that there must be something awry with...