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...

You could join with the information_schema.columns to get those names, but it might be easier to do it manually if you know the columns and are writing the code:

select name...

Dont' forget heartbeats, which you usually want on a separate network.

We have a three part series on building a 2 node cluster that should help you: http://www.sqlservercentral.com/articles/Clustering/73994/

You haven't explained what you issue is, nor what the conditions mean for the logic. You need to stop and go over the functionality you need, build an algorithm in...

Did you upgrade to R2? are you sure the TF is still enabled?

If you can have an archive offline, just take a backup and store that. If you need it online, create a new database, as Remi and Grant suggested, and then...

The physical separation on drives is more important than the controller. While you could saturate the controller's bus, usually you get more bottlenecking on the drives themselves. You'd have to...

We've talked about it. It's quite a bit of "touching" of the code, so we have been debating whether we want to undertake major changes in the forums, or add...