SQLSearch will help you find these, but it can't help you fix them.

The issue is that it's not necessarily easy to determine what needs to be moved from the WHERE...

Note that you can stick the index rebuild in a maintenance plan by calling it from the Execute SQL task, or you can just put it in a job step.

Be careful about setting your own host. WordPress.com isn't a bad solution, and as long as you have a few people to admin it, it makes sense.

Just think beyond...

You can submit DCMAs here:

Blogger: http://www.google.com/support/bin/request.py?contact_type=lr_dmca&product=blogger

Wordpress: http://automattic.com/dmca/

I'll do those.

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.