Good for you Matt. And if you get up for it, use a human bike a few days. I used to ride 12m (about 20km?) to work each way. I...

Thanks David, and for the record, I pinged him on this. He's a SQL Ranger, a highly specialized consultant for MS that's gone through a 6 (or 8?) week intensive...

Glad you liked it and I wish MS maintained it. Definitely a pain for me.

I'll check on the proc generating the threads. Might have a bug.

For personalization, not sure what to do here. We send 230k+ a day out and the engine to build...

While I think the XBOX hardware loses money, live and the games make it up. Especially with the micropayments system they have with points, it's pretty slick.

I'm also seeing some...

I'm ok with not having Windows admin privileges IF those that do have them are on call and responsive when I need something done.

I'd be more concerned over having Windows...

Lots of problems here. Breaks SOX, so if you're public, this gets you an audit failure.

Time between detach and attach? Downtime for sure.

Testing? Developers can't test, or at the least,...

I'll try to track someone down at MS that can answer the "use" question.

At TechEd, in one of the tech talks, someone asked about hyperthreading, given all the multi-core options,...

Note that servers can mark themselves as "hidden" from -L and if any routers block 1434, this won't work either.

If you have SMS or someone can run a query, the...

That does sound strange. As Robert mentioned, I'd ask for more details on what you're doing in the wizard. I might even try a simple DTS package, with 2 connections...

I tend to agree with Jeff and try to create the table explicitly, then insert as needed, add indexes, etc.

I've seen so much on table variables v temp tables that...

Winston,

First of all good luck with this one. I took the 431, 441, 443, and 444 and this was the hardest one to me. It's two parts, one multiple choice,...

Not sure sp_who2 lists transactions. It lists active users. You can run dbcc opentran to see which transactions are open.

You can run profiler on a particular database to see if...

Why do you need to specify TCP: to connect? Is there something I'm missing?

You can use UTC time on both as the central time and then use an offset for local time.

Can you explain more about what the insert looks like and what...