User Profile

Collapse

Profile Sidebar

Collapse
logesh
logesh
Last Activity: Oct 31 '07, 04:28 PM
Joined: Sep 18 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • logesh
    started a topic rebuild
    in SQL Server

    rebuild

    can any one tell me how to use rebuil command for sql server 2000
    See more | Go to post
    • logesh
      started a topic optimization
      in SQL Server

      optimization

      hi,
      i have written a qurey to retive some data form a table,but i want the qurey should be more faster, i dont want to set index, other that that,if any.
      advice required!!!!!

      THIS THE QUREY
      ----------------------------


      select intpurchaseqty, strCurrencyCode as Currency,intDen omination as Denomination,ca se
      when strPrefix ='' then '0' else strprefix end as Prefix,strSrlno From...
      See more | Go to post
      No activity results to display
      Show More
      Working...