If we SET TEXTSIZE zero then only 4KB but default size is 2 GB correct.

it might be parameter sniffing.

Hi All, 
               After google "Parameter Sniffing" i got the following solution and its working fine with following command "OPTION (OPTIMIZE FOR UNKNOWN)".

Thanks...

Thanks Admin

Hi Admin ,

Thanks for the script ,i am new for index .i am getting...

Two weeks before come across these, Good one...:-)

Ya I found Mr. its CTE Correct? 🙂

Hello Mr. i am eager to know how the "-- build an inline fast tally table" works if possible could u please Explain:-)

Good One Mr.mister.magoo

Did u check "@Borrower_id" data type in Table used inside the SP.

Please see the Query result attachment..........

Yes happycat59 I got the Same Error......:hehe:

🙂 Good One Steve 🙂

Good one.

Hi Steve Jones,

i have tried the...