If it needs to be clustered, always add the "clustered". Defaults can change over time.

You could look for some spacemonitoring-scripts.

A basic loop across the tables and

the stored procedure sp_spaceused might work also.

*edit*

have a look at http://www.sqlservercentral.com/scripts/tables/62545/

There is the deny right that overrules allow. If an user is member of a role which has deny update on table X, the user can't update it even when...

Doesn't AWE require fixed memory instead of dynamic allocating?

Up to date with servicepacks (sp4 has an AWE bug fixed by a hotfix)

Please share your solution

Can you give an example of phone1 and phone2 and the desired result?

Wild guesses:

update members

set [mobile]=phone1 + 'separator' + phone2

where ...

update members

set mobile=firstmatch

from members

inner join

(

select memberid,

CASE PHONE1 like ......

Seems like an ODBC-function.

Is it one table in particular? If so, there might be a corruption problem.

Does the servicepack level of em matches the service pack of the sql server?

Be aware that em...

--sample data

create table reservations

(

RESNO int

,ROOMNO int

,CHECKINDATE datetime

, CHECKOUTDATE datetime

)

insert into reservations

select 1,1,'20080101','20080201'

insert into reservations

select 2,1,'20080301','20080401'

insert into reservations

select 3,1,'20080115','20080116'

insert into reservations

select 4,1,'20071201','20091201'

--gives conflicts

--res1= usually minimum reservation

--res2= usuallymaximum reservation time

select res1.*,res2.*

from reservations...

update mytable

set column1=value1

,column2=value2

,column3=value3

where pkid=recordtoupdateid ?

Have a look at the audit & performance tuning articles on

http://www.sql-server-performance.com/articles/audit/main.aspx

I don't have much experience in Oracle but you could start with the migration documents of Microsoft

to sql server

2000: http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part2/c0761.mspx?mfr=true

2005: http://www.microsoft.com/sql/techinfo/whitepapers/MigrOracleSQL2005.mspx

Importing views, stored procedures, functions isn't straigth forward because different SQL-dialects (TSQL vs PL/SQL ...). Have you tried copy objects?

The following link is the microsoft guide on how to migrate...

Looks like some job is causing troubles.

Have you an overview of that jobs/programs... are accessing the server at those times?

Does it occur daily? (perhaps a profiler trace might help to...

Have you checked your hardware because your database has quite some errors.

Other suggestions:

http://www.sqlservercentral.com/Forums/Topic477115-5-1.aspx#bm477258