Yuvipoy/Lynn,

I agree with both of you. Infact i'm checking my code that way only. However my concern is if SQL is giving such an efficient way of checking a code...

Yes, but then is it a known bug with SQL ? because sp_helptext is the most basic and efficient way of getting the proc definition.

Can anyone please help ?

"In corporate world, how should business intelligence be installed and used for development purpose when we already have our application productionized ? Currently neither we...

about the licence ; enterprise edition should do .. It worked for me , but it was for 2008 .. not sure about 2012 .. I think there is a...

Very good question. Also good way to show how values can be swapped. 🙂

WOW... good question. There is a say in Indian language "Savdhani hati, durghatna ghati" <not careful, accident happens>

Didn't thought of the alias thing, jumped to the answer and lost the...

Good question. I just guessed that it could be the case and bingo. I was on right track. 🙂

+1. Nice question.

Very good question. It occupied me for litlte more time than usual. 🙂

Thanks a lot for this good question. 🙂

Gail/Grant/Ed, I agree with you that it can be done.

However at times, these stupid policies made by self acclaimed DBA legends works against us. update statistics need alter table...

Grant, the link was really great. Shows the issues practically. There was the fix provided:

"The fix isn’t hard, a scheduled statistics update, maybe daily depending on when data is loaded...

Hi ugo_boy

These links might help:

http://technet.microsoft.com/en-us/library/ms189858.aspx

http://www.mssqltips.com/sqlservertip/1852/sql-server-2005-index-best-practices/

http://blog.sqlauthority.com/2008/03/27/sql-server-2005-find-index-fragmentation-details-slow-index-performance/

Grant/Gail, It's very very good article and...

Absolutely no idea about the question. Just guessed it right. 🙂