Thanks for the http://poorsql.com tip, didn't know this existed and it works like a charm.

Vera

Hi, thanks for the replies.

Yes, we considered using SSIS, but depending on the content of the excel sheet, we send a mail or not.

there is no GO after creation of table #B. In my opinion the select statements will fail with an error.

I didn't try it out but that's what I suspect.

Vera

Thanks, got it solved with DBCC SHRINKFILE (filename, size).

I tried a shrink but you cannot shrink to a size smaller than initial size.

The explanation talks about nchar, however the question is about nvarchar.

In my opinion the explanation is wrong and we should all get 10 extra points.

Can't select more than one with radiobuttons.

Hi Perry,

no, they are spread over the 6 blade servers.

Hi Perry,

we work with VMware version 4.

There are 6 physical blade servers with 2 quadcore CPUs per blade (=48 CPUs).

They host 11 SQL servers which have 16 CPUs assigned...

Thank you all for your interesting opinions and experiences.

Vera

This sure is an interesting topic.

I wrote about it in my blog ()

My question was more why there are so few women in ICT in general.

In my...

One of the conclusions of todays question is that a lot of people participate in the QotD and in the discussion. I think that's a good sign.

Vera

If you start with -1 and add 1, the correct answer according to me is -1, 0, 1.

I agree with a previous post that to get -1, -2 -3...

Belgium, the Flemish part 😛

Thanks for the advise.

Did exam 70-431 today and I passed.

🙂