1
  • Using indexes in SQL Server 2005

    What is the main purpose of using indexes in SQL Server 2005?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Full text indexing in SQL Server Express

    Now, I've recently installed SQL Server 2012 Express Advanced Services, which is supposed to have Full-text indexing. I've already confirmed that it's running in SQL but when I try to create a full-text catalog, for some reason it fails. I continue to get this message: "Full-text is not supported...

    ITKE342,450 pointsBadges:
  • Creating clustered index on exiting table

    I have a SQL Server 2005 Enterprise Edition database table that has 768,526 rows in it with no primary key or clustered index. This database's logs are getting shipped to a disaster recovery server on an hourly basis. I need to create a clustered primary key constraint on this table; however when...

    Senyeart5 pointsBadges:
  • Using an indexer for SQL Server 2005

    Hi The application I work on is a Java web application with sql server 2005. A user can search for a document stored in a file server. When they search for a document, a stored procedure is invoked from the java code and an open query code is used to go to a catalog created by the indexer. The...

    Itquestion525 pointsBadges:
  • Fill factor on subscriber

    Hello, We have an OLTP application for which a majority of the database's tables are replicated between two environments. The publisher side is intended to handle the writes from users and the subscriber handles the reporting aspect of the application. The subscriber therefore is mainly read by...

    SuperCoolMoss140 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following