ChandaMAMA (4/14/2009)

---

I read the article, its very interesting, what i guess is that there is no thumb rule for creating index you have to analyze data and then create index.

Its...

Did you read those articles?

If, in your example, you have an index on FName and a second index on LName, then your query may be able to use one of...

It can, providing that the query doesn't return too many rows.

Have a read through these, they're not beginner-level articles, but they may be of use.

http://sqlinthewild.co.za/index.php/2009/01/19/index-columns-selectivity-and-equality-predicates/

http://sqlinthewild.co.za/index.php/2009/02/06/index-columns-selectivity-and-inequality-predicates/

http://sqlinthewild.co.za/index.php/2009/01/09/seek-or-scan/

grngarlapati (4/14/2009)

---

Now the above proc is working fine, the prob is i want to call that proc in a selec statement

like

select ID,(exec Proc ID) as Name from Table

I dont...

Sorry, I'm not following you. Could you maybe show the procedure and explain a bit more what it currently returns and what you want it to return?

Delete them

.mdmp file are memory dumps, from when SQL has access violations or other similar errors. If you're getting them currently, call MS's customer support. If they're old and the...

A certification alone without any experience is unlikely to get you anything than a very junior job, if that. The certs are designed for people who have some experience (a...

There's a lot more to consider than performance.

Truncate deletes all the data in the table. Delete can have a where clause allowing conditional deletes.

Truncate does not fire triggers, delete does.

Truncate...

Why count(userid)?

j1a4l0: What do you want returned for a user that has no news items?

http://www.microsoft.com/learning/mcp/certifications.mspx

jcrawf02 (4/13/2009)

---

Um, let's see, 1.5 hrs to Toronto, 6ish hours to Vancouver. But that was in anticipation of a cruise to Alaska, so hardly stressful. Like I said, spoiled rotten....

I can't help you with that. Mail or PM the Simple Talk people (Tony Davis)....

Please post the table design, index definitions and the estimated execution plan (saved as a .sqlplan file, zipped and attached)

If there query blocked by some other connection?

Is that SELECT *...

Bob Hovious (4/12/2009)

---

But I thought you or Gail said that you couldn't count on anything but a clustered index or an ORDER BY clause to maintain sequence. ...

There's no upgrade exam from 431 to 432. The upgrade is from the 2005 ITP certs to the 2008 ITP certs.

If you've studied for the 2005 exam, write the 2005...