Christopher Stobbs (6/18/2009)

---

the variable be assigned the value of every row, so the last row return is what the variable will be.

Because a table has no Order and you not...

I was just wondering why it should be 4 and not 1, 2 or 3?

No specific reason why I would expect 1; was expecting this since this is the first occurence in the table which satisfies the name match.

WOW! I'm waiting for questions from you guys!:-)

Thank you for all this wonderful information!

I apologise for such a sloppy question. The thing I wanted to mainly emphasise with this question was that "correct datatypes be chosen so...

easy one! option 1 is the only answer that satisfies the ORDER BY!

😀 nice!

Thanks for the compliments!

Nice video. Could you post the link to the earlier video please?

In the "Events Selection" tab of the "Trace Properties" window, right click on Stored Procedures and click on 'Select Event Category'. You can find the "RPC:Starting" you are looking for.

You's need to analyze the queries that are being used and then create the indexes accordingly. The link below would be a good place to start off with indexes:

I thought this might be a good place to share this link as it would be very useful to the newbies. Have I posted in the wrong place?

This may be a good place for you to start off with SQL Server Indexes:

http://www.sqlteam.com/article/sql-server-indexes-the-basics

Thanks Flo! Perfect! 🙂

Aah, here's what's to be substituted into @xml.