I tend to do the backup and restore as well. The Copy Database task was flaky in 2000 and I never trusted it in 2005. Not sure you gain anything...

We have debated that here, and might. It's a somewhat long process to get it well integrated, and likely we'd want to scale our points up in other areas as...

I think you have two queries here. You want a count by employee, but then the last employee based on order. Is that right? Seems like you are pulling together...

What's "last". You don't show an ordering column. Or do you mean the counter column denotes which one is last? Is it the max value?

I always thought Steinbrennar was a PIA, but no denying he wanted to win and was happy to spend money to do so.

RIP.

The questions are not stupid, but it appears that you're asking about things without really doing much research, or you're making leaps that don't make sense. Why would you look...

I'm not sure what the last column in your output means.

Also, we are happy to help, but we shouldn't be doing all the work. You should attempt to run a...

What do you mean "first release"?

This applies to SQL Server 2008 RTM.

SQL Server 2008 R2 is a separate product. It is not a second release of SQL Server 2008. It...

I would do what Andrew has done. That's worked well for me.

One thing to be aware of is that you want the create table statements in the DTS (along...

You need to post it on the T-SQL Challenges site.

cold_blue (7/12/2010)

---

Hi Steve,

It's not feasible to run the package in both SSIS packages, it'll slow down the performance. It takes around 10-30mins to finish the package(for around 8k records)....

T-SQL Tuesday - Still time to enter.

blandry (7/13/2010)

---

...

Yes, techies are frothing at the mouth over cloud computing, but having attended two non-IT business seminars on it, few if any outside the techie-sphere are buying into it.

I...

Congrats!

Richard Gardner-291039 (7/13/2010)

---

The fundamental problem seems to be that when you're serving objects to thousands or millions of people you just can't afford the overhead of keeping track of each...