brigade

Thanks Steve

downgrade

SQL 2008 R2 has an attribute in sys.dm_os_sys_info called virtual_machine_type. That field should give you the information you seek.

Yes. You can do that.

Thanks for the question.

degrade

anti-punctual

interesting question.

Thanks

that command is for perfmon to refresh the perf counters.

There should be no negative impact

See if this helps even though it is for SQL 2005

http://blogs.technet.com/b/industry_insiders/archive/2008/10/01/sql-server-using-ssis-to-retrieve-data-from-as400.aspx

try this command

lodctr /r

You may experience degraded performance in some areas. Monitor it for slow response. You may have something that is still running causing the cpu spike. See if...

SSIS will be something totally different. But here is the mod for the agent jobs.

Declare @VName varchar(256)

Declare Findlinked cursor

LOCAL STATIC FORWARD_ONLY READ_ONLY

FOR

Select name AS...

You can create a stored proc that utilizes the new linked server on the server where this new linked server is defined. Then from the first linked server you...