Thank you for the reply.. So dont we have any way by which we could know the length of contents of a text/image column.. suppose a column has 10kb...
One way of collecting output of sp_helptext is I create a temporary table and collect output in it.. any other ways of collecting the output for...
Thank you all for replying.. To Mr. ndinakar and Mr. Madhivaan How shall I collect the output of sp_helptext? (or any other sp for that matter) To...
There is one problem as Mr. chappy said.. How can I copy those sp which are larger than 8kb, as i cannot have a variable larger than 8000 bytes.. I...
Thank You Both of U for replying.. Ur suggestions helped me solve my problem.. Thank You again, kamlesh kumar
Can anyone plz tell me how to copy all the sp & views present in one instance of sql server to another instance.. But USING T-SQL and not through...
This expects two parameters (i) ProjectCode -- which will be current ProjectCode value (ii)prevProjectCode -- which will be previous ProjectCode...
Just a suggestion, I dont know whether this will solve your purpose Sorry if it doesn't As I'm new to this field.. change this part of code if...
Thanks To All Moderators and everyone else who took sometime to reply me back.. I think with this, I now know better about OPTION(FAST n) than I...
Thank You... Has OPTION(FAST n) worked for anyone ??????? If YES plz tell me how ???? Plz send me an example to try out.. If NO why is it present in...
I have checked plans for Graphical Query Execution Plan 1. without OPTION(FAST 10) : Number of records read which is pointed by the arrow is =...
SomeOne Plz help???? Thank You, Kamlesh Kumar
Those are not my queries, I got them from the below mentioned link http://blogs.msdn.com/queryoptteam/archive/2006/03/30/564912.aspx I have written...
You're sure you're not looking for a paging solution like for a web page? I didn't get what U actually meant by that? But my need is such that i...
Thank you for your reply Sir.. I found the following queries at http://blogs.msdn.com/queryoptteam/archive/2006/03/30/564912.aspx I tried with...
Thank you Experts for all your support.. But till now i'm not clear about whether OPTION(FAST n) really works or not.. So if possible can anyone plz...
This is the query i'm using select * from table_name where journal_id > 10000 OPTION (FAST 10) the first 10 rows of the result set are not returned...
I want the first "n" rows to be available as soon as possible.. Its OK for me if the remaining rows take even a little more time.. I used the query...
I think i should apologise for this.. Actually my query has a WHERE clause.. I would like to know how to use OPTION(FAST n) in addition to WHERE...
Separate names with a comma.
