The clue is in this bit

There are multiple entries because SQL Server is running a Parallel query across more than 1 cpu.

You're right, it is an interesting blog, as much for the discussion that follows, which shows the other side...

I don't think it's officially documented, but I've seen plenty of people use something like this:-

select number from master..spt_values

where type = 'p'

and number between 1 and 100

order...

Although this article relates to SQL Server 6.5, it does explain why physical_io isn't accurate, and I suspect it is also relevant to later versions.

http://support.microsoft.com/kb/170360

There is only one physical database... when you fail over, SQL Server is stopped on node 1, the disks containing the database are moved across to node 2, and then...

I'm not sure it's possible.

Unless somebody else knows of a way, you may have to resort to bulk inserting the data into a staging table, and then insert the data...

Assuming you are using BULK INSERT or BCP to do the bulk load, then have a look at BOL.

This is what it has to say about BULK INSERT

FIRE_TRIGGERS

Specifies that any...

I don't know of anything to update them directly, but the Aliases are stored in the registry at

HKLM\Software\Microsoft\MSSQLServer\Client\ConnectTo

... so a bit of registry hacking would probably do the trick...

The problem is that "OBJECTPROPERTY(id, N'IsUserTable')" is going to check against the id in the current database, not the id in db2.

Try this:-

if exists(select * from db2.dbo.sysobjects where id =...

If you don't like the idea of SSIS or Powershell for this task, you could use good old fashioned xp_cmdshell.

It's a bit clunky, but it's possible to load the contents...

Yes, frequently. If you create a row (in a table with...

Have a look at the "Options" tab on the dialog... you'll see checkboxes for triggers etc.

No... but if you need it, you can implement it via triggers.

You were probably using the .MasterDBPath property, which gives you exactly what it says, the PATH.

If you want the whole file name you will need to use something like this...

Are you sure that lack of memory is the issue?

In my experience, the performance problems that you describe "usually" come down to one of a few things

CPU - check this...