Sorry, yes scoped to SQL only. Tables/views/procs/functions. Not .NET code, which isn't handled in SQL Azure. That would be in Windows Azure.

Takedown submitted to WordPress and the person's company.

I have submitted a note to WordPress to remove this.

I concur with Sean. If I have

create procedure MyProc

@param1 int = null

, @param2 int = null

, @param3 int = null

as

If @param1 is not null

insert into...

The OUTPUT clause is a great way to handle this

http://msdn.microsoft.com/en-us/library/ms177564.aspx

You have two choices.

1. Use all 14 parameters, set them to NULL as a default, and insert them or process them as needed.

2. Use some encoding like XML in a...

In addition, why do you think this job is taking up all the CPU? Have you traced this when you start the job?

I don't think anyone would ever want to lose data, but it's possible and requires some expense to avoid. Synchronous mirroring is the only way I see to guarantee no...

I would have sworn that the RAID 1+0 was 4 in Wikipedia, and I have submitted a correction.

Use

select field1 + ' ' + field2

Sorry, it's low priority when compared with other things. It's rarely reported and I answer questions almost daily and rarely see it as well.

Ah, perhaps that wasn't a great picture. I thought it was funny. It came from a SQL Saturday presentation by Kevin Kline.

Doh! Fixed

I leave for a few days and this thread starts to sound like SQL-Seuss

Might read this and see if it helps: http://www.sommarskog.se/query-plan-mysteries.html