Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql.error1623
Starting Member
3 Posts |
 Posted - 2011-06-06 : 16:01:20
|
| Hi All,Can any body tell me regarding INdex in SQL server 2005 management studio.I want archive some Data from table.Then I need to drop the index,delete the data and recreate the index.Is this correct,,..??If so can you let me know the process please..!!!Thanks in advance. |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-06-07 : 01:38:42
|
| Find out the name of the sql server - and obtain the logon credentials. You can now log on , and complete the tasks - 1)archive data 2)index management 3)index rebuild SQL Server management studio is a client tool used to connect to databaseJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
sql.error1623
Starting Member
3 Posts |
Posted - 2011-06-07 : 04:21:01
|
| Hi Thanks for reply..!!I have the Credentials.!!All i wanted to know is it necessary to drop a index before deleting some data from table..??If so why?What is the importance of Dropping and recreating the index..??Awaiting your reply.!!Thanks and RegardsSQL.ERROR |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2011-06-07 : 05:45:07
|
I'm not really the index guru here... but I'll take a stab.Two things:- If you are deleting alot of records, the overhead of trying to maintain the index while the delete is processed can slow the process- Also, if you are deleting alot of records, the likely hood of an index becoming VERY fragmented is relatively high, so the index would need to be defrag'd or rebuilt to make it efficient and useful againCorey I Has Returned!! |
|
|
|
|
|
|
SQL Server Management studio