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 testing in my [...]

Answer Question   |  April 17, 2012  1:55 PM
SQL Server 2005, SQL Server Indexes

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 [...]

Answer Question   |  March 9, 2009  7:12 PM
Indexed tables, Java applications, Java Web application, SQL Server 2005, SQL Server Indexes

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 users and should only be updated by replication. [...]

Answer Question   |  February 6, 2009  4:17 PM
OLAP/OLTP, SQL Server Indexes, SQL Server replication

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

Answer Question   |  August 21, 2009  8:29 PM
SQL Server 2005, SQL Server index strategy, SQL Server Indexes