OK, here is my answer. It is what I suspected.

http://www.mssqltips.com/tip.asp?tip1164

Problem

In addition to hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2...

Well, yes. that is the question. Standard edition can only be licensed for 4 cpu's. Does 2 dual core or one quad core fill that limitiation? Or according to licensing...

Thank you.

Yes, I know that. But will SQL Server 2005 Standard 'see' the additional 4 cores after adding the second processor?

Have you done this? I know waht the documents say. I'm...

OK, unfortunately when I tested it I tested it on a local sql 2005 express sp2a version and then a remote sql 2005 developer sp2a version and was able to...

Look at the Link technologies for VS.Net Orcas. I believe the proposed support for XQuery was dropped in lieue of this future capability.

http://msdn.microsoft.com/data/ref/linq/

Could LOB_COMPACTION on the indexes have anything to do with this?

I noticed the same thing, sorry I don't know the solution though. I haven't tried updating my sqlexpress with sp1 ctp though.

Good article. Quick question, has anyone ever experienced the case where the foreign keys ARE indexed but a table scan appears to take place on referential deletes?

If you create the table variable as described and then

exec(@str)

and then later

exec(@str2)

the table variable create in your first exec has already been destroyed, it's scope is only in the...

Declare @table - procedure scope

create table #table - connection scope

create table sometable - multi connection scope

exec('somestring') operates on different scope than the parent process

The end user has the oportunity to install the target database on either the same server as the source database or a remote server. The script has to be able...

And that was a basic answer

Showcontig will not show usable statistics for heap indexes. If you are looking at fragmentation statistics for your heap indexes then they probably won't change after doing a dbcc dbreindex.

Slight modification from table variable example:

declare @Import table

(

 rownum int IDENTITY (1, 1) Primary key NOT NULL ,

 Email nvarchar(255)

)

insert into

 @Import

  (Email)

 values

  (