Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
Question about SqL Server

已锁定 Question about SqL Server

  • Monday, September 28, 2009 3:37 PM
     
     
    Sign In to Vote
    0

    I am gernating the ID of tables by using select Max(s_no)
    system is taking time in geranting the ID of many tables as these tables contains lacs of record.Indexing is already there on these tables

    Please tell How system can be made faster?

       

    All Replies

    • Monday, September 28, 2009 5:06 PM
      Moderator
       
       Answered
      Sign In to Vote
      0
      Hello,

      I suggest that you post your SQL specific questions to the SQL Server forum. This particular forum is for discussions around using SQL Server (standalone or Back-end database) with OCS 2007 RTM / R2.

      Hope this helps. Thanks.

      TechNet Forum Moderator - http://www.leedesmond.com