Jack Corbett (8/16/2010)

---

For choosing sessions, I personally think that having a selection committee nominate the top N for each category and then allowing the community to pick is a good...

First the Summit is typically around 1500 people that pay. Leave out volunteers, speakers, and that's about what the Summit is. Sometimes smaller. I suspect the Rally will be smaller,...

Home, and glad to be here.

The same article can be sent to multiple subscribers.

You set up a new subscriber, point to the existing articles. You can remove the first subscriber, or leave it there.

I'll play, and I'll toss in a prize.

Honestly, this is a place I'd use a CTE since it's cleaner, IMHO, to read. And it's becoming a bit of a convention in code.

With W (applnbr, application_count)

as

(

...

I'll see about sending an email/digest out.

This is one of those things that I'd like to push a little, experiment with, if I make it on the board. If not,...

I think the SQL Rally is designed to "try" some things out that don't happen at the Summit, and get more speakers there. Personally I'd like to have people submit...

I think SSWUG is shaky, ethically. It's not illegal, but it feels like a trick, or scam. I clicked through, got a page to "register" for free, to get to...

Yes, you can back up and restore a database that has CDC enabled.

Yes, just setup a new subscriber for Server C. Then remove the subscriber for Server B is you want. You can replicate to two servers.

I tend to agree with Jeffrey. I use domain accounts, no domain permissions unless needed, and let Configuration Manager assign permissions.

I do separate out SSAS or Integration Services, but typically...

Upgrade Advisor here

http://www.microsoft.com/downloads/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en

Ultimately, you have to look out for yourself. That's your financial, and moral, health. What the contract says is not always the thing you should do.

I'd go to the recruiter...

With what you've got there is essentially select count(a.*), count(b*)

First, get the data back. My guess is you want something like:

select a.applno

from application a

inner join contacts...