Post reply

Database(Query) Optimization...

  • April 25, 2011 at 12:14 am

    #236221

    Dear All,

    I explain more Details about my Project/database.

    i have develop on SMS System for one Marketing Company...Daily Marketing people Register his work through a sms.Doing SMS daily around 4000 Record Insert/Update/Delete... And lots of transaction table are connected in sms Table..

    For Example...His Product Details,His Attendance,his claim,his location,his Customer visits...

    Now We are Develop Report Regrading Our SMS System ...

    For the Report Query takes more time for Execution.... The output delay..

    Currently Our Database Size 3GB..And in database Design 1 Primary files,1 log file...

    Now Give Suggestion can i break database in multiple file groups...doing Creating multiple filie and filegroups is it possible to optimize our database..?

    or

    what is way to optimize Our Database?

  • April 25, 2011 at 3:04 am

    #1315331

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1097733-391-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply