in management studio:

- right click on the database name

- select tasks->shrink->database

- mark the option "reorganize files before ...."

- click [ OK ]

Make sure you're doing this outside production hours in...

how much free space is in your 184 MB datafile?

If you do a shrink with reorg (the only way to be sure unused space is released), your database will become fragmented. By rebuilding your indexes this fragmentation is (almost)...

Make sure there's enough memory available for the OS.

Make sure this is a dedicated server, remove all unnecessary programs/services which could eat your memory. Our memory problems were caused by...

You probably mentioned the "... a significant amout of memory has been paged out ..." errors you'll see in the errorlog.

The solution is simple:

1) make sure the Os has enough...

a: Yes the...

If these databases are critical, hire a consultant. Not getting personal, but it seems you're not really knowing what you're doing. You just can't do a database upgrade by reading...

Column_nameTypeComputedLengthPrecScaleNullableTrimTrailingBlanksFixedLenNullInSourceCollation

ITEMIDnvarcharno60 no(n/a)(n/a)Latin1_General_CI_AS

CostGroupIdnvarcharno20 no(n/a)(n/a)Latin1_General_CI_AS

LEVEL_intno410 0 no(n/a)(n/a)NULL

QTYnumericno1328 ...

Thanks for the replies. On t05 is a clustered index on (datareaid, itemid, recid), on T06 is a clustered index on (dataareaid,bomid,pricecalcid,level_,linenum,recid)

My version does a clustered index scan on t05...

Autoshrink enabled?

Not exactly knowing what you're doing, here are the steps for adding a new connection to Management Studio:

1) start management studio

2) in frame "object explorer", click "connect"

3) select "database engine"

4)...

http://www.sqldts.com, DTS backup 2000

You can prioritize a SQL instance, by enabling the server setting "Priority Boost" (server properties->Processors), but this could lead to other problems (like network problems), because in some cases, SQL...

If this is possible, I assume your database needs to be in FULL RECOVERY (hey, it's a production database 😛 )

Interesting thought, has anybody experience with this?

select * from master..sysaltfiles