you better rename the sql server also

Renaming:

sp_dropserver 'old_name'

go

sp_addserver 'new_name', 'local'

go  

+ restart sql server

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B303774

Is this using an Oracle stored procedure?

I'm curious as well.

*I have to try this one out

http://objectsharp.com/blogs/matt/archive/2005/06/13/2221.aspx

The wizard has an option keep existing indexes.

You may set it to off and view the changes/proposals.

Can you elaborate

I get a good resultset but the problem is 'm databinding using a datalist.After binding i don't get the fields k_seas_avail.DescID,seas_id,season,twin set correcty i only the values for...

Indexes are only uses when the time using the index + looking up the linked records takes less time than a table scan (where one can read bigger chunks).

One decisive...

This site has a tutorial for sql server administration;

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=177

Do you plan to use a gui (SQL server enterprise manager)  to manage the database/users or via T-SQL statements (query analyzer ...)

*adding users/roles

http://www.sqlservercentral.com/columnists/awarren/loginsusersandrolesgettingstarted.asp

*The books...

You could install sql server express 2005 http://msdn.microsoft.com/sql/express/

The documentation you can download at

http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en

With this tool you can manage the express database

http://www.microsoft.com/downloads/details.aspx?familyid=82afbd59-57a4-455e-a2d6-1d4c98d40f6e&displaylang=en

if you need to test specific...

*One way could be with setting permission based on an application role

in query analyzer they will need

to execute sp_setapprole on the connection

*you have the

APP_NAME ( )  function  that...

Are there any char/varchar columns in the table?

If you generate the create table scripts for both tables, it is an exact match (except for the indexes)?

The cost% is to be taken with a grain of salt.

Table scan, index scan... generally give a better indication.Usually the query with the fewest reads will be faster.

What was the...

Welcome.

Have a look at

http://www.sql-server-performance.com/query_execution_plan_analysis.asp

Performance is mostly based on the amount of reads (I/O) and then cpu/duration.

If possible avoid the use of cursors(very important),record by record based solutions and use...

I don't know (perhaps detaching/attaching the database)

I've also this message when a part of the database (like an index) became corrupt.

in sql 2000 you can find the job histories & outcomes

in msdb.dbo.sysjobhistory

the count(*) might cause a table scan

the exist clause stops when it finds one