SQL 2K WITH SP2 ON W2K ADVANCED SERVER

Prakash

It returns the disk free space status you can fire this comand directly on master database. It don't harm killing this command.

Prakash

Thanks Antares,

It works.....

Prakash

Agree with Antares, Only thing is select into should be fired before you start transaction, If a transaction is started then there is no way to fire a direct query...

Is there is a negative side having 30*2 60 GB for TempDB?

Log files and data files are on the separate sanbox.

Prakash

Anyway I started performance monitor with network interface: byte/total sec. Need help if any other counter to measure this?

Prakash

veritas backup is what I am using for 500GB database

Prakash

Internal and external fragmentation, free disk space, statistics option on or off, different index on tables, Memory, CPU all this affects how sql generate plan to run a query.

Prakash

Just look into BOL for sp_addumpdevice

Hope this is what you are looking for

Prakash

There is a tool which create a dummy printer on machine name win2pdf. When you fire a printout and select this printer it copies the output to a PDF file.

Search...

I run these script to vreate filegroup

ALTER DATABASE CAPMANUAT ADD FILEGROUP FILEGROUP4

ALTER DATABASE CAPMANUAT ADD FILE (NAME = DAT1_FILEGROUP4, FILENAME = 'Y:\FL1_FILEGROUP4.NDF', SIZE = 500KB, FILEGROWTH = 10%) TO FILEGROUP...

select a.name, filegroup_name(b.groupid) from sysobjects a, SYSINDEXES b where a.id = b.id

and b.groupid = filegroup_id('Primary')

Try this to find out objects in any file group.

Prakash

Thanks Antares & Andy,

What I am interested knowing in is what is better CASE 1 or CASE 2 without any other changes.

All other aspects are taken care, the confusion...

Additional information asked....

1. Money is the main constraint so can't use win2k AS.

2. Using /PAE(AWE) swith to use extended memory.

3. All the processing happens in 9 days in a...

Try this way by alaising.....

UPDATE a

SET field1 = b.field1

FROM db1.owner.table1 a, db2.owner.table2 b

WHERE b.field2 = a.field2

Prakash