www.webdeveloper.com
Results 1 to 3 of 3

Thread: SQL-Server

  1. #1
    Join Date
    Jan 2005
    Location
    India
    Posts
    1

    Post SQL-Server

    Hi guys,

    Pls. clarfiy the following :


    Question : 1

    I am created one database with 35 tables and tables are indexed wherever necessary.
    After entering so many records in one table, (above 2 laks of records), the database gets slow even it is indexed
    for the particular table. Why it happens. How to solve this. When execute this table, it takes long time and sometime
    the system will be hanged.

    Question : 2

    In my system the sql server is installed in c drive ( C:\mssql7) and taken a backup and store a file with a.bat.
    The backup file is restored with another computer which is Sql server is installed in D drive ( d:\mssql). When try
    to restore it will give an error. Why? But at the same time, the file will be restored in another computer which is
    sql server is installed in c drive ( c:\mssql) it is restored. Why ?


    Bye

    Krishnasamy

  2. #2
    Join Date
    Oct 2006
    Posts
    1
    Hi krishnamurthy,

    i have the same type of problem.
    have u got the solution to this problem.

    plz letme know..

  3. #3
    Join Date
    Apr 2005
    Location
    Hastings, Sussex, UK.
    Posts
    244
    Try here.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles