Let's have a war

We can start it in New Jersey

We don't

really

need all these people

in the city

There's too many of us, there's too many of us, there's too many of...

A primary key and the index created in support of it are basically one and the same. Management Studio creates all the primary keys, by default, as the clustered index....

There can be only one!

Now back to writing about backup encryption.

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...