.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

rebuilding index

Posted By:      Posted Date: September 06, 2010    Points: 0   Category :Sql Server
 
I am having a table with indexes and I run a SSIS package once in a month i.e is scheduled.So I want to drop the indexes before loading the data and rebuild the indexes after loading the data.Can any one suggest to drop and rebuild index.


View Complete Post


More Related Resource Links

URGENT - Run out of HD space whilst rebuilding an index

  
I just altered a table on my large SQL server 2000 database and now the database has been offline for ages and the hard drive as run out of space because of the transaction log size.What can I do!  Enterprise manager has frozen me out completely and theres nothing else I can delete to free up space whist this completes.I've not received any kind of warning and the HD is still being accessed by SQLserver.Do you think this will eventually complete?  Should I stop the SQL service.  HELP

Index Rebuilding in Logshipping

  
Dear All,

I have configured logshipping with stand by option for reporting purpose. Please find the configuration details as below as

Primary Server: SQL 2005 sp3 EE 64 bit

log backup frequency: every 15 min

Secondary Server: SQL 2005 sp3 EE 64 bit

restore frequency: every 2 hours

Mode: stand by mode(secondary server's db is in read only mode for reporting purpose)


here my questions  are

1. when i do index rebuilding operations on a table in the primary server, will the indexes on the table  in the secondary server also be rebuilt? i hope index rebuilding is fully logged operation. or do i have to configure the separate maintenance plan on the secondary server to rebuild the indexes?

if the database is in bulk logged mode what will happen?

2. how do i find when the index was rebuilt last?

Please help me on this.

Thanks in advance.

Regards,
Thayalan

how to create index for a column

  

Hi Friends,

                       I need to create the index for a column and accessing that in sqlserver 2005. Please any one help me.



Thanks..,


Deleting items from the index (custom protocol handler)

  
I created a custom protocol handler. I successfully emit entries into the index. I just can't seem to delete them during an incremental crawl.

I tried:

1. no emitting child item during the enumeration of child entries in a folder
2. returning PRTH_E_OBJ_NOT_FOUND from CreateAccessorEx

doing either 1, 2, or both did nothing. The entries are still there.

what i need to do to delete these entries from the index during an incremental crawl?

Thanks.

Ingest google Search Index into Sharepoint 2007

  

Hi Folks

 I am wondering  if there is a way to ingest google search index into SharePoint index such that when people search via SharePoint they see the Google results too… incorporated/federated inline with the SP results (not as a separate "box" ).

We have Google search in our environment and also share-point search. Share-point search for sharepoint site but Google search is for all other environments. Now i am thinking if we ingest the Google search index into share-point then may be its great deal to provide user a platform to search everything on one place.

 

thanks

ws


i am at entry level administrator

Can't start crawl becasue of index move operation

  

Hi there,

I can't start crawl task. The log says that "Deleted by the gatherer (The start address or content source that contained this item was deleted and hence this item was deleted.)" But I did not change the path of content sources and When I trie to start crawling job it says "Crawling might be paused because a backup or an index move operation is in progress. Are you sure you want to resume this crawl?"

What is index move operation? What should I do? I'll really appreciate the solution greatly. Thanks in advance.

 


allan

"Content for this URL is excluded by the server because a no-index attribute." in crawl logs

  

Hi All,

I am getting following error message in Crawl Logs

" Content for this URL is excluded by the server because a no-index attribute. "

Any help in this regard will be greatly appreciated.

 

 


Contact Selector - Form tab index is lost after selector resolves names on blur

  

I'm working with an InfoPath2007 form developed to be filled-out through the browser on a SharePoint 2007 site, and I'm testing using Internet Explorer 7.  It's a straight-forward form, with a number of text fields and two Contact Selector controls.

The issue I'm encountering is with the Contact Selector control, where if the actor only enters a partial name into the text-field and then TABs away from the control the form will perform its auto-postback to look-up and resolve the partial name (showing the name resolution dialog is necessary), and afterward the actor's cursor is focused on the next field in the form.  The actor can type text into the focused field, but any subsequent pressing of the TAB key returns the actor's focus to the browser's ADDRESS bar, which is incorrect as it should proceed to the next field in the form.  I understand that the Contact Selector needs to perform its postback to perform the name resolution (so that there is no way through the InfoPath form designer to disable postbacks for the control), but why does the browser not know how to continue the TAB order of the fields on the form even when a field has focus?


QueryEx (Search) results and Custom Page Index

  

Hi All,

I done a web part which allow the user to query the search.asmx. It return the result fine against which I apply some xslt. However I need a mean to create a Page index. I only return the result based on a range defined in the query.

I need somehow to obtain the number of result the search is returning in total against what I only want to display on the screen.

The only way I sort of figure to do that is by first make a search just to obtain the number of result it will return in total and then make a search defining a range.

Has someone done something similar?

Seve


QueryEX results and Custom Page index

  

Hi All,

I done a web part which allow the user to query the search.asmx. It return the result fine against which I apply some xslt. However I need a mean to create a Page index. I only return the result based on a range defined in the query.

I need somehow to obtain the number of result the search is returning in total against what I only want to display on the screen.

The only way I sort of figure to do that is by first make a search just to obtain the number of result it will return in total and then make a search defining a range.

Has someone done something similar?

Seve


SharePoint Calendar Error: The "ListViewWebPart" Web Part appears to be causing a problem. Index was

  
In one specific SharePoint calendar, on one specific week in that calendar when we select the "more items" link in the monthly view (or the expand all option) we get the following error:
The "ListViewWebPart" Web Part appears to be causing a problem. Index was outside the bounds of the array.

Web Parts Maintenance Page: If you have permission, you can use this page to temporarily close Web Parts or remove personal settings. For more information, contact your site administrator.
Troubleshoot issues with Windows SharePoint Services.

If we select a different week the expand and collapse works fine in that calendar.

Maintenance plan to rebuild Full-text index ? (SQL 2005)

  
Is it possible, through the GUI Wizard, to create a Maintenance plan that rebuilds (rather than reorganise/optimise) a Full text index in 2005 ? The full text index is based on one table only - so would using the "Rebuild index task" in the Wizard do the trick ? I wouldn't mind if the other indexes on the table were rebuilt too, but main concern in the Full text Index. If not - then I guess it would be a scheduled job which does a ALTER FULLTEXT CATALOG catalog_name REBUILD, but I thought it would be nice to keep it within the - Management - Maintenance plans - section of SQL Management Studio. Also - should this be preceeded with a transaction log backup ? Had some issues rebuilding them last night - seemed a Log backup was needed.

XML Index what for?

  
Hi, When you try to chose the a kind of index  to create a new index, you have four indexes types, namely The clustered index The non clustered index The XML index The Spacial index What the XML and Spacial indexes are used for?The complexity resides in the simplicity

SQL server index

  
Hi All, I am trying to understand some fundamentals in SQL server, I read that indexes (Set of pages) are arranged in B-Tree structure...and if it is a clustered index then we find the row of data at the leaf node or else a pointer to the data in case of a non-clustered index. Now my doubt is clustered index have the row at leaf level that means the entire table is available at the leaf nodes of the clustered index...then where are the non-clustered indexes leaf nodes pointing to  1) Are they pointing to the clustered indexes leaf node, as the rows are there. 2) If they are pointing to some other place then is this not duplicating the records (I do not think this is the case and am understanding things wrong..) Thanks in advance.. Bala

