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.

SQL Server instances take the name of the windows host. That could be a real host, or the Windows cluster.

A 2 node cluster has 3 names. SQL Server responds to...

If the data and logs aren't separated physically, then you could have an issue. I haven't worked with virtual drives. Typically you would have two arrays from one controller (or...

Confused. Why do you not insert the values into TableB first?

Developer Edition has all the Enterprise features. Use that on workstations.

I believe the EULA prohibits running a production system on Developer, so please don't plan on that. If you have...

Make sure you have backups, test lots as Grant noted (run your application against an upgraded database ), and follow the Upgrade Advisor.

I'd agree with Lowell. There isn't a way to do this on a field, you'd have to build a UDF or code that would check to see if the next...

It's possible there is a delay in the space getting released from inside the table. Is this table the size of your tempdb database?

Tempdb needs what it needs. Any...

How would you not be able to access the cluster? If you're setting it up, then you pick a non-used name for the cluster. Not an existing Windows host.

For the...