No offense intended, Tom. However I'd say that most of the people in your generation were more pioneers...

that was cool. I happened to turn on the last 2 min of the UM/ND game last night to see a stunning finish: http://sports.espn.go.com/ncf/recap?gameId=312530130

We have free books here at SQLServerCentral, but those are only on limited topics.

However the cost of a book, US $50, is not much for your career. If you...

There's no such thing as an archive database or a regular database. Just like there's no "sales" database or "customer" database. These are arbitrary terms we are giving to the...

syen (9/9/2011)

---

I imagine that HR's job must be pretty tough. If you aren't working at a software/database centric company, your HR probably gets 1000's of applicants and since they...

djackson 22568 (9/9/2011)

---

The suggestion is highly contrary to other suggestions you have made. Think about it - you frequently bring up how business is expecting more and more from...

My company, Red Gate Software, sells a product that does comparisons. It will give you the schema differences. They have a product for data differences as well.

Are you looking for...

Let us know if it works. I was thinking that OUTPUT might help here, but couldn't figure out how it would work in one statement. This should be good for...

You have to click the My Posts link above. The postback won't work.

My guess is the virtual disk is a layer on the array, but hard to know. Sounds like what SAN people do sometimes.

Post back if you learn something. Curious to...

It depends on the size of the load, number of indexes, etc. I've seen it be faster (significantly) on the drop indexes at times. However not always.

Test

You can see all the topics you've posted to using the "My Posts" above (__doPostBack('butShowMemberPosts',%20'4');)

For the subscriptions, the control panel link above (below your name) takes you to a menu....

Apart from individual DDL and test data, your logic seems incomplete. I would revisit this and better explain what the process is for computation.

You can use CASE for some of...

There's no GUI support right now.

Make sure you've created the filestream filegroup first, then you can set this in the T-SQL for the table.

For subscribers, MSubscriber_Info seems to be what you want: http://msdn.microsoft.com/en-us/library/ms179868.aspx

No idea on the distributor.