Yes, you're right Gift, I can connect to Perfmon from within Profiler/Tool menu, but it still shows only MY LOCAL PC counters, despite of the fact that I have 2...

Surface are configuration is not a problem. The problem is that I don't see something like "Connect to server" anywhere in the Perfmon application. The only counters that it shows...

I usually use sys.sysindexes system view and/or sp_spaceused procedure.

...

Where not exists

(select pk

from tbl2

where tbl2.pk = tbl1.pk)

First and most important thing in this undertaking is careful planning. Prior to making decision you have to collect a lot of information for each server. It may include, but...

-- You can try this approach:

select * from

(

select

rn=row_number() over (order by column1),

*

from table1

)t1

join

(

select

rn=row_number() over (order by column1),

*

from table2

) t2

on t1.rn=t2.rn

That's OK, Michael. That example assumes the same - passing actual XML structure as an input parameter:

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/ea58e90c-0a2a-4c8f-a7d6-d61618c2d11c.htm

1. You create a S.P. with declaring a varibale as XML or nvarchar(max) data-type.

2....

Yelena,

There is a good article about SQL Server consolidation in May 2007 issue of SQL Server Magazine. If you are subscriber to paper edition, you can read it online too:

Use function OpenXML. B.O.L. has good examples on it.

begin try

drop table #test

end try

begin catch

end catch

create table #test(c1 int)

You can also use new 2005 dynamic views :

sys.dm_db_missing_index_group_stats

sys.dm_db_missing_index_groups

sys.dm_db_missing_index_details

- to determine missing indexes,

and

sys.dm_db_index_usage_stats  - to find unused indexes

begin try

drop table #help

end try

begin catch

end catch

create table #help

(type_name sysname,

storage_type sysname,

length int,

prec int,

scale int,

nullable varchar(3),

default_name sysname,

rula_name sysname,

collation sysname null

)

insert into #help

execute sp_help 'int'

select type_name, length from #help

Try this:

insert into NEW_TB field

select

new_number=1,

new_date=getdate(),

user='midan',

sn,

fld1,

fld2,

fld3,

fld4

from TB_PARTS;

go 20

Yelena,

I don't quite agree with you.

The main issues which should be taken intro consideration at servers consolidation are:

-- performance

-- overutilization of server resources (including tempdb)

-- concurrency issues

-- availability

-- maintainability

-- network...

The difference between select count(*) and Table Properties (Row count) usually occured in 2000. Probably you upgraded  your database from 2000. Check your compatibility level.

In order to fix this difference...