CPU killer when showing execution plan when having a missing index

  
Hi you all! Do you have problems with flickering and CPU getting high when you show the execution plan for a SQL Statement AND there is a missing index suggestion? See related connect id: https://connect.microsoft.com/SQLServer/feedback/details/360457/hovering-mouse-over-execution-plans-query-line-is-cpu-killer I really hope someone from Microsoft can take a look at this a give us a status update, over TWO years since I reported it and still an issue. Have you experienced the same? Please vote the bug up to "raise" the flag.Best regards Arild Røksund, Norwegian developer (SQL & .net), Omega AS (please Vote as helpful if helpful)

What is the meaning of Ascending\descending sort order of a column within an index

  
When I add a new index I can also specify the "sort order" as ascending or descending. What does it mean? does it affect performance? does it mean that the binary search tree will be set in a certain way?

SQL Query index

  
Hi, I am working on WM 6.0 MC75 device.  I am creating database using SQL compact server 3.0.  I have almost 30K records in device. When I execute simple query with Order BY it takes almost a minute to fetch data. Then I used index for where clause. It becomes fast and the time reduced to 7-8 sec.  But it creates problem in Insert/Update. As this takes ____ of time in inserting data to table. I dont know how to proceed further. As i stucked here. Please give ma a direction   Regards  Shruti
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend