I may be wrong and cannot recall a spot in BOL that says for sure but this is based on their permissions in the database. I believe as long as...

Unfortunately even thou Text is a usable variable type for a SP and it can be an OUTPUT variable you cannot do assignment beyond the variable itself, so what goes...

First off I would suggest you keep Jr and Mid level grade folks in mind. Many of these things they may know but have not yet been exposed enough so...

SInce I had to do this in  SQL 7 the best way I found was to use a and insert from a starting point then join the temp table to...

Take a look here

http://support.microsoft.com/kb/841776

Right off this will give you the thread a spid is on at the moment run.

DBCC SQLPERF(THREADS)

However I forget which tool right off will tell you which thread is attached...

I believe that will meet your needs best as well.

Did you take a look and compare the excution plans with and without the condition. If the condition increases the time you will see something change in the execution plan...

Could need to have sp_updatestats and DBCC UPDATEUSAGE ran. Could be sysindexes is not reflecting properly and this may solve. Try it and let us know.

However I would suggest he did potentially dig himself a hole.

From what you said.

1) It is Firefox.

Issue is firefox is designed to be self contained and not rely on system...

First the funny thing is I didn't even know it existed in T-SQL until about a year ago when someone posted a piece of code containing it somewhere I was...

Would be really nice if MS offered other types of indexing methods and would allow you to have more custimization over indexing.

The you just need to add that into the joins in the from section (test with a Select statement first and do just like I noted with that additionally.

Oh yeah and if you find that the contrator did not give you a valid answer your contract should allow you to void payment for failuer to fulfill their duties,...

Couple of things here.

1) You will need to add the WITH RECOMPILE option to the SP to ensure it never tries to use a stored execution plan for performance reasons.

2)...