Search results for query: *

I have an application that has about 300 tables. approximately 200 of them have no clustered index. The application is using MS SQL 7.0, SP1. Is there a performance benefit to not using a clustered index? This became apparent as I was running DBCC Showcontig on my tables. Many are highly...

I have run sp_helpindex 'TableName' on a table in a production database. It returns over 20 indexes with a description of "nonclustered, statistics, auto create located on PRIMARY" These indexes cannot be dropped. "Drop Index TableName.IndexName produces "does not exist in...

I am preparing to replace my existing SQL 7.0 Server with a new, bigger machine. I want the new server to use the same name and IP address as the existing server so the applications which are using this server will not see any difference. Any ideas? Thanks Lou Burgoyne Applications Administrator

I have data in relatively static table. I have found that it has been inadvertantly deleted. The problem is that it appears to have been deleted some time ago (10 days). What I want to do is take an existing historical backup and restore only the affected tabel, not the entire database...

I am working on a recovery plan for a production database. I have a valid backup and can restore the database to an alternate server. The Problem: A User ID exists for the database, but no Login ID exists for the server. Adding the Login ID manually to the new server doesn't work for two...

I have a SQL server serving a production application. SQL 7.0, SP2 on Windows 2000 Advanced Server, SP1. The server itself supports multiple processors, but it currently only has one. Is there anything that I have to do to the SQL server or the databases to utilize another process once it...